Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Christianvs
Helper I
Helper I

Connect Power Apps to ODBC

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

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

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

View solution in original post

3 REPLIES 3
IrvingSteel
Regular Visitor

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
Community Support
Community Support

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

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.