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.
Its due to Privacy level of your data source, update the web privacy level same as your desktop file 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).