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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
CarloA93
Frequent Visitor

SharePoint Excel File Data Source Issues

I've found that if I use Excel files on SharePoint (using the SharePoint folder connection in Power BI), that the connection breaks if I add any other files into that SharePoint (removing them resolves this). Is there any way around this? Or, is there a better datasource that can be easily be updated by non-power users we can utilize, hopefully free but if we need other licenses that's okay too.

1 ACCEPTED SOLUTION
ChrisMendoza
Resident Rockstar
Resident Rockstar

@CarloA93 - Not sure if this is the issue but I usually grab Excel files within SharePoint as the below image. You should only need the Source line as the subsequent lines are generated by the GUI as you click through to find the Excel file.
image.png






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

1 REPLY 1
ChrisMendoza
Resident Rockstar
Resident Rockstar

@CarloA93 - Not sure if this is the issue but I usually grab Excel files within SharePoint as the below image. You should only need the Source line as the subsequent lines are generated by the GUI as you click through to find the Excel file.
image.png






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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