Forum Discussion
OneDrive for Business: Datasource has no credentials
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
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
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
Hi AndrewKent,
Please try to republish the report. I got the internal information, the issue is gone now.
Best Regards,
Qiuyun YuHi 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).
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