Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Composite Model - Transform Data and Model Options Disappear

Hi all   My data source is HANA, I am connected to about 7 views.   When I have all views in Import Mode, Transform Data and Model options are available:   However, when a query with Dire...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi Anonymous ,

Please note this tip under the document:

When you connect to these multi-dimensional sources by using DirectQuery, you can't connect to another DirectQuery source or combine it with import data.

So when you connect to HANA with Direct Query first, you cannot transform & combine data.

 

Best Regards,
Yingjie Li

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
5 years ago

Hi Yingjie, now I tried adding all queries in Import mode and then another in DirectQuery, but it still does not allow me to transform my data.

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi Anonymous ,

    Still could not reproduce it. I would suggest you to create a support ticket here for further help if it is urgent for you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.