Forum Discussion
Cannot filter in Analyze in Excel as a RLS user - Hybrid Table
It looks like you are facing an issue with your Power BI dataset and the dynamic row-level security that you have implemented. The error message that you are seeing is related to the XMVSQuery component of the dataset.
To troubleshoot this issue, you can try the following steps:
Check the data type of the Company column in your Sales table. Make sure that it matches the data type of the CompanyCodes table's CompanyCode column. If there is a mismatch, you can try changing the data type of the Company column to match the CompanyCode column.
Check if the email address used in the dynamic RLS matches the user principal name of the end user. Make sure that the email address used in the RLS is the same as the email address used by the end user to log in to Power BI.
Check if there are any missing or incorrect values in the CompanyCodes table. Make sure that all the company codes used in the Sales table have a corresponding entry in the CompanyCodes table.
Try recreating the SalesAmount measure to see if it resolves the issue. You can also try creating a new measure using the DAX function SUMX to see if it resolves the issue.
If none of the above steps resolve the issue, you can try refreshing the dataset or re-importing the data into the dataset.
It looks like you are facing an issue with your Power BI dataset and the dynamic row-level security that you have implemented. The error message that you are seeing is related to the XMVSQuery component of the dataset.
To troubleshoot this issue, you can try the following steps:
Check the data type of the Company column in your Sales table. Make sure that it matches the data type of the CompanyCodes table's CompanyCode column. If there is a mismatch, you can try changing the data type of the Company column to match the CompanyCode column.
Check if the email address used in the dynamic RLS matches the user principal name of the end user. Make sure that the email address used in the RLS is the same as the email address used by the end user to log in to Power BI.
Check if there are any missing or incorrect values in the CompanyCodes table. Make sure that all the company codes used in the Sales table have a corresponding entry in the CompanyCodes table.
Try recreating the SalesAmount measure to see if it resolves the issue. You can also try creating a new measure using the DAX function SUMX to see if it resolves the issue.
If none of the above steps resolve the issue, you can try refreshing the dataset or re-importing the data into the dataset.