Subqueries

[Anonymous]

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

[Habib]

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]

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]

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