Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Newbie: DirectQuery on SSAS and DirectQuery on PowerBI

Hi

So I am new to SSAS - built model in Tabular and its really slow to open but i can query this with no performance issue via SSMS or analyze in excel locally. However when using PowerBI to visualise data it it is really slow. I use Direct Query connection on PowerBI.

I dont know where to start troubleshooting it. I wonder - if using Direct Query connection on PowerBi does it mean my model needs to be designed in Direct Query too?

 

Many thanks

 

Pedzilla

1 ACCEPTED SOLUTION

@Anonymous I am not aware of any way to accomplish this. Any mucking around with the pbix file results in a corrupted file... There is a connection file in Live Query that is not there for a PBIX file that was imported into, but all my test cases have failed when trying to switch over. 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

3 REPLIES 3
v-sihou-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

 

No. DirectQuery connection is different from the SSAS DirectQuery mode. 

 

In POWER BI, Direct Query connection just means POWER BI directly query against the data source. In this scenario, it's SSAS database. The DirectQuery mode in SSAS means it's directly retrieving raw data from the underlying relational database to generate DSV for building data model.

 

What's the version of POWER BI DESTTOP you are using? DirectQuery connection should not be supported for SSAS data source. Please see:

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/

 

Regards,

 

Anonymous
Not applicable

HI there

My Power Bi Desktop is April release. I just realised that there are differences between Live Connection and Direct Query.

I think my real question is how to change from Live Connection to Import but someone said its impossible 😞 Is this correct?

 

I dont want to re-do my dashboard but it seems to be the only way to go 😞

@Anonymous I am not aware of any way to accomplish this. Any mucking around with the pbix file results in a corrupted file... There is a connection file in Live Query that is not there for a PBIX file that was imported into, but all my test cases have failed when trying to switch over. 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.