cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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.  Any ideas on what I need to do to get Power BI to find the correct One Drive?

1 ACCEPTED SOLUTION

Accepted Solutions

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

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

View solution in original post

5 REPLIES 5
itelligent-i Regular Visitor
Regular Visitor

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

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

jbocachica Member
Member

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

Your subcription of powerbi must be related with your Office 365 subscription, the easy way is to create a suscription from your office 365 account.

 

Regards

John Bocachica
Senior BI Consultant
Information Workers
http://www.iwco.co

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

This is what happened. Someone has an office365 subscription which uses the company email account and uses that same account to get access to Power BI.  The one drive account is defaut set to mysharepoint, which is not what Power BI is pointing to when you select.  Any idea how to resolve this?  Do you have to go to sharepoint to share files instead of using the one drive icon in excel or file explorer?

 

My thought was to create a group account within power bi and add files to the Business one drive which is created at that point. Does that drive exsist actually in sharepoint?  The drive is being set up now so I don't know if it works yet.

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

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

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

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

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)