DGruia
3 years agoNew Member
Status:
Done
Powe BI Desktop error not traceable when importing from Sharepoint list
I am importing data from Sharepoint 2019 on prem in power BI desktop (Version: 2.109.1021.0 64-bit) When refreshing data I get the following error: In Sharepoint, everything is ok (values, ty...
DGruia
3 years agoNew Member
I found the source of error>
The value extracted from Sharepoint list was a Sharepoint Link to an item in the list.
Later, the referenced item was deleted so the value pointed to a non existing item.
After correcting the reference in Sharepoint list to an existing item, the error was gone.
I suspect the values shown when cheking Error in Power Query table were from some cache.
Anyway, the Power Query Error behavior (showing cached values instead of Error details) remains strange.