Forum Discussion
Values from database are not displayed in PowerBI
Hi,CKa .Thank you for your reply.
Based on your tests, I think it should appear in the AS model itself
You can check if your model has RLS/OLS set up by doing the following:
You can check if RLS/OLS is set by going to Models>Roles in the tabular model.
Here is the documentation, hopefully it will help you.
URL:Dynamic row-level security with Analysis services tabular model - Power BI | Microsoft Learn
If you can't edit the current model because of data privacy, I recommend you to transfer the problematic measure to power BI desktop for creation.
This avoids the problematic measures in the AS model to be displayed as empty, which can solve your current problem and ensure the normal presentation of the report data.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I've now experimented a bit: If I build a new measure on an existing column, values are displayed in PowerBI.
If I now create a new column in the underlying database table and create a new measure in SSAS with this column, then the measure in PowerBI is empty. Is it possible that I need to introduce new relational attributes to PowerBI first? And if the answer is yer: How do I do that?
Thanks a lot!!!