Forum Discussion
Helper IWhat Power Bi loads isn't correct!
Has anyone experienced this before? Here is how the Sharepoint List structure looks like:-
Here is what Power Bi desktop sees when trying to load the List:-
I've hit a brick wall trying to figure this out. Help!
So here is what I found out with Microsoft Support. I've a big list > 5000 items. As such, the Sharepoint APIs aren't capable of supporting. Loading the list using v2 would break so the workaround is to load using v1 - which is what I did - but v1 loads using the unfriendly names. We had to do some crazy workarounds to load the friendly names to replace the unfriendly names.
2 Replies
Syndicate_AdminAdministrator
please show your Power Query code.
925stuartSo here is what I found out with Microsoft Support. I've a big list > 5000 items. As such, the Sharepoint APIs aren't capable of supporting. Loading the list using v2 would break so the workaround is to load using v1 - which is what I did - but v1 loads using the unfriendly names. We had to do some crazy workarounds to load the friendly names to replace the unfriendly names.