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, types, references etc).
Entering Power Query, I found an error in my "Contracte" table:
However, when I try to see the error:
the value exists and is correct (no error on any of the columns):
When I am adding a step where I am changing the Column type from "Text" to "Text" (yes, the same type), all the errors are gone. Instead of "Error" I get the correct values:
Howevwer, when I Save and Apply, I got the initial errors (of course they are linked to the Source updating, not to the transformations).
Please ,help me in solving the errors or, at least, correctly explicit the "Error" item - show me the real error.
Thanks for your sharing and since your Power BI could run well, the thread will be closed now.