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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Link and Folder fields not pulling data from Sharepoint

I have a sharepoint project with 5000 files. After linking it to Power BI, only half of the links are referenced, and only a couple of the folder paths are not shown. However, when i go to export as excel, all the links and folder paths are correct. See below images (rows 116-119). Would this be a Sharepoint issue, or a PowerBI issue and how would i resolve it? 

 

PeterZigante_0-1650466682726.png

 

4 REPLIES 4
jennratten
Super User
Super User

Do all of the folders have the same permissions in Sharepoint?

Anonymous
Not applicable

I am being told that all the folders have the same permissions. 

When you export to Excel, are you doing so from the Power Query editor, from a table in the data model, a visual, etc?

Anonymous
Not applicable

No, the export option within Sharepoint, this file has proper links and folder paths for each file.

It is only after linking Sharepoint to PowerBI and attempting to transform the data in PowerBI, that i notice quite a few links or folder paths missing.

 

PeterZigante_0-1650889959355.png

 

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.

Top Solution Authors
Top Kudoed Authors