Forum Discussion

4 Replies

  • Hi Magggot 

     

    Can you make sure that there are no hidden filters being applied on the report?

     

    Typically the data is always there, sometimes there is a hidden filter or Row Level Security is being applied.

    • Magggot's avatar
      Magggot
      Frequent Visitor

      I checked everything, none of these solutions work

  • In PBI Desktop, check to see if the missing data are in your tables. If the data are in the table, but not showing up in a report or visual, then there is a filter of some sort being applied. Sometimes the filter is not obvious. E.g., Do you have a date table in your table structure? Does the date table run through the current date? If for example the data table goes only to 12/31/2022, you will not see any 2023 data in your reports even though there is no obvious date filter being applied on the visual.

  • Magggot's avatar
    Magggot
    Frequent Visitor

    Change the connection in the model and removed IFERROR it in the measure. It works.