Forum Discussion

rgatec's avatar
rgatec
New Member
2 years ago

Sharepoint to PowerBI Visualize the List Not Getting all Items

I have all this items: 

But every time i use Visualize the list in PowerBI I only get random ones:

I Have tried:

And remaking the step lots of times. Always getting Random Items from Sharepoint.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi rgatec ,

    Based on your problems, here are my answers.

    Firstly, you need to ensure that you have the necessary permissions to access all the items in your SharePoint list. Sometimes, restricted permissions can result in missing data.

    Sometimes, views in SharePoint can become corrupt or misconfigured. Try creating a new view with a different name but the same options as your existing view. Make sure to include all the necessary columns in this new view.

    Also you can consider using indexed columns in your SharePoint list. Indexing certain columns can improve performance, especially for large lists.

    Finally you can read this two topics for a further study: Solved: SharePoint all columns not showing in Bi - Microsoft Fabric Community and Power BI - SharePoint List Not All Columns Showing - Power Platform Community (microsoft.com)

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.