CODEWITHSUNDEEP
powerbi
Peter Sun
Peter Sun

Reputation: 1835

PowerBi - Getting data to PowerBi Cloud

I am kinda new to PowerBi. I created a report in PowerBi Desktop that gets data from a SQL Server database. I also wrote a stored procedure that will gather the data I need for the report. It pulls 30 or so data points and is about 3 months' worth of historical data. Right now the report imports the data I need to create the visuals (pulling from a local SQL Server).

I would like to have other people view the report I created which means I would like to put this on the cloud. I have been reading up on Microsoft's page and other articles on the internet about real-time streaming, but I am unsure what method is best for me or there another method.

I am leaning towards this method, but I am wondering what others have done. What is the best way to get data to the PowerBi cloud for my situation?

Upvotes: 0

Views: 157

Answers (3)

Ian Ho
Ian Ho

Reputation: 21

You can use SSIS to perform ETL from different SQL data sources. The SSIS then send data to a Azure SQL Database. Your PowerBI reports can then access that Azure SQL to import data, apply necessary access control and refresh schedule.

Upvotes: 0

Alejandro Daniel Torossian
Alejandro Daniel Torossian

Reputation: 1

It seems that you only have to publish the report or dashboard in the power bi service.

Then you can create an app if you have the premium license and give the access to the users or just give the access to the power bi dashboard directly.

As Andrey comments you would need a data gateway to refresh the dataset

Upvotes: 0

Andrey Nikolov
Andrey Nikolov

Reputation: 13460

Real-time streaming has nothing to do with your case. Just publish the report to Power BI Service. There are few things to be aware of, though.

The published report (assuming the storage mode is Import) will contain the data as per the last refresh in Power BI Desktop. To refresh the data in the service, it must be able to connect to your on-premise SQL Server. The best way to do that is to install Power BI Data Gateway on a server in your network and configure it. Then you can schedule a refresh (1 time per 24h for Power BI Free account, up to 8 times for Power BI Pro, or up to 48 times a day if the workspace is attached to a Power BI Premium).

To share a report in Power BI service, you and all the consumers will need to have a Power BI Pro license. There are ways to share without the need to license all users, like Publish to web (Don't do that! First this will make the report PUBLIC so anyone can see it, and second you will need an approval from your Power BI admin) and embedding in an application (which requires programming skills).

Upvotes: 1

Related Questions