Forum Discussion
Powerbi Component not showing data properly
I think i have figured it out.
I have a Date filter affecting all the components of the report. It has the option to select "All dates" and an option to select a custom period.The issue is related to this behavior :
When i select a custom period and go back the All Dates, the custom dates are not reset properly so the categories are affected by this since they depend on the products included in the date interval.
The behavior was mainly in prod because the report was saved with this behaviour so when i used the reset filters button it went back to this, whereas in the other environments no custom dates were set.Thanks for all the help !
RLS is the most common cause in PROD-only scenarios. Do you have RLS in your Model?
I don't have any RLS no..
Other than that my licence is premium per user and i'm administrator of the environment, so it's also not an issue of access to the data.
I have noticed that if I add a dimension showing the number of bookings of each category, i am able to see all the categories in PROD.. but as soon as i remove this i'm back to only one category showing