Power Platform Community Forum Thread Details

我想要开发一款power apps。网上大部分教程使用的数据源和我的不一样。我想要用windows odbc 里的dsn 做power apps的数据源。请问有人有具体方案么？非常感谢。

I want to develop a Power Apps application. Most online tutorials use different data sources than mine. I want to use a DSN from Windows ODBC as the data source for my Power Apps application. Does anyone have a specific solution? Thank you very much.

Categories:

Building Power Apps

Hi @CU05120549-0, Hope you are doing well!

As per my knowledge, I dont think that there is “ODBC” connector in Power Apps like you see in Power BI or Power Query.

A canvas app can only connect through first‑party connectors (SQL, Oracle, etc.), Dataverse, SharePoint, custom connectors, or Power Automate flows; none of these accept a Windows DSN directly.

You can configure an ODBC data source using your DSN in Power Query check this https://learn.microsoft.com/en-us/power-query/connectors/odbc

Then store the data in may be Dataverse using middle man like Power Automate and then use in PowerApps.

Other option could build custom API and then using that custom API, create own custom connector and use in PowerApps.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Thanks,
ANB