Forum Discussion

Matthias93's avatar
Matthias93
Helper III
9 years ago

Data refresh with empty SharePoint lists

Hi,   I have a query based on multiple SharePoint lists. Everything works just fine when there is data in the lists, however when I try to refresh my dashboard when one of the lists is empty I get ...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Matthias93,

Do you refresh your data in Power BI Desktop or in Power BI Service?

Based on my test, when we firstly import data from SharePoint lists and empty list into Power BI Desktop, empty SharePoint list will show as an empty table in Power BI Desktop. In this case, there are no issues when you refresh data in Power BI Desktop or refresh the dataset in Power BI Service.


However, if I delete all items on one of my non-empty SharePoint list (for example: LS), then refresh data in Power BI Desktop or refresh the dataset in Power BI Service, I can reproduce your error. In this case, open query editor in Power BI Desktop, click on your query(LS in my scenario) , and you will see APPLIED STEPS in Query Setting panel, some steps(“Renamed Columns” in my scenario) should make changes to your columns, as long as you remove these steps, the error goes away. And if you get this error in Power BI Service, you will need to firstly handle this error in PBIX file and re-publish it to Service.

 


Thanks,
Lydia Zhang