cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kanth32
Helper I
Helper I

How to change direct query to import query

Hi Team , 

 

I have connected to HANA DB and created one reporting using Direct query option . Now i want to change from Drirect query option to Import query option . I tried to change in edit query--> change data source(below snap) and there import query option is disable . Can you please let me know how can i change my direct query to import query option . 

 

Import.PNG

1 ACCEPTED SOLUTION

Hi @kanth32,

 

If you're connected by Direct Query, you'll see the message "DirectQuery: Enabled (Click to Change)" in the status bar at the bottom right hand screen on Power BI Desktop:

 

changemode.PNG

 

Click on the message, then you should be able to change Direct Query to Import Model.Smiley Happy

 

cm2.PNG

 

Regards

View solution in original post

9 REPLIES 9
EnglishCJ
Frequent Visitor

From https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about :

Underlying data source is an OLAP source, containing measuresIf the underlying data source contains measures, such as SAP HANA or SAP Business Warehouse, then importing the data brings other issues. It means that the data imported is at a particular level of aggregation, as defined by the query. For example, measures TotalSales by Class, Year, and City. Then if a visual is built asking for data at a higher-level aggregate, such as TotalSales by Year, it's further aggregating the aggregate value. This aggregation is fine for additive measures, such as Sum and Min, but it's an issue for non-additive measures, such as Average, DistinctCount.

To make it easy to get the correct aggregate data, as needed for the particular visual, directly from the source, it would be necessary to send queries per visual, as in DirectQuery.

When connecting to SAP Business Warehouse (BW), choosing DirectQuery allows for this treatment of measures. For information about SAP BW, see DirectQuery and SAP BW.

However, currently DirectQuery over SAP HANA treats it the same as a relational source, and provides similar behavior to import. This approach is covered further in DirectQuery and SAP HANA.
Anonymous
Not applicable

How can the Storage Mode be changed when the Data Source is an Analysis Services database?

BhaveshPatel
Community Champion
Community Champion

direct.PNG

 

Can you see something like this in Query Editor, Change the Connection Settings to Import Mode,

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Hi  Bhavesh , 

 

Thanks for your reply 

 

we are not able to get that option in edit query . 

You can see this message when you select the Source option in your query applied steps.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Hello Bhavesh , 

 

i can able see the import and direct query option .. in Edit query but there it was disabled please check my intial screen shot 

Hi @kanth32,

 

If you're connected by Direct Query, you'll see the message "DirectQuery: Enabled (Click to Change)" in the status bar at the bottom right hand screen on Power BI Desktop:

 

changemode.PNG

 

Click on the message, then you should be able to change Direct Query to Import Model.Smiley Happy

 

cm2.PNG

 

Regards

Thank you!!! 2022 and still saving lives!!! 🤣

Anonymous
Not applicable

not working with me 😞

after enable " direct query "

 from options restart still disabled ...!!!

 

 

zzzzzzzzzzzzzzzzzz.jpg

 

 

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors