Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Excel data refreshes from OneDrive and Power BI Desktop?

I would like to put an Excel file out in OneDrive (preferrably in a group workspace OneDrive), be able to Get Data from the Power BI Desktop to create a .pbix, then deploy that to the Power BI Servic...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

You should be able to go to "Get Data" | Files | OneDrive although I am not sure that supports O365 group workspace OneDrives, I have used it with Business and Personal OneDrive. I use "Connect" and it works and refreshes like a champ, no gateway required.

 

I believe that what is making it be recognized as local versus cloud is that you are synchronizing it to a local file and then selecting that file. At that point, it is a local file, not a cloud file, just a cloud file that is synchronized to a local file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Get Data / Files / OneDrive in the Power BI Desktop?  I'm not sure that exists.

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      10 years ago

      Sorry, was referring to the Service.

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        No worries, thanks for looking and responding.  Just wanted to make sure I wasn't missing something.  I appreciate the feedback from the community.