Forum Discussion
Unpivot Error: Data Source Error
Hello, inside the query editor I am trying to unpivot a table. Its a table from an Azure SQL Server and its in direct query mode. However when trying to unpivot I get the following error: ...
Hi Anonymous,
Based on my research, it seems to be an SQL query issue with the Unpivot operator. Followings are two similar thread for your reference.
In this scenario, I would suggest you try manually writing the Unpivot SQL query, and use it to import data from Azure SQL Database using Native Database Query with Power BI. :smileyhappy:
Regards
Is there a no-code way to do this? The concept behind PowerQuery was to be able to do everything with clicks, however almost all the 'solutions' to problems involve some sort of code, python, and basically not suitable for business users?