If you’re looking for Excel functions in Power BI, you will recognize that much more of them have been transformed to native DAX functions than to native M functions in (…) Read more
Posts in Category ‘Excel’
Workaround to connect to Power BI dataflows from Power Query in Excel
Currently, we cannot connect to Power BI dataflows from Excel Power Query. And as we also cannot use custom connectors in there, we need a different alternative. I’m going to (…) Read more
How to refresh Power Queries on protected sheets in Excel
When working with Power Query in Excel you might want to refresh Power Queries on protected sheets. But this will not work by default. Using a macro to temporarily unprotect (…) Read more
Improve File Import from SharePoint in Power BI and Power Query
When you use the UI to import files from SharePoint, you’ll end up with the Sharepoint.Files function. This function can become fairly or super slow when you use it on (…) Read more
Tips to download files from webpages in Power Query and Power BI
When downloading data from the web, it’s often best to grab the data from APIs that are designed for machine-to-machine communication than from the site that’s actually visible on the (…) Read more
Advanced transformations on multiple columns at once in Power BI and Power Query
You can apply simple transformations to multiple columns at once in Power Query using the UI only. In this article I show how you can apply advanced transformations on multiple (…) Read more