topic Re: Refresh SharePoint List Dataset from Team's Workspace in Report Server

Refresh SharePoint List Dataset from Team's Workspace

Anonymous — Mon, 16 Aug 2021 07:15:39 GMT

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.

Re: Refresh SharePoint List Dataset from Team's Workspace

v-henryk-mstf — Wed, 18 Aug 2021 03:00:20 GMT

Hi Anonymous ,

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.

Re: Refresh SharePoint List Dataset from Team's Workspace

Anonymous — Sun, 22 Aug 2021 09:53:50 GMT

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.