Chris Webb's BI Blog: Understanding The “The key didn’t match …
Apr 6, 2020 · That is odd it’s intermittent. Can you try renaming the query, then changing the query to a make table query, run it so that it produces a table with the same name as the original query and then see what happens when you refresh excel again? ie it’s pulling from a static table composed of the same data as it would have pulled in from the query.
Chris Webb's BI Blog: Keep The Existing Data In Your Power BI …
Apr 13, 2020 · [Update September 2023: now that Power BI is part of Microsoft Fabric, the new features of Fabric make it much easier to solve this problem as described here]. Power BI incremental refresh is a very powerful feature and now it’s available in Shared capacity (not just Premium) everyone can use it. It’s designed for scenarios where you have a data warehouse running on a relational database ...
Chris Webb's BI Blog: Speed Up Power Query In Power BI Desktop …
Jun 6, 2021 · +1 on Lutz request here – we also desperate to get gateway processing up. Power Query import method take significantly longer to process than native SQL query (i.e. writing sql queries to obtain data) using gateway (don’t see the same difference using desktop).
Chris Webb's BI Blog: Speed Up Data Refresh Performance In …
May 14, 2020 · It can sometimes be frustrating to work with slow data sources or complex Power Query queries in Power BI Desktop: you open the Power Query Editor, make some changes, click Close & Apply and then wait a loooong time for your data to refresh. In this post I'm going to show you a technique that…
Troubleshooting Power BI Timeouts, Part 1: The Two/Five Hour …
Dec 5, 2021 · There is also an oauth2 tocken timeout problem after an hour. This seems to impact pq running on gateway, but not on pbi desktop. This appears to be a well-known bug that Msft won’t fix.
Refreshing Excel Power Query Queries With VBA And Power …
Feb 27, 2022 · At the end of last year two new, fairly minor, improvements were made to Excel VBA's support for Power Query: you can now refresh and delete individual Power Query queries. These methods are available now for everyone using the Insiders build of Excel. Not particularly interesting on its own (I wrote a post a few…
Chris Webb's BI Blog: Optimising The Performance Of Power …
Jun 7, 2020 · Found the answer myself. To only expand a selected column from the second table using a Table.Join, the easiest is to pre-prepare the second table before the merge operation, i.e. a sub-select on the second table as below
Troubleshooting Power BI Timeouts, Part 2: Timeouts Specified In …
Dec 12, 2021 · In the first post in this series I showed how the Power BI Service applies a limit on the total amount of time it takes to refresh a dataset in the Power BI Service, except when you initiate your refresh via an XMLA Endpoint. In this post I’ll look at the various timeouts that can be configured in Power Query functions that are used to access data.
How Much Data Can You Load Into Power BI? - Chris Webb's BI Blog
Nov 21, 2022 · A quick thank you Chris… I’m below the beginner level when it comes to all things data and have been making very very ineffecient data sets using power query and power pivot (just downloaded power bi desktop.)
Query Caching In Power BI Premium - Chris Webb's BI Blog
Feb 18, 2024 · The more you monitor something the more likely it is that you’ll see something strange you can’t explain. This is true of several customers I’ve spoken to recently who saw DAX queries run in the middle of the night by people who were definitely not online at the time and who were worried about the resulting load on their Premium capacities.