powerbipowerbi-embeddedpowerbi-desktop

Power Bi Embedded Parameter - Space in Column Name

I'm using a Power BI Dashboard Embedded in my application. So I'm passing some Parameters to it from the URL in the following structure

https://app.powerbi.com/reportEmbed?reportId=MyReportId&groupId=ReportGroupId&autoAuth=true&$filter=User/User id+eq+'1234'

The issue I'm facing here is that the column name User Id has a space in it and hence the filter is not working as expected. My data source is an SSAS cube and I don't have permission to edit the same.

Is there any alternative solutions for this?

Thanks in Advance

Solution

  • According the official documentation, special characters and spaces must be escaped with _xuuuu_, where uuuu is the unicode value of the character. So User Id must be escaped as User_x0020_Id.