Hello - I am connecting to a SQL Database, and am select Import for Data Connectivity Mode.
After shaping my data in the query editor, the data source is being switched to DirectQuery mode. This is then causing an error as I am using transformations that are not supported by DirectQuery. Clicking the "Switch all tables to import mode" option or switching the data source back to Import with the UI in query editor both have no effect on this.
Has anyone encountered this and identified a solution?