Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Subqueries

We are using Power BI to build reports from SSAS multidemsional model   we are having issues with the report runnig at all.   We grabbed the MDX from SQL profiler from the Power BI call and ran t...
Need Help
Habib's avatar
Habib
Continued Contributor
10 years ago

What exact error you are receiving when calling from Power BI. The tag you pased is for internal reference of Power BI definitly it will not work within SSMS

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    The issue is within Power BI the report doesn't run or complete....we have let it run for 20 minutes ...

     

    no error is returned but 20 minutes is not really acceptable ethier.

     

    Within SSMS we set the param to

    Subqueries=2 in the extended properties..

    when we do this in SSMS we get the same behavior as we get in Power BI ...report just spins or hangs, doesn't complete...within a accepatable time.. no longer then 20 minutes.

     

    So we want to omit the param setting in PowerBI or change it to zero...

    • v-sihou-msft's avatar
      v-sihou-msft
      Microsoft Employee
      10 years ago

      Anonymous

       

      Currently in Power BI, it's not supported to view/edit entire connection string so that we can't apply any other connection string properties. I recommend you submit a feature request on Ideas.

       

      Regards,