Forum Discussion

tessahurr's avatar
tessahurr
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services.  To learn more about this feature, please visit this blog post or our documentation.   ...
General Comment
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Very excited for this!  However, we create our data models in SSAS, so the only way we can leverage this is to connect to SSAS, publish the model to Power BI Service, then connect a new *.pbix to it.
Does that cause a degredation of performance to essentially use the Service as a passthrough to SSAS?

WillHopkins's avatar
WillHopkins
Icon for Advocate I rankAdvocate I
5 years ago

Hi I tried that. You do not get the option to switch to direct query mode although the get data button is not disabled.. I think Power BI knows that SQl Server Analysis Services is behind the dataset. If you can get that to work though it would be helpful.

  • jeroenterheerdt's avatar
    jeroenterheerdt
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    I don't think that would be a great solution, too many hops and you are really trying to make something work that is not supported.