Menu
We have large csv files in Azure Blobs that we want to report on. It looks like with some M, we can use Power BI desktop to connect to the blobs and start to report on them.
We want to automate this process so I guess an option is to create our own pbix files and upload them.
Ideally, there would be a better Power BI API where we could configure the data sources server side in the same way as the desktop.
I've looked and the pbix files are zips with DataMashup also being a zip (standard openx files like docx).
Does anyone know of a NuGet package or details on how I could create dashboard in the latest Power BI using c#?
334
The file extension for Power BI files is “. pbix”. The . pbix files are highly compressed file types that contains all the graphics along with the actual data.
If you haven't already, install Power BI Desktop, and open the . pbix file in Power BI Desktop.
pbix file contains model data, where as the . pbit file contains no data. In addition, it turns out that the latter of the two contains model metadata in the JSON-based Tabular Object Model (TOM) format, which can be loaded by Tabular Editor.
The file format is not documented. We're working towards allowing you to create reports and dashboards programmatically, but there's no timeline on that yet that I can share. Right now, you should be able to use power query to load the file in question and then upload that to the power bi service to share within your team. Would suggest adding a request at support.powerbi.com so we can get back to you when we've added what you need.
59
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
