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 are no filter applied, and all the measures worked just fine. Also here's table 

Strange thing is that all the data is just here, and it happened to this particular table

 

NEED HELP ASAP PLSSSSSS xd

 

 

 

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.

10 Replies

  • 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

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi parkm71 ,

     

    I downloaded your pbix file, and it shows that it is empty because there is no corresponding data.

    What is your connection mode to connect to the database? Please check if your data source is updated. There are two connection modes for connecting to SQL Server. One is DirectQuery, where your data is updated in real time. And the other is import mode, maybe you press the refresh button and the data is refreshed.

     

    Use DirectQuery in Power BI Desktop - Power BI | Microsoft Docs

    DirectQuery, Live Connection or Import Data? Tough Decision! - RADACAD

     

     

    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

      Hello Anonymous , There is data for "Встреча назначена" and "Встреча подтверждена" in this exact collumn, which I need to sum up the quantity, but the measures don't work 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        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.