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.

parkm71's avatar
parkm71
Frequent Visitor
4 years ago

Yes, I did, and if the filters were incorrect, I think there would have been a problem in the beginning

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    HI parkm71 ,

     

    So what are these on the matrix visuals - Are they columns from source data or are they calculated columns or calculated measures in Power BI?

     

    If possible share your pbix file by removing any sensitive information from it. You can upload the file on dropbox or through WeTransfer.

     

    Also please make sure to tag us before as part of your response using "@" sign. This just helps with the notifications on the thread 🙂

     

    Thanks,

    Pragati