Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to use Power BI Desktop without uploading data into its cloud

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?

like image 819
ruedi Avatar asked May 09 '16 08:05

ruedi


People also ask

Can Power BI desktop be used offline?

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.

Does Power BI need the cloud?

Power BI service is cloud based, which is built on Microsoft Azure.

Can you enter data directly into Power BI?

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.


1 Answers

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.

like image 166
JustLogic Avatar answered Nov 15 '22 10:11

JustLogic