Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

oneDrive refresh - "enter credentials for all data sources"

Hi all,

 

All of a sudden, my report in services won't update with the source from my onedrive when I make changes to the sources.

 

I get the following message:

Where am I supposed to put in the credentials? The sources is an excel file in my onedrive for business and I am logged in with my credentials both in onedrive and excel? 

 

2 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support

    Hi, Anonymous 

     

    When things go wrong, it’s usually because Power BI can’t sign into data sources. Things may also go wrong if the dataset tries to connect to an on-premises data source but the gateway is offline. To avoid these issues, make sure Power BI can sign into data sources. Try signing into your data sources in Data Source Credentials.

     

    When you save your changes to the Power BI Desktop file on OneDrive and you don't see those changes in Power BI within an hour or so, it could be because Power BI can't connect to your OneDrive. Try connecting to the file on OneDrive again. If you’re prompted to sign in, make sure you select Keep me signed in. Because Power BI wasn't able to connect to your OneDrive to synchronize with the file, you’ll need to import your file again.

     

    For further information, please refer to the following links.

    Use OneDrive for Business links in Power BI Desktop 

    Refresh a dataset stored on OneDrive or SharePoint Online 

    Dataset refresh from OneDrive Excel file set-up 

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.