Forum Discussion
Unpivot the star schema table in direct query mode
Hi, I am now trying to build a table using data from SQL Azure database, connected in direct query mode My database used to be flat database, without any dimension tables and I could unpivot the...
keondopark You can Transpose your query with advanced editor, however that action will result in changing the connection to "Import".
Put another way, that action is not supported in Direct Query, but you could do it if you imported the data. If you want to stay in Direct Query mode, than you will need to do this in the database.
I deleted the relations after import the fact table, unpivot and create relationship again in Power BI.
It needs some manual jobs, but it is working anyway.