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.
Super UserCKa, Is it a column or measure? Measure using time intelligence like datesytd, sameperiodlastyear, perviousyear etc need a date in context to calculate these. I think you are using a measure. select some date, you should be able to get value.
Why DATESMTD is still blank, even after having the correct TI Setup: https://youtu.be/j0ug-XQgZtg
Why previousmonth does not give result when datesmtd is giving it: https://youtu.be/1KkoJehRVeg
Thanks for your reply.
Yes it is a measure.
I tried it with combining the date-column at my first effert, The result is the same :
