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

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's avatar
v-qiuyu-msft
Community Support
9 years ago

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'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

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi AndrewKent,

     

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

     

    Best Regards,
    Qiuyun Yu

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

  • AndrewKent's avatar
    AndrewKent
    Helper I
    9 years ago

    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

     

  • AndrewKent's avatar
    AndrewKent
    Helper I
    9 years ago

    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