Forum Discussion
Solved
AWS Athena connector executes Power Query transformations in wrong order
I am using the Power BI AWS Athena Connector with Simba Athena ODBC driver to import data in Power BI Desktop. This works fine as long as I don't change the data types. I have a text column which I w...
Issue Table.StopFolding command to stop the operation being pushed back to the source. Example is given below
https://docs.microsoft.com/en-us/powerquery-m/table-stopfolding
Note - It doesn mean that you will lose the benefit of Query folding in successive operations.
Issue Table.StopFolding command to stop the operation being pushed back to the source. Example is given below
https://docs.microsoft.com/en-us/powerquery-m/table-stopfolding
Note - It doesn mean that you will lose the benefit of Query folding in successive operations.
Hi, what if the source is not a table instead its a query.
let
Source = Odbc.Query("dsn=DW", "SELECT * FROM Table_name WHERE fiscyear >= 2020 ")
in
Source