Forum Discussion
is Import data from a database using native database query good option
I Need to use direct query for my reports that make my impossible to us power query,so i dont can format my data the right way ,so i try to use the sql server native query option,but i see on the doc...
mf123 Not sure I 100% understand the ask. First, it is generally optimal to push data transformation as far back as possible. So, if you need to do data transformation then do it by creating a SQL View for example and then just connect directly to that view. You can do a query that executes a SQL query. That is perfectly fine as long as you don't need to do any additional data transformation within the query itself because at that point you can't preserve query folding.
thanks for your answer,my problem is that i use dataverse so i can't create views
