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 …
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: 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 data warehouse running on a relational database ...
Chris Webb's BI Blog: Speed Up Data Refresh Performance In …
WEBMay 14, 2020 · First, Power BI has to check what columns are present in the table. To do this, it runs the query for the table but asks the Power Query engine to filter the table so it returns zero rows. Secondly the query is run again but this time with no filter, so all rows are returned, and this is when the data is actually loaded into the table in Power BI.
Chris Webb's BI Blog: Connecting To REST APIs With OAuth2 ...
WEBAug 29, 2021 · Chris Webb Custom Data Connectors, M, Power BI, Power Query August 29, 2021 1 Minute. There are a lot of articles and blog posts out there on how to handle OAuth2 authentication when connecting to REST APIs from Power Query in Power BI. However there is also a lot of confusion and contradictory information too so in this post I want to give you ...
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
Query Folding And Writing Your Own SQL Queries In Power …
WEBJun 11, 2017 · When you connect to a relational database like SQL Server in Power BI/Power Query/Excel Get & Transform you have two choices about how to get the data you need: You can choose a table from the database and then either use the Query Editor UI or write some M to get the data you need…
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…
An In-Depth Look At The Csv.Document M Function - Chris …
WEBMar 9, 2018 · The Csv.Document function returns a table, and the first (and only non-optional) parameter of this function is the source data in CSV format. Normally this is a binary value returned by the File.Contents function. For example take the this simple CSV file with no column headers and one row of data:
Chris Webb's BI Blog: Using Power Query And Microsoft Flow To …
WEBSep 26, 2018 · Here’s how: First of all I have a Schedule – Recurrence trigger, which allows you to run a flow on a schedule. In this case I’m setting the Flow to run once a day at 6am UK time: Next I have the all-important Transform data using Power Query action. At the moment you can only use Power Query with SQL Server data sources, and (at least ...
Skip to content