Ken Puls’ Post

To refresh Power Query in #Excel, we click the refresh button. But... what if there were ways to automatically refresh #PowerQuery. No button clicking at all! (I like the sound of that) That's what we're looking at in this week's post. It covers 6 examples to demonstrate different ways to auto refresh Power Query. Check it out here: https://lnkd.in/euaPGWdb

Here is a greate article that explains how to auto refresh Power Query in Excel! 🤠

6 examples to demonstrate different ways to auto refresh Power Query.

Learn how to use #Excel Power Query's extract and split column features to extract delimited strings into their components with this step-by-step tutorial. https://lnkd.in/e594mAgV #techtutorial

Have you been using the new feature in #Excel where you can connect to a #PowerBI semantic model and create a single table?! If not - guess what?! It exists and it's cool! If so - guess what?! This feature is now also available in #ExcelOnline! Check out the latest blog post and let us know in the comments if you have questions. https://lnkd.in/gGgDKKg8

This is another great feature that's going to drive both adoption and usage. One of my favorite features of Excel has always been the ability to connect it to data, and this enables excel to connect to prebuilt models. This will allow and encourage even stronger data participation and data cleanliness. #FightShadowIT

A common request for users first working with a new report/dashboard is “how can I export this to excel?” This question might be the bane of many data viz developer’s existence, but this feature is a win-win from a lot of perspectives. Familiar exploration for excel users, data that remains up to date, and row level security that remains in place. I’m definitely a fan of features that reduce repetitive human process, improve data availability, reduce data duplication, and improve data security. Having all of those covered in one feature release is pretty cool. 😎

💥 📊 Exciting News! 🚀 Just dropped a new video on YouTube:  "Excel Power Query Fill Down and Up Made Easy"! 🔍💡 Unlock the secrets of Power Query with me. Check it out here ➡️: https://lnkd.in/dXfH73ST  📽️💥 #ExcelMagic #DataAnalysis #YouTubeTutorial #excel

Interesting FP&A-related article on how to automatically refresh a Power Query table each time you open the excel file. Two warnings to avoid future pain or disappointment, since it wasn’t covered in an otherwise helpful tutorial: One, make sure you also set to auto-refresh any merge query tables created with this table. This will ensure that source file updates will be reflected in any financial forecasts that are calculated from the Power Query tables. Two, the article recommends selecting background refresh for these updates. What this means is that any stakeholders who use the excel file will open the file and assume the data is current. Alternatively, you can turn off background refresh. This will cause excel to lock up momentarily while Power Query updates the tables. Control will then return to excel and the end user will view only current data. If “momentarily” translates to several minutes, your end users may be better served if you refresh the data manually after month-end close.

This creates a connected Excel workbook that shows a Connected Table just like we showed above, or with the Export to Excel capability when viewing an interactive reports. En savoir plus 👉 https://lttr.ai/AHhj4 #PowerBI #LiveConnectionOption #Excel #PowerBIExcel