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 that MDX with SSMS and it runs within seconds.

 

We have traced the issue to the

<DbpropMsmdSubqueries>2</DbpropMsmdSubqueries>

setting.

If we add this option to the SSMS connection string then within SSMS the MDX doesn't run.

 

So we are trying to determine is it possible to have the connection string within Power BI change

<DbpropMsmdSubqueries>2</DbpropMsmdSubqueries> the setting to

<DbpropMsmdSubqueries>0</DbpropMsmdSubqueries>

 

thanks

Need Help

3 Replies

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