Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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
MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

If your model as you refer is only on direct query the modeling view will not be available if you add another table that is not direct query you will get the composite model you are looking for.

 

I made a test and made a table with DQ and no relationship and edit query options when I add the table got the composite model and one  table with DQ and another import.

Added a new DQ table and everything remain editable.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI @MFelix , Currently I have 14 queries in import, and 1 in DirectQuery, yet I still do not see Transform Data option.