I have a pbix works fine on pbi desktop. but it's not working after publish:
I got error message:
Query (3, 5) The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
Please try again later or contact support. If you contact support, please provide these details. this is my report:https://msit.powerbi.com/groups/me/reports/758c43cc-332c-4877-b97c-d531d37c4fa9
I have some sql query(direct query) in my report, however if I changed to import rather than direct query, then the issue resolved
You may check if the following post helps.