OneDrive for Business: Datasource has no credentials

[AndrewKent]

Hi there,

I have built a dashboard in Power BI Desktop where the pbix file and data sources are on OneDrive for business. The dashboard works perfectly and refreshes correctly in the desktop program but will not perform a refresh when loaded ("Get Data") into Power BI Service. The error message I get is (see attached).

My credentials are all correct (using organisational account) but it is still not refreshing.

Any tips? If this is not something I can fix myself and I need IT support, I need to know what I'm asking them.

Andy

[v-qiuyu-msft]

Hi @AndrewKent,

As you are connecting to the OneDrive for Business which is not on-premise data source, I think the issue has nothing to do with the Power BI Service itself.

In your scenario, since the error message prompts data source has no credential, I would suggest you go to the dataset settings, and enter the organization account for the data source credential after click OAuth2.

Best Regards,

Qiuyun Yu

[AndrewKent]

thanks for the advice. I'm assuming this should work however I am reciving another error message. I'm assuming that although the login details I've entered are correct, this will be related to access rights of some kind?

[v-qiuyu-msft]

Hi @AndrewKent,

I find that there is already a same issue reported. Power BI team are working on it. The fix should be available later this week (11/26). Please try it later and post back if issue still persists.

Best Regards,
Qiuyun Yu

[AndrewKent]

Hi,

Seems like I am still recieving error messages. Is this something I should be contacting our own internal IT team about?

[v-qiuyu-msft]

Hi @AndrewKent,

I didn't get update information about this issue from product team, I guess maybe the fix havenn't apply yet. I will focus on this issue and contact product team the status about this issue.

Thanks for your understanding and support.

Best Regards,
Qiuyun Yu

[AndrewKent]

Thanks! I have raised this with our internal IT as well, on the off chance that it might be linked to on-site access. I will however wait to see what you come back with.

[v-qiuyu-msft]

Hi @AndrewKent,

I test it in my environment, it seems web data source can work in service, please test it in your workspace to see if issue is gone.

Best Regards,
Qiuyun Yu

[AndrewKent]

Hi,

I'm pleased to say that the issues I was experiencing have now been resolved. After testing pre-existing dashboards and reports over the last couple of days, no further "credentials" error messages have been recieved. As I have not altered anything since my last post I can only assume there has been a fix or a change implemented that has stopped these issues. Can anyone elamborate?

Andy

[AndrewKent]

Hi,

The issue still seems to persist which leads me to believe that this will be linked to functionality that has not been deployed correctly by our internal IT teams. I have raised this with them and will add more once I know more.

Andy

[v-qiuyu-msft]

Hi @AndrewKent,

Please try to republish the report. I got the internal information, the issue is gone now.

Best Regards,
Qiuyun Yu

[AndrewKent]

Hi @v-qiuyu-msft,

The only way I seem to be able to "refresh" my reports are:

1) Update original data sets on OneDrive

2) Open the PBIX file in Power BI Desktop and Refresh/Save

3) Upload PBIX file to OneDrive

4) Wait X time (sometimes a few seconds, sometimes 30 minutes) and Power BI Service dashboard will update

Not exactly efficient when you have 20+ reports

[Anonymous]

When you author the report in PBI Desktop, use "Web" as the data source instead of One Drive for Business. Then, enter the URL that links directly to the file on your One Drive for Business. It will typically be "URL/documents/File Name of Report.xlsx"

When you store the data source this way in the PBIX file, you can then upload it to the service and the refresh will work, once you enter your credentails on the data source settings as outlined in the previous posts.

Mark

[AndrewKent]

Hi @Anonymous - yeah, I have that part working. The PBIX file uses data that its stored in OneDrive and was linked in the way you describe. I have also followed the instructions in previous posts about Settings>Datasets>Data Credentials settings but even when I do this, I still recieve the "your credentials are invalid" error message (eventhough I am already signed in on Office 365 and just about every other system in our office).

[alanhodgson]

This might have something to do with it:

Hope this helps,

Alan

[AndrewKent]

Thanks, I saw that pop up actually, I'll check back in a few days and see if it's been resolved