Sharepoint data not being fetched correctly

[parulgoyal]

Hi,

One of my Power BI reports fetched data from a Sharepoint Online List. 

The report worked fine till a week back but now it is fetching null values for a few rows.

These rows are correctly populated in SharePoint.

I've tried every possible thing. Any help will be highly appreciated.

P.S: This Sharepoint list has lookup items from other lists and the view may have been amended recently.

[v-juanli-msft]

Hi @parulgoyal 

P.S: This Sharepoint list has lookup items from other lists and the view may have been amended recently.

You add this note to mean that it may be the reason why some rows are null values, right?

You could try to refresh the report from Power BI Desktop.

If you'd like to refresh it schedully, you could publish reports to Power BI Service and configure schedule refresh.

https://docs.microsoft.com/en-us/power-bi/refresh-data

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.