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

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

 

 

 

 

  • Yogisha's avatar
    Yogisha
    Frequent Visitor
    6 years ago

    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'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