Oauth2 credentials don't work after publishing Report to PowerBI Service

[Anonymous]

Hello,

I just want to preface this by saying that I didn't have any issues with publishing a similar report on a different laptop using a previous version of PowerBI Desktop. I'm not sure if this has any bearing on the issue I'm having, but I thought it was worth mentioning. So anyway, on to my problem. When editing my report in PowerBI Desktop, I have no issue with connecting my Sharepoint data source using my organizational credentials. But, after publishing into PowerBI Service, my organizational credentials seem, at least at first, to be accepted using the Oauth2 option from the drop-down menu. Though, when I go to refresh the dataset, my credentials seem to get rejected resulting in a failure to refresh, and upon going back into the dataset settings, my credentials seem to have been reset like I never set them in the first place. This is preventing me from keeping the report up-to-date as I can't refresh the dataset without the credentials being accepted and saved. If it helps to know, I'm using restricted share links generated from Sharepoint to retrieve my data in PowerBI Desktop prior to publishing. I've included a screenshot of the error message in the dataset settings in PowerBI Service. I hope anyone was some insight regarding what could be going on!

Thanks.

[v-qiuyu-msft]

Hi @Anonymous,

It seems that you use web data source to connect to OneDrive for Business file, right?The OneDrive refresh issue on Power BI Service already reported to product team, and they are working on it now. Currently, I haven't get the exact information about the fix release time. But I will keep an eye on this issue, once I get the information from product team, I will update here.

Thanks for your understanding and support.

Best Regards,
Qiuyun Yu

[Anonymous]

Qiuyun Yu,

Thanks for the reply. I look forward to hearing about a resolution to the issue with OneDrive data sources not functioning properly!

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

I test it again today and the web data source can be refreshed successfully after enter the credential use OAuth2 authentication. Please check it again in your environment to see if issue is gone.

Best Regards,

Qiuyun Yu

[Anonymous]

Qiuyun,

Sorry I forgot to reply to this. Yeah, it seems as though it was just an issue with oauth2 that has since been fixed. Thanks for your replies to my post!

Thanks,

Josh