Forum Discussion
SQL Query in Direct Query Mode in Power BI
Hi , I'm trying to build a dynamic report using Direct Query connection connecting to SQL Server , I can able to connect to direct tables and from there I'm able to create visuals where the data...
SanthuWilly4 , Transformation in direct query mode is limited to a certain set of operations. So need to check what is possible what is not. I do not think complex transformation on XML is there.
There are a few basics operations I tested out that work. But I doubt what you need is.
What I tested on direct query -https://www.youtube.com/watch?v=My0bLn9voo4&list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA