Forum Discussion

hellyLoft's avatar
hellyLoft
Frequent Visitor
5 years ago
Solved

Schedule Refresh PowerBi service and oneDrive

Hi all,   I have completed the following instructions to link my powerBi desktop with my one drive folders and files. This works really well and I can refresh the data when needed. However, once I ...
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi hellyLoft 

     

    Yes, gateway is not needed in this scenario. I followed the steps in the blog you shared and managed to refresh the report on Service without a gateway successfully. Perhaps you just missed something.

     

    Below are my testing environment and settings. Hope they are helpful.

    • Power BI Desktop Version: 2.88.721.0 64-bit (December 2020)
    • Power BI Service version: 13.0.15022.68
    • Credentials Type in Desktop: Microsoft account
    • Credentials Type in Service: OAuth2
    • Source Code: Source = SharePoint.Contents("https://xxxx-my.sharepoint.com/personal/xxxx.com/"),

     

    Kindly let me know if this helps.

    Community Support Team _ Jing Zhang
    If this post helps, please consider Accept it as the solution to help other members find it.

hellyLoft's avatar
hellyLoft
Frequent Visitor
5 years ago

This was probably a combination of a couple of things. I was on a very old version of desktop (I cant upgrade as on a virtual desktop). i upgraded and reentered credentials etc and published. This is now syncing. 

 

thanks!