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.
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
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.