Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
LCarenzo
Helper I
Helper I

Refresh -

Currently I have my dataset, and visual on my one drive, I have given access to those files on one drive to my overseas colleage so that he has the ability to update the dataset and refresh the data in Powerbi visual page.   

 

When he goes to do the refresh, it fails with an error stating the file cannot be found because it is on my one drive path, even though he has access.   

 

How do we both get to access the data and refresh?

1 ACCEPTED SOLUTION
RossEdwards
Helper II
Helper II

My guess is that the problem is based on the "Address" used in the Power BI file.  Even though both of you have access to the file, he might not have access using the address you put into the file.  The address that you have shared with your college is probably not the same as the address you have used in your file.

I'd attempt changing the address, do a close and apply. Publish back into the service and see.

View solution in original post

10 REPLIES 10
v-tangjie-msft
Community Support
Community Support

Hi @LCarenzo ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

RossEdwards
Helper II
Helper II

My guess is that the problem is based on the "Address" used in the Power BI file.  Even though both of you have access to the file, he might not have access using the address you put into the file.  The address that you have shared with your college is probably not the same as the address you have used in your file.

I'd attempt changing the address, do a close and apply. Publish back into the service and see.

Thanks you, however what do you mean by address?

Whenever you connect to any data source, you need to tell Power BI where to look.  This is what i mean by address.  If you look at the "Source" row of your query, you will see what the address to the file has been provided.

aj1973
Community Champion
Community Champion

Hi @LCarenzo 

The "One Drive" is it on a local machine if so then you will need a Power bi Gateway installed.

If you guys are using One Drive for business then no need for the Gateway but you have to make sure of the way you connect to one drive through Power BI desktop. Here is a video to explain it

Bing Videos

Note that One Drive for business is backed by Sharepoint Folder therefore you must use Sharepoint Folder connector.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Thank you all, this makes perfect sense.  However, I am brining in an entire folder, is there a work around to enter the path in for a folder vs. a sheet?

aj1973
Community Champion
Community Champion

@LCarenzo 

Not sure what did you mean by enter the path in for a folder vs. a sheet !!

Can you show me the M-Code please?

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

When i originally did get data, I picked folder from the list, which brings in every excel file in the folder and basically appends them.

aj1973
Community Champion
Community Champion

Ok , I understand the mistake. You picked Folder because the sheets are saved in your machine.

In the service, the refresh might work for you when you initiate it but never for your colleagues. The refresh can work for you because you might be using the Personal Gateway that you installed in your machine, and the personal Gateway can not be shared with others.

I recommend that you upload the files in a Folder in Sharepoint or in One Drive for Business then reconnect you report through Sharepoint Folder connector. This way you won't need a Gateway and your colleagues can do the refresh manually.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Thats the problem, I have them stored on one drive, but I guess the address is still pointing to me.  Let me check the sharepoint folder connector vs. web.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors