Forum Discussion

Urid1969's avatar
Urid1969
Icon for Helper I rankHelper I
10 years ago

The XML for Analysis request timed out before it was completed.

Hello 

We have a SSAS 2012 (28GB ,2CPU, 64 bit) Tabular model (700mb) trying to import into POWER BI desktop. Constantly we get the below error

 

Is that workstation or a server memory problem? In SSASS I did change External Command timeout property form the default 3600 sect to 7200 sec, still getting the error. What else should I be looking at?

Thanks

Need Help

4 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Urid1969

     

    Are you able to import a smaller SSAS tabular model into PBI Desktop? You can monitor the CPU and Memory usage in Performance of Task Manager when importing this large model to see if it is related to hardware performance.

    And I also recommend you to use DirectQuery instead of Import mode here. DirectQuery lets you build visualizations over very large datasets. When connecting live, no data from the Tabular model is imported into Power BI Desktop. Each time you interact with a visualization, Power BI Desktop queries the Tabular model and calculates the results you see. 

     

    Best Regards,

    Herbert

    • Urid1969's avatar
      Urid1969
      Icon for Helper I rankHelper I
      10 years ago

      Hello Herbert

      Yes, I am able to load smallest data sets .. Using Drect Query will I able to create measures on the PowerBi side? I know that using Live Connection all measures, calculations should be done on the model side

      • v-haibl-msft's avatar
        v-haibl-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago

        Urid1969

         

        You will not be able to create measures on PBI side if using Direct Query to SSAS tabular. This idea is still under review and may be implemented in the future.

         

        Best Regards,

        Herbert