Data Verse in powerapps

[shanthipola]

Hi Team,

I have an ODBC database and extracting all the tables using MS Access. Now I'm stuck at getting those tables in dataverse

When I try to go to Dataverse and trying to get data from any of the data source it is not working.

Can you someone please suggest how to get the data from odbc databse.

Thank you,

Shanthi

[dpoggemann]

Hi @shanthipola ,

Have you looked at Dataflows?  You can take a look a this article to give you some guidance:  https://docs.microsoft.com/en-us/power-query/dataflows/add-data-power-query 

[shanthipola]

Hi @dpoggemann 

Based on the above link I tried but what would be the connection settings in my scenario?

[dpoggemann]

Hi @shanthipola 

Assuming your information is in an on premises database, you will need to utilize the Data Gateway.  https://docs.microsoft.com/en-us/power-query/dataflows/using-dataflows-with-on-premises-data 

This is a premium connector so you would need to have a Power BI or Power Apps license to be able to connect to the SQL environment.  Hope this article helps you.