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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
diskovered
Helper III
Helper III

SharePoint.Files data source error: The feeds metadata...

When adding SharePoint folder as data source with SharePoint custom column type “Choice”, prompted with this error: 

 

SharePointFiles.PNG

 

image001.jpg

 

Our internal SharePoint support team indicated the following:

 

I have narrowed down what is causing the issue that you can connect the power BI data connection to (SharePoint Site 1) but not (SharePoint Site 2).

 

This is not caused by the permission as <user> already a site owner of both sites. I found that this is caused by a custom column in some of the document libraries under the (SharePoint Site 2). Power BI cannot parse the type “Choice” column in the document library for example “(Document Library)”.

 

 

Does anyone know of any work-around?

1 REPLY 1
v-juanli-msft
Community Support
Community Support

Hi @diskovered 

How do you connect to SharePoint folder?

"OData"? or "SharePoint folder"?

 

What URL do you put in SharePoint Folder/"OData" connector of Power BI Desktop?

 

If you use "OData" connector, try a workaround:

Create a blank query in Power BI Desktop, copy the following code into Advanced Editor of this blank query.

let
    Source = OData.Feed("URL")
in Source

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.