Forum Discussion
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.
This table is a unique one that occurs this problem among 22 tables.
3 Replies
- trebgatteMost Valuable Professional
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
- AnonymousNot 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?
- trebgatteMost Valuable Professional
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