Use an Excel File shared with me as a data source

[DaveConnors]

A colleague has shared a file with me from their One Drive for Business folder.

I can see it in my One Drive for Business as a file shared with me.

My colleage has Power Automate flows that update tables in this file based on other activity in our system. I'd like to use these tables as a dataset in a Power BI Report.

However, I cannot find any way of accessing this file from Power BI in order to connect it as a data source.

Can I do this, and how?

[Anonymous]

Hi @DaveConnors,

I agree with lbendlin's point of view, you can share the file on SharePoint or one drive side. Then you can simply get data from the shared file as below link:

Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs
Regards,

Xiaoxin Sheng

[lbendlin · Accepted solution]

OneDrive is the same as Sharepoint. Use the SharePoint Folder connector.

Make sure to specify only the base URL, not the entire path.

In a pinch you can also use the manual Sharepoint.Contents() connector.

[DaveConnors]

Thanks, I'll try that in future. 

This time I resolved it by having the colleague share a folder with the file in, as that then shows up in the "shared" folder in one drive. it's stupid that only folders sync there, not files. But I'll remember to sue the sharepoint connector going forward.

Thanks for your help.