pbix not working after publish

[zys87126]

Hi,

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 

thanks

[v-chuncz-msft]

@zys87126 

You may check if the following post helps.

https://community.powerbi.com/t5/Desktop/How-do-I-get-this-expression-to-work/m-p/167096#M72969