Power BI does not have a rich R interface, but I found it does give reasonable error information. Microsoft recommends it is better to write and execute R Scripts in RStudio ( or any other R tools) before you use it in Power BI. R Script as a source in Power BI Desktop: Using R Script, I can download and unzip company house files. Power BI support documented very well regarding how to run R scripts in Power BI. However, Power BI supports R Script, which means I can easily automate my steps.Until Power BI Desktop supports unzip functionality, we can use new R Script in the Power BI Desktop. Chris Webb explains here, how to work with compressed files and why currently all compressed formats are not supported. Quite quickly, I understood Power BI currently does not support all compressed formats. At least, I wanted to unzip all files using Power BI. I have many files to work with, so I wanted to automate things.
But, I was not at all looking forward to downloading each file then unzip so that I can import into Power BI model.
I wanted to explore company house data using Power BI. That is what I noticed with Company House data. Most of the open data source providers supply data in a compressed format, especially when files are large.
0 kommentar(er)
