Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Random "We cannot convert a value of type Record to type Text" error in server

Hi, I'm getting the error "We cannot convert a value of type Record to type Text" when refreshing a data source published in a workspace, it doesn't happen always, it's kind of random, and without changing anything (including data being pulled) it completes... I found a suggestion in another post and disabled the automatic field type detection but didn't seem to help.


My data sources are SAP HANA and excel files loaded in a One Drive folder, at some point those are merged into a single table, it works perfectly fine every single time in desktop, issue is just on the workspace.


Hopefully someone has gotten this same problem and could help me, for now is a proof of concept and I manually trigger the refresh but I want to schedule it and be reliable.






Oscar Marquez


Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.