Forum Discussion
Solved
Query not Folding while extracting hour from datetime.
I have a dashboard which i want to deploy to an oracle DB, the DB size is huge so i was planning to go with the incremental refresh. I've set the parameters and filtered the Datetime field, but the ...
cmkrishnaprasad If you are using a source like RDBMS, it is preferred to have views at the source that take care of the basic transformation so that query folding doesn't break. In this case, I would recommend you create views, and use that in the Power BI rather than doing transformation in PQ.
cmkrishnaprasad If you are using a source like RDBMS, it is preferred to have views at the source that take care of the basic transformation so that query folding doesn't break. In this case, I would recommend you create views, and use that in the Power BI rather than doing transformation in PQ.