cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JamesBI
Advocate III
Advocate III

How to Switch mode in PowerBI from Direct to Import

Does Power BI still support switching a PBIX file from Direct Query to Import? I saw in the past there was some text next to the live connection that said "(Click here to change)", when I look at my file in the desktop application it just says "Live Connection: Connected"

 

I am on version: 2.52.4921.581 64-bit (November, 2017)

1 ACCEPTED SOLUTION

Hi @JamesBI,

 

I don't think there is an option to switch SSAS connect model from "Connect Live" to "Import" currently. Here is the idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature. Smiley Happy

 

Regards

View solution in original post

7 REPLIES 7
Greg_Deckler
Super User IV
Super User IV

What is your data source? Is it a Power BI Service dataset?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




I am using a Direct Query to an On Premesis Multidimensional Cube

I thought you could only use Live Connect with MDX cubes (or import) which I think is different to Direct Connect


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

You are correct, I am mixing up the terminology. I am live connected to MDX cube. Can you switch a live connect to an Import?

Hi @JamesBI,

 

I don't think there is an option to switch SSAS connect model from "Connect Live" to "Import" currently. Here is the idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature. Smiley Happy

 

Regards

View solution in original post

Anonymous
Not applicable

Please use this to Switch from Direct Query to Import mode.

Solution is not mine so please give credit to OP.

https://community.powerbi.com/t5/Desktop/How-to-change-direct-query-to-import-query/td-p/100996

 

Phil_Seamark
Microsoft
Microsoft

HI @JamesBI

 

I just tried with my November build and I still get the option in the bottom right hand corner to switch from Direct Query mode.

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

html:
Carousel MBAS ARun Part 1 768x460

MBAS 2021

Join Arun Ulagaratchagan and the Power BI team at MBAS! #MSBizAppsSummit #CommunityRocks

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!