Forum Discussion
SharePoint - Integrate List to Power BI - Visualize List - not showing all fields
I have several sharepoint list that I'd like to visualize with Power BI. I'd like to use the Visualize List feature in Sharepoint as a quick way to build a simple dashboard within the list. When I attempt to build the report only a few fields show up in the dataset. One list it is the first 9 fields available, on the other it is a random 9. Ironically, this morning I attempted the same thing that wasn't working for months and found all 25 fields in the dataset showing but when I started to edit the report it reverted back to the 9 that was originally provided. Does anyone else have this issue or can help identify a solution.
Details:
-SharePoint Tennent has Power BI integreation enabled
-I am running Power BI Pro
-I have full read/write access to the data
1 Reply
- v-yalanwu-msft
Community Support
Hi, alfeuchtwa ;
Sorry, I can't reproduce your question, are you following this step? Could you provide more information?
Power BI SharePoint Integrations in Quick Steps (beyondintranet.com)
Power BI - Get Data From SharePoint List / Library - Microsoft Power BI Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.