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
Posts Tagged ‘PowerBI’
Import text from pdf files in Power BI
While Power BI will soon provide functions to import tables from pdf-files, there might be occasions when you actually need to import text from pdf files (in unstructured form). With a little help from R (…) Read more
Remove repeating characters from a string in Power BI and Power Query
Repeating spaces often cause problems when cleaning up your data. My new function “Text.RemoveRepeatingCharacters” can come to the rescue here. Imagine you have a table like this: Challenge To further work with this (…) Read more
Create a function library in Power BI using M-Extensions
Having the ability to use own M-function the same way than native functions in Power BI and Excel has been one of my biggest wishes for quite some time. So I (…) Read more
Number.Mod rescue pack for Power BI and Power Query
If you use the M-function Number.Mod in Power BI or Power Query and expect the same result like in Excel or DAX, you are probably in good company. But if (…) Read more
How to open a complex JSON record in Power BI and Power Query
Today I’ll show you a very useful technique how to deal with a JSON record that contains a wild mixture of different elements like this: If you click on one (…) Read more