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

 

 

15 Replies

  • alanhodgson's avatar
    alanhodgson
    Solution Supplier

    This might have something to do with it:

     

     

     

     

     

     

     

     

    Hope this helps,

     

    Alan

    • AndrewKent's avatar
      AndrewKent
      Helper I

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

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support

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

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

        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