Power BI connected to SharePoint Online is failing to refresh

[davidbell77]

I have a  number of SharePoint online lists that are connected to Power BI. Since the latest update, the Desktop version of Power BI can still connect and refresh, however the web version fails to refresh, coming back with "###" column does not exist in the rowset. Different for each dataset, previous to the update it was refreshing fine and i haven't made any changes to the workbooks.

the details for one of them is below.

Activity Id: bc2b4b00-4654-477d-8ff8-c649ea5fab73

Request Id: 186bf298-baf6-462b-9216-60e45ff58156

Cluster Name: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net

Refresh Start Time: 05/21/2017 14:01:36Z

Refresh End Time: 05/21/2017 14:15:17Z

[v-haibl-msft]

@davidbell77

This issue has already been reported internally to Power BI Team: CRI 37282709

The fix is expected to reach the service this week.

As a workaround, there are two things that can be done to change the query in a way that will help to avoid the problem:

1. Always use “Remove Other Columns” to keep only the columns that you need. “Remove Columns” doesn’t do it; it has to be “Remove Other Columns”. Failure to do this will mean that the service sees more columns than it expects and the refresh will fail.
2. Avoid using the SharePoint List column “FieldValuesAsText” as that is specifically broken in the service right now.
   
   

Best Regards,
Herbert