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, none of the visuals are showing up. The only part showing up are the tables of data. To clarify, the visuals work fine in Power BI Desktop, but don't display in app.powerbi.com.

 

The file contains a mix of standard and custom visuals, the custom being the latest Attribute Slicer v0.10.0. I've tried switching to all standard visuals but still get the same error. Below is an excerpt of the error:

 

--------------------------------------------------------------------------------------------------------------------------------------

Couldn't load the data for this visual
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support and provide the following details to help resolve your issue faster.
Version 13.0.1100.480

--------------------------------------------------------------------------------------------------------------------------------------

 

Even re-uploading the Power BI desktop files that used to work fine in app.powerbi.com produce the same error.

 

Any ideas what may be causing this?

  • 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. 

     

     

     

     

     

13 Replies

    • r_power12's avatar
      r_power12
      Advocate I

      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

        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

       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

        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

         

         

  • I have this problem since last 2 updates.. Does it not support Windows 7? Plz suggest any solutions you use it with Windows 7. My company doesn't upgrade to win 10 so easily