Integrate On-Premise SQL Server Database with Canvas Apps using Data Gateway

[@donadfull8887]

is the data gateway for Power Apps the same as the one for Power BI? Are those data gateways multi purpose, or do we need both of those gateways, each for its own purpose ?

[@dba3579]

Hi Softchief. Thanks for sharing your knowledge. Do we need multiple connections when a database server has multiple databases?

[@mohamedaminetrigui3682]

Thank you for the video, can we then connect a SQL DDB to Dynamics Sales for exemple ?

[@bibeknaha6573]

Hi, I have created a localdb server which server name as (LocalDb)/newServer which I am able to connect from SSMS, could you tell me how can I connect the same in power automate sql server..as I'm receiving error. I have followed steps you have shown in this video but unable to connect

[@sameenashaik3928]

Do we need to take SQL server premium licence ? If yes what is the cost please

[@alexotoous]

patch function can't be used?

[@robbinz-gi1ps]

I am able to see my table from SQL Server in PowerApps but no columns are visible. What would cause this?

[@lalasahebgaikwad1154]

Thanks for this video , I was looking for the same 🎉

[@aimannishat2120]

I am getting this error We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'. inner exception: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'. clientRequestId: 9f3f20b7-28f2-40be-b2e9-6ef0fd0c3030 Can you please help?

[@JometVJ]

Hi Softchief, Great informative video, i've a problem choose gateway - 7:11 I'm not getting that even after installing the gateway. i'm using this gateway to access SQL tables to power BI too it is working fine but unable to find this gateway in power apps. could you please suggest a solution for this?

[@hajaribnibrahym2784]

I have this problem too

[@abhilashdeulkar2961]

Hi Softchief, Thank you for such a good content, there is more question i have, I want PowerApp gateway, can i use my Power BI gateway for PowerApp? I am looking forward for your response :) Thank you so much.

[@softchiefguru]

yes you can

[@vineelalondonmuchatlu5953]

Great videos..subscribed 🙂

[@bharathkumar_p]

you must have to do videos like these and share knowledge

[@softchieflearn]

Thanks