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: 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: 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: 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: Understanding The “The key didn’t match …
WEBApr 6, 2020 · One of the most common errors you'll see when working with Power Query in Power BI or Excel is this: Expression.Error: The key didn't match any rows in the table It can occur with almost any data source and in a wide variety of different circumstances, and for new users of Power Query it can…
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
Nested Calculations In Power Query - Chris Webb's BI Blog
WEBMay 11, 2015 · Quite often, in Power Query, you want to ‘nest’ calculations and transformations – apply them not across the whole table, but repeat the same calculation or transformation across multiple groups of rows within that table. Let me give you an example… Take the following input table: Imagine you wanted to add a …
Using SelectColumns() To Alias Columns In DAX - Chris Webb's BI …
WEBJun 1, 2015 · Here’s the output: The syntax for SelectColumns () is straightforward: the first parameter is a table expression, and after that there are pairs of parameters consisting of: A new column name. An expression returning a column from the table given in the first parameter. As you can see in the output of the query above, I’ve renamed the ...
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…
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 It takes a…