Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

Refresh a DataSet using Power Automate will not show the latest updates inside the Power Bi report

We have created a Power BI report named AuditLogs using Power BI Desktop >> the report has 2 SharePoint lists, as follow:-




then i implemented 2 Power Automate flows which get updated when adding/updating items iside the 2 lists >> the flows will Refresh the AuditLogs datasource as follow:-





but when i add a new item inside  sharepoint lists>> the power automate flow will run and will refresh the datasource succsfully >> but still inside the Report on the workspave it will keep showing the old data without any updates any idea?



now i went to the datasource and seems there si a data source credential issue >> so i tieed to using the OAuth2 method, but i got this error message:-







Community Support
Community Support

Hi @fileonlineservi ,


Please check if the sharepoint URL is correct. You can try connecting to a file on SharePoint using the same credentials and authentication on desktop and republishing pbix.


You can refer to the following similar posts that may be helpful to you:

Cannot schedule or demand a refresh for SharePoint... - Microsoft Power BI Community

Solved: How to solve the Power BI Service credential issue - Microsoft Power BI Community

Solved: Unable to connect and refresh a folder of SharePoi... - Microsoft Power BI Community


Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

@v-tangjie-msftthe URL is 100% correct as the same flow use to work well early on the same day

Regular Visitor

@amitchandakas i mentioned when i checked the dataset it mentioned that it has errors, when i check it further

seems there is a data source credential issue >> so i tieed to using the OAuth2 method, but i got this error message:-





not sure what i need to do futher?



Super User
Super User

@fileonlineservi , Clear browser cache, refresh and check.


Also, check the refresh history of dataset, make sure refresh was successful 

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.