Forum Discussion
Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Please, bring back Direct Query for datasets that connect to SSAS using a live connection. It was working, I have reports built based on that feature and now it's broken and added to limitations - I feel cheated.... I don't agree for it to be a limitation, especially if it was working for some time... That was the only option to work comfortable with Multidimensional Model in Power BI. We bought both Multidimensional SSAS and Power BI from Microsoft and that's ridiculous that Power BI doesn't properly support Multidimensional. Direct Query for dataset that connects to Multidimensiona is the only option to e.g. create a table that has twice the same measure but crossed with Time dimension on different years, or uses hidden measure, that's absurd (you can easily do it in Excel!!!)! Please, enable Direct Query for datasets that connect to SSAS using a live connection (at least for Multidimensional). I know the argument about query performance, but it's better to have worse query performance than not working at all...!