Forum Discussion

Frequent Visitor

3 years ago

Solved

DirectQuery with SSAS

Hi,

I'm trying to connect to SQL Server Analysis using Direct Query. From what I've read online it seems like it's not possible.

But I think it's possible since I'm using a report that does it :

connection settings :

My question is how can I do this please ?

Thanks

Tips and Tricks

Tutorial Requests

PC2790
3 years ago
That's because I changed it explicitly following the process mentioned here

Initially it always shows live and import mode only, you will have to change it using" Make changes to this model" in your desktop.

Please try and see if it works for you.

5 Replies

PC2790
Community Champion
3 years ago
Hello Broly ,

When you to attempt to connect to a Azure Analysis Services Database, you get an option to chose Direct Query as shown below:

Did you try that?
- Broly
  Frequent Visitor
  3 years ago
  when I try to I don't have the option:
  
  I only have the live connection option :
  - PC2790
    Community Champion
    3 years ago
    It is a recent addition and is in preview, can you see if it has been checked
    
    File --> Options & Settings --> Preview Features as below:
    
    Reference- Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Learn

Related content