Forum Discussion

Yogisha's avatar
Yogisha
Frequent Visitor
6 years ago
Solved

Direct Query to import method - SAP BW

Hi,   Please help if we can change Direct query to Import method for SAP BW as data source.    Thanks, Yogs
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

Yogisha's avatar
Yogisha
Frequent Visitor
6 years ago

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

 

Thanks,

Yogs

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    You should.. Here's a full screencap: 

     

  • apentyala's avatar
    apentyala
    Helper II
    6 years ago

    Enable the Composite Models option and try

    • Yogisha's avatar
      Yogisha
      Frequent Visitor
      6 years ago

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

      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        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.