Forum Discussion

desertislesql's avatar
desertislesql
Most Valuable Professional
11 years ago
Solved

How do I direct which One Drive Power BI can access?

In this scenario, the One Drive for Business is pointing to companyname.mysharepoint.onedrive.  Power BI is not connecting to that one drive, and I don't see a way to change it to point to that drive...
  • desertislesql's avatar
    desertislesql
    11 years ago

    After investigating One Drive access, I found that your ability to change which OneDrive you can access has to do with your Office365 license, especially as it realates to OneDrives created with Group Workspaces.  With Group Workspaces the OneDrive is created as part of a group, and if you have an Exchange 365 License, you can access the Group OneDrive.  For more information see my blog on the topic  http://www.desertislesql.com/wordpress1/?p=799

itelligent-i's avatar
itelligent-i
Advocate IV
11 years ago

I'm having this conversation with support via email right now.. will keep you informed...

 

You can connect to the file using the 'Get Data from Web' option, however it won't automatically refresh in the Power BI Service even thought the autorisation process in the Gateway Manager works...

  • desertislesql's avatar
    desertislesql
    Most Valuable Professional
    11 years ago

    Really looking forward to hearing what you find out on this issue. 

    • desertislesql's avatar
      desertislesql
      Most Valuable Professional
      11 years ago

      After investigating One Drive access, I found that your ability to change which OneDrive you can access has to do with your Office365 license, especially as it realates to OneDrives created with Group Workspaces.  With Group Workspaces the OneDrive is created as part of a group, and if you have an Exchange 365 License, you can access the Group OneDrive.  For more information see my blog on the topic  http://www.desertislesql.com/wordpress1/?p=799