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

I was able to use this functionality earlier this week.  However today I am not getting the option to update from a live connection to a Direct Query.  I uninstalled the desktop and reinstalled.  Still no luck 😞

 

I then tried to start with an excel source query and add analysis services also with no luck.  And yes, I have confirmed the Direct Query option is selected.

 

I should mention also that I am on version 2.91.884.0 64-bit (March 2021)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi, I have the same issue, although I have the newest version 2.91.884.0 64-bit (March 2021), I still can't combine two sources: excel imported data and Analysis Services through the Direct Query.

 

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

    did you enable the preview feature? Also, please note that SQL Server Analysis Services is not supported, just Azure Analysis Services.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi 🙂 I enabled the preview feature, but I'm working on SQL Server which is why this feature is not working. Thank you so much for the help!