Forum Discussion

jasonstark's avatar
jasonstark
New Member
5 years ago
Solved

onedrive refresh not work

I get a spreadsheet from onedrive business as data source in power bi, based on it, I created a report.

When I modified my spreadsheet, the data and report will refresh, it worked well until yesterday.

 

Now, whether I modify the spreadsheet or click 'refresh now' to refresh the data in power bi service, nothing happens.

I check the refresh history,nothing new, my report does not refresh, either.

 

This problem lasts for one day, driving me crazy.

 

Help,please

Need Help
  • jasonstark's avatar
    jasonstark
    5 years ago

    Thanks for your answer! 

     

    I check my setting, turn off  [Dataset Security] of [Tenent Settings] in [Admin Portal], problem solved.

     

     

3 Replies

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi jasonstark 

    Are you connecting to the excel on OneDrive from Power BI Desktop and then publishing the report to Service? If so, you can check whether you are asking to update your credentials. If it doesn't work, can you see other error information on the dataset setting page?

     

     

     

     

    Best Regards

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    • jasonstark's avatar
      jasonstark
      New Member
      5 years ago

      Thanks for your answer! 

       

      I check my setting, turn off  [Dataset Security] of [Tenent Settings] in [Admin Portal], problem solved.

       

       

      • v-cazheng-msft's avatar
        v-cazheng-msft
        Icon for Community Support rankCommunity Support
        5 years ago

         jasonstark 

         

        OK. Could you please mark your solution by clicking the option ‘Accept as Solution’?

         

        Best Regards

        Caiyun Zheng