cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Matthias93 Member
Member

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 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

2 REPLIES 2
Matthias93 Member
Member

Refreshing dashboard based on 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 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

Moderator v-yuezhe-msft
Moderator

Re: Data refresh with empty SharePoint lists

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.
1.PNG

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.
2.PNG

 


Thanks,
Lydia Zhang

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors