Hello Haystack,
you can use the Microsoft SQL Server Connector node also to log into an Azure SQL Database which is basically a standard SQL Server in the cloud. Once connected you can use the standard DB nodes such as the DB Writer, DB Insert or DB Update node to push data into the database.
To obtain the JDBC connection information log into the Azure portal and select the database you want to connect to. Once the database is selected click on the Connection strings option in the left menu bar. Then select the JDBC tab which will look like the following:
You can then either use the dedicated Microsoft SQL Server Connector node and enter the given information into the Connection Setting and JDBC Parameter tab
or you can also use the generic DB Connector node and paste the complete URL with your password into the Database URL field
In both cases make sure that you are using the official Microsoft SQL Server driver that you need to install separately in KNIME due to license restrictions. For further details see the Third-party Database Driver Plug-in section of the database documentation.
We are also looking into the development of dedicated nodes for Power BI which will work similar to the Tableau integration. Would this kind of functionality e.g. pushing data directly to Power BI server be enough to solve your problem? Do you have other use cases e.g. loading data from Power BI into KNIME?
Bye
Tobias