cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
asellars1
New Member

i can not link excel files on share point to power bi

I am new to power Bi and I am having real troubles linking excel files hosted on Sharepoint to power bi.

 

If i download the file I can then use it in power bi so the issue is not the file

 

I have tried using the get data button and then selecting excel file, they copying the link in. this gets me closest as I can see the info when i click preview but then it failes to pull the correct info through

 

If i try using the sharepoint link under the get date tab i just get error messages. 

I have tried using the link suggested on here but this does not work either

https://xxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Foldername>/<Yourexcename>.xlsx

any one able to help

1 ACCEPTED SOLUTION
dax
Community Support
Community Support

Hi asellars1, 

If you want to get Excel from sharepoint by above path, I think you need to choose Web when you connect to Excel. You could refer to my previous post  for details.

In addition, you also could use Sharepoint folder to connect all Excels in folder(by  https://xxxx.sharepoint.com/sites/<sitename>/).

Best Regards,
Zoe Zhi

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

View solution in original post

1 REPLY 1
dax
Community Support
Community Support

Hi asellars1, 

If you want to get Excel from sharepoint by above path, I think you need to choose Web when you connect to Excel. You could refer to my previous post  for details.

In addition, you also could use Sharepoint folder to connect all Excels in folder(by  https://xxxx.sharepoint.com/sites/<sitename>/).

Best Regards,
Zoe Zhi

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

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors