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

[fileonlineservi]

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:-

Thanks

[v-tangjie-msft]

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. 

[fileonlineservi]

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

[fileonlineservi]

@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?

Thanks

[amitchandak]

@fileonlineservi , Clear browser cache, refresh and check.

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