cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate V
Advocate V

Power BI Embedded - How does it refresh reports?

How can I ensure that Power BI reports published in Power BI Embedded shows the latest data via refresh? How would it work if a report is doing data import or DirectQuery?

 

  • If report is importing data - Does this work with Power BI embedded? How do I configure the scheduling of the data refresh in this case?
  • If report is using direct query - How does it work in Power BI embedded? I know that the gateway works with PowerBI.com service -- but Power BI embedded?

Regards,

P.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Power BI Embedded - How does it refresh reports?

@pmdci

 

As far as I know, three ways to refresh the data in Power BI Embedded.

 

  1. If report is importing data, recreate a pbix and re-import it to workspace, no schedule refresh.
  2. If report is using direct query, use Azure SQL database/data warehouse and set the azure credential via REST.
    Patch GatewayDatasource
    Data source connectivity
    Your report would be always up to date, no need to refresh.
  3. Additon to 2, if using direct query to any other on-premises source, there's no gateway supported like in Power BI Service. Say your report is using an on-premises SQL Server, set up an automation process to load the data from SQL Server into the Azure SQL database via an ETL tool like SSIS, then schdule this automation process to run in a certain interval to update the data.

View solution in original post

5 REPLIES 5
Highlighted
Microsoft
Microsoft

Re: Power BI Embedded - How does it refresh reports?

@pmdci

 

As far as I know, three ways to refresh the data in Power BI Embedded.

 

  1. If report is importing data, recreate a pbix and re-import it to workspace, no schedule refresh.
  2. If report is using direct query, use Azure SQL database/data warehouse and set the azure credential via REST.
    Patch GatewayDatasource
    Data source connectivity
    Your report would be always up to date, no need to refresh.
  3. Additon to 2, if using direct query to any other on-premises source, there's no gateway supported like in Power BI Service. Say your report is using an on-premises SQL Server, set up an automation process to load the data from SQL Server into the Azure SQL database via an ETL tool like SSIS, then schdule this automation process to run in a certain interval to update the data.

View solution in original post

Highlighted
Frequent Visitor

Re: Power BI Embedded - How does it refresh reports?

This is not solved.

 

DirectQuery has a lot of limitations.  A PBIX that has imported data can be uploaded to app.powerbi.com and a scheduled refresh ca nbe set up by providing DB connection credentials.  This is a must-have for the embedded option.  The idea of uploading a new file every few hours is ridiculous and not a solution in the real world.

 

Is there a feature request out there somewhere for this?

 

Cheers,

Paul

 

Highlighted
Frequent Visitor

Re: Power BI Embedded - How does it refresh reports?

This is not solved.

 

DirectQuery has a lot of limitations.  A PBIX that has imported data can be uploaded to app.powerbi.com and a scheduled refresh ca nbe set up by providing DB connection credentials.  This is a must-have for the embedded option.  The idea of uploading a new file every few hours is ridiculous and not a solution in the real world.

 

Is there a feature request out there somewhere for this?

 

Cheers,

Paul

 

Highlighted
Microsoft
Microsoft

Re: Power BI Embedded - How does it refresh reports?


@ddaas wrote:

This is not solved.

 

DirectQuery has a lot of limitations.  A PBIX that has imported data can be uploaded to app.powerbi.com and a scheduled refresh ca nbe set up by providing DB connection credentials.  This is a must-have for the embedded option.  The idea of uploading a new file every few hours is ridiculous and not a solution in the real world.

 

Is there a feature request out there somewhere for this?

 

Cheers,

Paul

 


Feature request for uploading a new file every few hours, Power BI Designer API, with this pbix can be created and refreshed programmable and then sent to Power BI Embedded workspace without human intervention.

 

Another feature request for gateway in Power BI Embedded, with gateways it will be possible to do the same refresh as in Power BI Service.

 

Though it sounds a little ridiculous, if Power BI Embedded is preferred and direct query is not acceptable, that is the only approach. Otherwise use Power BI REST API instead, the pbix is published to Power BI Service and the imported dataset can be scheduled to refresh.

Highlighted
Responsive Resident
Responsive Resident

Re: Power BI Embedded - How does it refresh reports?

I think I've heard that Microsoft is working on scheduled refreshes of "Import"-mode PBIX files, in Azure workspaces, for Power BI Embedded.

 

Also, there is this idea, where I added the following comment...

 

I'd like to expand on this idea, and give it my votes:

1. I would like to be able to use the UI in the Azure Portal to create/edit/delete Workspaces (and give them friendly names), just like I can do with the Workspace Collections that contain them.

2. Then, I would like to use the UI in the Azure Portal to import/delete/manage the PBIX files (Reports) that are consumed by Power BI Embedded.

And then, for bonus...once such scheduled refreshes are supported...I would like to use the UI in the Azure Portal to schedule refreshes of those PBIX files (for "Import"-type PBIX files, of course -- the ones that do not do "Direct Query"), similar to how I can schedule refreshes in the Power BI Service.

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors