Forum Discussion
Write Back To Snowflake Database
Hello Experts,
I want to implement Write Back functionality with Snowflake Database. I created simple Grid Report, published it to power bi service. Later edited report to have Power App Visual on Power BI Service. While creating App in Power BI App we are not having connector of Snowflake. How can we connect Power Apps to Snowflake inorder to write back to DB using Power BI Report.
Could you please suggest how to achieve the same.
Thanks in Advance!!
Regards,
Mayur
9 Replies
I believe CDATA has a Snowflake connector for Power Apps. https://www.cdata.com/kb/tech/snowflake-cloudhub-powerapps.rst#:~:text=PowerApps%20is%20a%20service%20for%20building%20and%20using,data%20from%20the%20apps%20you%20build%20using%20PowerApps.
Another route to go might be using Power Automate?
Thanks Greg_Deckler for the response. IT means we need to to connect with CDATA for this??
Also, COuld you please suggest how it can be achieved using Power Automate.
Thanks
Thanks amitchandak for the response. Link mentioned by you is for SQL Server. We need it for Snowflake. Could you please sugget an idea for Snowflake.
Thanks in Advance.
Hi Anonymous ,
As far as I know, Snowflake and SQL Server are all based on SQL engine. I think they're similar, so you can also refer to https://shabnamwatson.wordpress.com/2020/02/21/using-power-apps-in-power-bi-reports-enabling-writeback/
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hello Anonymous
Did you find a solution to move the data from power apps to snowflake? Can you share the approach you followed? I have a similar requirement.
Anonymous Do you have any solution to write back into snowflake from Power apps? please let me know.
