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.
Thanks for your reply! And sorry for posting my general addition into your post - I am a greenhorn 🙂
To your points:
1. Check if the data source is connected properly, make sure the connection between power BI and AS model is normal and stable. --> The connection is working proberly in both directions (new added columns in the data source are displayes in SSAS an the changes made in SSAS are published to PowerBI (I change the descriptionfield of some measures to verify this)
2. Check if there are any problems with the measure formula: although the measure you provided is very simple, check that the correct data (fields) are referenced. --> what kind of problems might there be? I copied the formular for an other measure (netsales)
3. Make sure the data model is updated --> it is (see point 1)
4. check if there are data access permissions: if you have set access permissions in the AS model (RLS/OLS in AS) it is very important to set access permissions as these settings affect the scope of the data that the user can access and use, and if the user role does not have access to the field in your measure, the metrics may show up as null! --> this migth be. How can I check and change this? I have the impresseion that new relational attributes are not introduced to PowerBI since I tried it with an other attribute (see first reply) ...
In fact this is the most important point to check in my opinion, please check in detail if you have these settings in your model
5. Check if your measure may have specific access rights set up, without being granted permission to view these metrics, then these metrics will also show up as null in PowerBI. --> this migth be. How can I check and change this? I have the impresseion that new relational attributes are not introduced to PowerBI since I tried it with an other attribute (see first reply) ...
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.