Power BI desktop and workspace dataset refresh issue with blank items

[Anonymous]

I have developed Power BI report with datasource sharePoint list.  It works fine when there are items to the sharepoint list. 

when data set(SharePoint list) has no record, on click refresh report from Power BI desktop or  refresh dataset from Power BI workspace, it shows error message:Expression.Error: The column 'ID' of the table wasn't found.
Details:
    ID

Editor code:
Source = SharePoint.Tables("https://SiteURL", [ApiVersion = 15]),
    #"f5637e27-9ed1-4276-b244-539e73fafbe4" = Source{[Id="f5637e27-9ed1-4276-b244-539e73fafbe4"]}[Items],
    #"Renamed Columns" = Table.RenameColumns(#"f5637e27-9ed1-4276-b244-539e73fafbe4",{{"ID", "ID.1"}}),
It should show some relevant message " There is no record." instead of error message.

[v-jiascu-msft]

Hi @Anonymous,

As we can see from the snapshot below, the query is empty when there is no data available. So the "rename column" step could go wrong. Even there is a message "There is no record". I think "no record" is a kind of status rather than an error. The script will go to the next step "rename column". If you want this feature that stopping when there is no data, I would suggest you create an idea here.

Best Regards,

Dale