Last seen: Jun 27, 2026
Hi Chris, Maybe the Table.Schema function will help as described here: Mynda
Great question, Puran. 1. At the 'Combine Files' dialog box select any item from the list, then select the folder icon above. The right-hand pane s...
Hi Rick, Thanks for your understanding. For others reading this thread, please note: all versions of Excel from 2010 onward have Power Query, in...
Hi Brad, Looks like they changed the way Power BI handles the appended state, country fields. Change the Data Category to 'Place' and that should f...
Hi Brad, Have you set the data categories in the modelling tab to 'Country' and 'State'? Mynda
Hi Rick, Thanks for taking the time to document the examples where there are differences. First let me explain what we're dealing with in regard to...
Glad you have a workaround. Perhaps you're not logged in to Excel at home and this is required for it to connect to the internet. I'm not sure to be h...
Great to hear you've got a good enough grounding now to continue yourself. To help with your understanding of some concepts; I cover the grouping i...
Hi Shannon, In the Power Pivot window it's on the Home tab in the 'Get External Data' group (second icon from the left in your screenshot, which sh...
Hi Rick, Office 365 automatically updates, although there are different 'channels' that update at different paces. For the most part what you see i...
Hi Matthias, It sounds like you weren't connected to the internet when you inserted the map chart. It requires an internet connection so that Bing ...
Hi Cory, Thanks for the mock up file. It helped a lot. You can do most of this in Power Query. Showing the balancing credit for Telephone and Compu...
Hi Mardi, The most efficent way is to do this with a measure in Power Pivot where the table containing the times is called CWR_Time and the Dim tab...
🙂 it's always most rewarding when you figure things out yourself. Well done!
Hi Cory, If you don't need the actual transactions in your model then you can use Power Query to group the data into the 100 'Direction' categories...