Forum Discussion
Data source error: Expression.Error: We cannot convert the value "[Table]" to type Table.. Microsoft
Its due to Privacy level of your data source, update the web privacy level same as your desktop file and you should be good.
Its due to Privacy level of your data source, update the web privacy level same as your desktop file and you should be good.
I have the same issue. My Model is refreshing inside the Desktop App and with my Test Data, when i use the whole data for updating my model in web service it gives me the error code Microsoft.Data.Mashup.ErrorCode = 10277 wit thr expression "Can not convert null to type logical" Inside the table i replaced all nulls already with the number "0" but it doesn't work. Also the privacy levels are the same
You would be having blank rows at bottom of your source file
Would suggest to add one step in your power query as remove null, and you should be good
It worked perfectly!! Thank you.
in fact, the error message from PBI isn't clear at all (likely because it's casting tables/list values to string before passing them to the formula using them to conform privacy levels).
