Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Avoid direct query by dumping data to CSV?

I need to use Direct Query to connect to a data model and the data is not cleaned and needs to be manipulated greatly. I keep running into the error in Power Query, "This step results in a query that...
Need Help
Tutorial Requests
  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous you cannot do DQ to CSV, only Import. How big is a dataset that needs to be DQ? There are many factors when it comes to these kinds of modeling discussion. If it needs to be DQ then most of the time you want data to be prepared/cleaned/transformed at source since there is a limited transformation you can do in PQ. Again this is not one size fits all, a lot of items go into the discussion when you go between DQ/Import and Mixed mode.

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous you cannot do DQ to CSV, only Import. How big is a dataset that needs to be DQ? There are many factors when it comes to these kinds of modeling discussion. If it needs to be DQ then most of the time you want data to be prepared/cleaned/transformed at source since there is a limited transformation you can do in PQ. Again this is not one size fits all, a lot of items go into the discussion when you go between DQ/Import and Mixed mode.