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 have published the powerBi report to the service I don't appear to be able to refresh the report to get any new data on oneDrive.

 

I didn't think i needed a gateway as the data is online in OneDrive. Does anyone know if that is correct? I have attached a screenshot of the dataset information.

 

https://radacad.com/power-bi-get-data-from-multiple-files-in-a-folder-on-onedrive-for-business-no-gateway-needed

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

4 Replies

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

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    The credentisls are not set up correctly

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    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

    Thank you for taking the time to look into this, its a great relief to know I don't need the gateway etc. I will take a look this week and post back, accept solution etc.

     

    many thanks!!!

     

    Helen