Forum Discussion

RémyA's avatar
RémyA
Helper I
2 years ago
Solved

Unable to render paginated report - Error

Hello, I have this error in Power BI Services: There was an error communicating with Analysis Services. Please verify that the data source is available and your credentials are correct. wabi-west...
Reports
  • RémyA's avatar
    RémyA
    2 years ago

    I have create the DAX Query to source the visuals and solve the problem.. 

RémyA's avatar
RémyA
Helper I
2 years ago

Hello, Anonymous Anonymous 

Any idea? The problem continue.

 

Thanks

  • RémyA's avatar
    RémyA
    Helper I
    2 years ago

    I have create the DAX Query to source the visuals and solve the problem.. 

    • ucmaoTWG's avatar
      ucmaoTWG
      Helper I
      1 year ago

      Hello Remy,

      I'm having the same issue as you- can you explain what you did to resolve this error?

      Thanks,

      • RémyA's avatar
        RémyA
        Helper I
        1 year ago

        Hi ucmaoTWG ,
        I have created the DAX Query that get the data from the Semantic Model. 
        My source is the Semantic Model, and my Dataset is a query in DAX, like this:


        In my case I have optimize the DAX Query, and the report is render in 2/3 sec max. 
        If you have dificulty to create the DAX Query you can recreate the visual in Power BI Desktop and in the Performance Analyser get the Query, this query will not be optimize... but this can help you.