Forum Discussion

AndrewKent's avatar
AndrewKent
Helper I
9 years ago

OneDrive for Business: Datasource has no credentials

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 prog...
Need Help
AndrewKent's avatar
AndrewKent
Helper I
9 years ago

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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    AndrewKent
    Helper I
    9 years ago

    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).