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

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.