Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

Refresh Sharepoint Online list data on embedded dashboard hosted in Azure

I've followed this example to get a dashboard embedded in a .NET MVC website. The dashboard is publised to an Azure Power BI workspace collection, then embedded in to a page in my website using the Power BI .NET libraries. The website has authentication (redirects to the login screen at to connect to Sharepoint Online to show list data.


I can refresh the data in Power BI desktop to show the correct, current data, but I can't find anywhere an option to refresh the embedded dashboard which stays at the data at the time the PBIX file was published to Azure.


Could anyone point me in the right direction to be able to acheive refreshing of Sharepoint Online data in an embedded dashboard?




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.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.