Forum Discussion

r_power12's avatar
r_power12
Advocate I
10 years ago
Solved

Can't Display the Visual

I have a Power BI Desktop model uploaded to Power BI (app.powerbi.com) using a Pro account, all latest versions as of May 4, 2016. The reports in Power BI worked fine for 1-2 weeks; however recently,...
Need Help
  • r_power12's avatar
    r_power12
    10 years ago

    After diving a bit deeper, I discovered the issue only affected some of my measures which required syntax changes as the example below shows:

     

    From

    Measure 1 = CALCULATE(COUNTROWS())

     

    To

    Measure 1 = CALCULATE(COUNTROWS(Table1))

     

    It appears the latest update of Power BI (app.powerbi.com) now requires the table name as a parameter of the COUNTROWS() function. 

     

     

     

     

     

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago
r_power12 Are you using import or DirectQuery to get data?
  • r_power12's avatar
    r_power12
    Advocate I
    10 years ago

    ankitpatira I am using import data, sql queries pulling from an on-premise database.

     

    The data loads and displays fine in Power BI Desktop, but the visuals present the error online in app.powerbi.com.

    • r_power12's avatar
      r_power12
      Advocate I
      10 years ago

      After diving a bit deeper, I discovered the issue only affected some of my measures which required syntax changes as the example below shows:

       

      From

      Measure 1 = CALCULATE(COUNTROWS())

       

      To

      Measure 1 = CALCULATE(COUNTROWS(Table1))

       

      It appears the latest update of Power BI (app.powerbi.com) now requires the table name as a parameter of the COUNTROWS() function. 

       

       

       

       

       

  • bensat2's avatar
    bensat2
    Regular Visitor
    9 years ago

     i am getting the same problem, whether i inport directly, from web , excel  or access . i am using free power bi desktop, the data gets loaded , but i cant get any visualisation

    • jamalq123's avatar
      jamalq123
      Advocate III
      9 years ago

      Same is hapening with me. I can see the data when go through edit query. But when load it and visualize it describes "Can not display the visual".

       

      Recently i reinstall windows 7 and office 2010. Please help me in this scenario.

       

      Regards,

       

      Jamal Qamar

       

       

      • filp2000's avatar
        filp2000
        Regular Visitor
        9 years ago

        Hello. I am having the same problem.... Even when I just create a small table with data inside PowerBI desktop, it doesnt display the visuals. What to do?...

    • rtUsmanKhan's avatar
      rtUsmanKhan
      Regular Visitor
      9 years ago

      Hi, Please share if you found any solution. In my case if populate data even by "Enter Data" it says Can't display the visuals.

      Thanks