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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Sharepoint table does not load on power query

I have a specific problem with a Sharepoint table, I can't load the data from that table in the power query, I have full access to this table.

Error Sharepoint.png

 

Tabela 8.png

 

This table is a unique one that occurs this problem among 22 tables.

 

3 REPLIES 3

This doesn't look right. Are you trying to connect to a list? If so, look at my post on how to do this. https://marqueeinsights.com/how-to-data-mine-a-sharepoint-list-with-power-bi/

 

Thanks!

--Treb

 

Check out my Power BI blog posts at https://marqueeinsights.com/blog

Anonymous
Not applicable

Yes it is a list, I use the SharePoint list connector often and this kind of error had never occurred.

Among the 22 tables I can load the data from 21, table 6 is the only one that requests an authentication again, what could this be?

I've never seen any data returned as a table. You normally get the records that are in the SharePoint list. What is the structure of your SharePoint List?

 

Thanks!

--Treb

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors