I want to use Power BI Desktop within my MVC application. All I could find about this is coupled with uploading the data [1], [2] into a cloud but that is not an option for me since I am working with sensible company data. Is there any workaround you know off?
And if not so are there any alternatives?
Power BI can cache up to 250 MB of data offline. Reports based on DirectQuery or live connection are not cached and are not available offline. Some tile types require an active server connection, so they aren't available offline; for example, Bing map tiles and some custom tiles.
Power BI service is cloud based, which is built on Microsoft Azure.
With Power BI Desktop, you can enter data directly and use that data in your reports and visualizations. For example, you can copy portions of a workbook or web page, then paste it into Power BI Desktop. To enter data directly into Power BI Desktop in the form of a new table, select Enter data from the Home ribbon.
I think what you might be looking for is using a Power BI Gateway. This will create a connection to your local data stores. In order to display a power bi report inside an mvc application you would still need to create the pbix and upload it to the power bi service. Using the gateway will allow direct queries to your local data, and not force you to store your data in the cloud.
Once you have the report uploaded to powerbi service you can follow his article here on how to embed a tile or report into your application.
I have successfully been able to embed a report into my MVC application using the above article, I however have not tried out the Gateway because my data already lives in azure.
Hope this helps.
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