Forum Discussion
Redshift native query file size
So the short version of the story is that when we were creating the data set in Power Query and using M, we were having a lot of issues with the dataset not refreshing and getting a lot of timeout er...
Hi Anonymous ,
As the official document said,Power Query gives you the flexibility to import data from wide variety of databases that it supports. It can run native database queries, which can save you the time it takes to build queries using the Power Query interface.
Here is a blog talking about a similar scenario, you may kindly refer to:
Solved! Query folding for native SQL in Power BI
Differences between the M Language and DAX in Power BI
Query Folding On SQL Queries In Power Query
Best Regards,
Eyelyn Qin