Forum Discussion

parkm71's avatar
parkm71
Frequent Visitor
4 years ago
Solved

PBI doesn't show data

I have importeddata from SQL Data base,and since then data from one of the tables doesn't show up. All it says is "Empty" which in fact isn't true     Here's the before and after, there...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi parkm71 ,

     

    I saw that you created a calculated column to return 1 to count. You can try to use the COUNT function or the COUNTROWS function instead.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Pragati11's avatar
Pragati11
Super User
4 years ago

HI parkm71 ,

 

The other numbers on the 2nd screenshot are different to the 1st screenshot as well.

Can you check the following:

  • Is there any slicer selection on this report page?
  • Is there a visual level filter going on this 2nd table in the screenshot?

Thanks,

Pragati

parkm71's avatar
parkm71
Frequent Visitor
4 years ago

Checked the filters, there is nothing I guess

 

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    HI parkm71 ,

     

    I am talking about the visual level filters on all the visual that are in the screenshot.

    Did you check them?

     

    Thanks,

    Pragati