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
Matthias93's avatar
Matthias93
Helper III
9 years ago

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 an error message saying there is no 'ID column' to be found. It's not ideal to make sure there is always a line in the SharePoint list. I was wondering if there is a workaround for this issue.

 

Thanks in advance,

 

Matt

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I had the same problem and found the best workaround is to create a "test" row in the Sharepoint list that always stays there and filter it out in the BI report.