Forum Discussion

parulgoyal's avatar
parulgoyal
New Member
6 years ago

Sharepoint data not being fetched correctly

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.

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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.