Forum Discussion
Solved
Data source error: Expression.Error: We cannot convert the value "[Table]" to type Table.. Microsoft
I have a semantic model that works as expected in Power BI desktop. It WAS refreshing as expected in the Power BI service, but after some minor additions it now is throwing an error on refresh: ...
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