Connect Power Apps to ODBC

[Christianvs]

Hi

In order to do writeback to a table in Power BI I am trying to make a Power Apps form. I added the Power Apps visual in Power BI and I have inserted a Form in Power Apps but I am having troubles connecting the data source.

The connection in Power BI is trough ODBC but I can't find that option in Power Apps. Does anyone know to setup a connection through Power Apps?

Thanks

[IrvingSteel]

If there is no conection to ODBC, is is possible to create a conenction from SQL Server to ODCB(AS400) and then create an appa with connection to sql server. ?

[v-luwang-msft · Accepted solution]

Hi @Christianvs ,

As far as I know, there seems to be no relevant odbc connector in power app. Besides, you can post this question to Powr APP special forum for consultation, and there will be experts to give you specific answers, currently the forum is only Power BI forum, and the professional level of issues related to Power APP may not be as good as Power APP forum.

refer:

https://powerusers.microsoft.com/t5/Forums/ct-p/PA_Comm_Forums 

https://powerusers.microsoft.com/t5/Building-Power-Apps/Connecting-to-ODBC-data/td-p/819149 

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/ODBC-connector-in-Powerapps-as-a-Datasource-iex... 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Lucien

[Christianvs]

Thanks for the answer luwang 🙂

After posting here I came to the same conclusion that there probably isn't any odbc connector in Power App. I might ask in the relevant community anyway.