Refresh SharePoint List Dataset from Team's Workspace

[jhlim]

Hi All,

My PowerBi Desktop had updated to version August 2021. I had published my report to Microsoft Team's under My Workspace. I went to the setting to configure database refresh, there are only Anonymous and OAuth2 authentication methods available. I was still unable to refresh the database from Microsoft Team via Sharepoint List. May I know is there any resolution to refresh the database for Sharepoint list?

Thank you.

[jhlim · Accepted solution]

Hi All,

Thank you all for the advice. I have found out the root cause. When I trying to edit credentials from Microsoft Team's workspace, the sign-in window will not trigger.

To solve this, I log on to Power BI Website and edit credentials from there. The sign-in window will trigger and I was able to select the credential accordingly.

Thanks again for the helps.

[v-henryk-mstf]

Hi @jhlim ,

According to the error message, do you add the mapping of each data source as you can see in the screenshot, the "Maps to" is empty.

and you can refer to the simliar solution case.

Unable to enter OAUTH credentials in data gateway ... - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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