Forum Discussion

KasperJ90's avatar
KasperJ90
Icon for Helper III rankHelper III
3 years ago

Change from import to direct query

Hi,   I have a dataset with 40 tables. 1 of these tables are 3 merged views in power query (sales invoice, sales order, sales credit note). So the views are entered in my data model from views on a...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

KasperJ90 You have to be careful about the transformation steps, not all transformations are possible in DQ. If you are using a view, I recommend pushing those transformations back to SQL view instead of doing it in PQ.

KasperJ90's avatar
KasperJ90
Icon for Helper III rankHelper III
3 years ago

parry2kThanks for the advice, but how can I accomplish direct query by using the existing dataset? Should I create another dataset or how can I do this (not best practice but pragmatic)?