Direct Query to import method - SAP BW

[Yogisha]

Hi,

Please help if we can change Direct query to Import method for SAP BW as data source. 

Thanks,

Yogs

[Anonymous]

Simply click "DirectQuery: Enabled (Click to Change)" in the right lower corner. You can change the setup in the prompted window. 

[Yogisha]

Thanks for the reply..I am not seeing that option. Instead, I could see this Storage Mode: Direct Query. But this is not clickable.

Thanks,

Yogisha G

[Anonymous]

And if you go to "Model" -> Click the table -> Properties -> Advanced -> Storage mode

[Yogisha]

I am not seeing Model option as it is direct query.

Thanks,

Yogs

[apentyala]

Enable the Composite Models option and try

[Yogisha]

Can you please let me know where can I enable this option

[v-xuding-msft · Accepted solution]

Hi @Yogisha ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft]

Hi @Yogisha ,

Please reference the GIF. If they still can't help you, please show screenshots to us. Then we will understand your actual situation clearly.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

You should.. Here's a full screencap: