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
Posts in Category ‘Power BI’
Extract only letters from a mixed string in Power Query and Power BI
This is a quick method about extracting only letters from a string. It is part of the Week2 “Preppin’ data” challenge. Task for extracting letters from a string Image you (…) Read more
Your Oracle data import in Power BI and Power Query is slow?
If you’re using the native Oracle connector in Power Query, you will probably experience a very slow import performance. Thanks to Tristan Malherbe for recommending to use the OleDB-connector in (…) 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
Convert DateTime to ISO 8601 date and time strings in Power Query
Often, when querying APIs it is required to enter date and time filters in ISO 8601 format . Today I show a quick way to convert DateTime to ISO 8601 string, (…) Read more
Retrieve header fields like response status from Web.Contents in Power BI and Power Query
Many Power Query function not only return their values as advertised in their function documentation, but on top of that a metadata record. This record is like tag that holds (…) Read more