Chris Webb's BI Blog: Keep The Existing Data In Your Power BI …
WEBApr 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 …
Chris Webb's BI Blog: Understanding The “The key didn’t match …
WEBApr 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: Speed Up Power Query In Power BI Desktop …
WEBJun 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 …
Nested Calculations In Power Query - Chris Webb's BI Blog
WEBMay 11, 2015 · Take the following input table: Imagine you wanted to add a column showing the rank of each row by Sales. In Power Query you would just need to: Load the data. Sort the table in descending order by Sales. Add an index column starting at 1, which is the rank. You would end up with the following output:
Refreshing Excel Power Query Queries With VBA And Power …
WEBFeb 27, 2022 · Yes, you can! Here’s a simple example. I created a Power Query query called GetTheDateAndTime that returns the current date and time in a table with one row and column. Here’s the M code for the query: #table(type table [RunDate=datetime], {{DateTime.FixedLocalNow()}}) Next, I created a VBA macro called RunPQQuery to …
Chris Webb's BI Blog: Optimising The Performance Of Power …
WEBJun 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
Referencing Individual Cell Values From Tables In Power Query
WEBSep 15, 2015 · GetMiddleCell. There are three steps here: Source reads the data from the Excel table. ChangeDataTypes sets the data types for the three columns in the table to be Whole Number. GetMiddleCell returns the value from the middle cell of the table returned by the ChangeDataTypes step. M allows you to refer to individual values in tables by a …
Passing Parameters To SQL Queries With Value.NativeQuery() In …
WEBDec 11, 2016 · I first came across the Value.NativeQuery() M function about six months ago, but it didn’t do anything useful then so I didn’t blog about it. I checked it again recently though and now it does something very handy indeed: it allows you to pass parameters to SQL queries. Before this, if you wanted to use…
Limit The Amount Of Data You Work With In Power BI Desktop …
WEBMay 24, 2020 · If you’re working with large amounts of data in Power BI you may find that you have problems because: Your pbix file is very large; You spend a long time waiting for refreshes to finish in Power BI Desktop – and if you’re developing, you may need to refresh your dataset frequently
New Option To Solve Problems With Power Query Not Loading All …
WEBJan 17, 2021 · Some interesting new Power Query functionality was released in the December release of Power BI Desktop (it's also in the build of Excel I'm running) that didn't get announced in the blog post but which will be useful for anyone using Excel as a data source. It is fully documented but I thought I'd blog…