Forum Discussion

Mopyd's avatar
Mopyd
Regular Visitor
9 years ago

Error when i refresh data in PowerBi Desktop

I am not sure how to debug these errors. Is there a log to view? Unless someone has any idea as to what it is. In the applied steps i deleted "reordered columns", "kept errors", "added index" then ap...
Need Help
Guru's avatar
Guru
New Member
7 years ago

I am getting a similar error when I import a SharePoint list and the error query seems to be applying the following steps; 

 

Source - the source data/list

Added Index - adds an additional Indexed column

Kept Errors - it appears to me that every column has an error??

Reordered Columns - moves the new Indexed column to the first postion

 

When the SharePoint list is already indexed by default with unique ID for each row why is this error appearing on some lists but not one others list from the same SharePoint site. Has anyone come across this?

SourceAdded IndexKept ErrorsReordered Columns

Guru's avatar
Guru
New Member
7 years ago

The errors have gone once I went back to the table in Edit Queries and formatted the columns to a number or text, etc so it appears Power BI throws up these errors when data type in each column is not defined correctly.