# DB Insert - error message

**URL:** <https://forum.knime.com/t/db-insert-error-message/20634>\
**Category:** KNIME Analytics Platform\
**Created:** [January 24, 2020, 2:26pm UTC](https://forum.knime.com/t/db-insert-error-message/20634 "2020-01-24T14:26:45Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![kate-rudd](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/k/919ad9/32.png) [@kate-rudd](https://forum.knime.com/u/kate-rudd)\
**Post date:** [January 29, 2020, 9:35am UTC](https://forum.knime.com/t/db-insert-error-message/20634/9 "2020-01-29T09:35:26Z")

</div>

Hi Ivan,

Sorry for the delay in response.

Thank you so much for taking the time to support me with this, I’m the only one in my company who uses KNIME and it makes a difference knowing I’ve got somewhere to turn to when I get stuck.

Whilst I was offsite yesterday I was able to do some further research and I’ve figured out the problem. My SQL database is an Azure SQL database. I’m sorry I didn’t mention this, I thought the Azure SQL database was basically the same as a regular SQL Server. I didn’t realise that it required a slightly different set up. Anyway, I followed the instructions linked below and have got it working:

> [@How to push data to Azure SQL Database?](https://forum.knime.com/t/how-to-push-data-to-azure-sql-database/17808):
>
> Hello friends, We have data on a MS SQL Server that we analyze in KNIME using the SQL Server Connector node (Figure 1.). We would like to get output data from KNIME workflows pushed to Power BI. However, as there is no connector for Power BI in KNIME, a workaround we thought of is to push the data onto Azure SQL DB and connect Power BI to that (Figure 2.). [image] Figure 1. Data pull from MS SQL Server in KNIME for analysis. Figure 2. Connect to Azure SQL Database in Power BI. How…

Thanks again for your help - I really appreciate it.

Kind regards,

Kate

---

_[View the full topic](https://forum.knime.com/t/db-insert-error-message/20634)._