by Chris Webb | Mar 3, 2021 | Chris Webb
In my last post I showed how changing the various options on the AzureStorage.DataLake() M function didn’t have much impact on dataset refresh performance in Power BI. I’ll admit I was slightly surprised by this, but it got me wondering why this was – and so I decided...
by Chris Webb | Mar 1, 2021 | Chris Webb
Continuing my series on tuning the performance of importing data from ADLSgen2 into Power BI, in this post I’m going to look at the performance impact of setting some of the various options in the second parameter of the AzureStorage.DataLake() M function. In the last...
by Chris Webb | Mar 1, 2021 | Chris Webb
Earlier this week I gave a webcast on accessing web services with Power BI, Power Query and M on Reza Rad’s YouTube channel. You can watch it here: It’s an introduction to the subject: I cover the basics of using Web.Contents but don’t go into all the obscure details...
by Chris Webb | Feb 21, 2021 | Chris Webb
Here’s something that will Blow Your Mind if you’re a Power Query/M fan. Did you know that there’s a way you can get query folding to work if you’re using a native SQL query on SQL Server or Postgres as your data source? There’s a new option on the Value.NativeQuery()...
by Chris Webb | Feb 21, 2021 | Chris Webb
Power BI Premium has supported metadata translations – translations for table, column and measure names etc – for a while now. Kasper has a great blog showing how to use this feature here; Tabular Editor makes it very easy to edit metadata translations too. However...
by Chris Webb | Feb 14, 2021 | Chris Webb
Last year Marco Russo wrote a very useful blog post pointing out the performance problems you can run into when connecting to data stored in ADLSgen2 from Power BI when there are a large number of files elsewhere in the container. You can read that post here:...