Forum Discussion
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...
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...
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,