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.

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.