Forum Discussion
Helper IIIMS Access to Dataverse to Dataflow
I have an Access database and I am wondering if I can export the tables to Dataverse and create a dataflow in the Power BI service of that data. If it's possible and you can point me to some resources on how it's done, I will greatly apprecaite it.
Thank you.
Hi UBComma ,
Here are some steps that might help you:
- To export an Access database to Dataverse, you need to open the database in Microsoft Access, right-click the table you want to export, choose Export, and select Dataverse. You can also create a Dataverse environment, export data from Access to Dataverse, select tables and related tables, create linked tables in Access to the migrated tables in Dataverse, manage primary keys, names, and relationships, validate the data export, and preview the results in Access and Dataverse.
- To create a dataflow in the Power BI service of the data exported to Dataverse, you need to sign in to Power BI, go to Dataflows, select Create dataflow, choose Define new entities, select Get data from Common Data Service (current environment), enter your environment URL and select Next. Then you can choose the tables you want to import from Dataverse and select Transform data. You can then apply any transformations or calculations you need and save your dataflow.
Please refer to the following posts for more information.
Export Microsoft Access table to Dataverse | Chanmingman's Blog (wordpress.com)
Migrate Microsoft Access data to Microsoft Dataverse (contains video) - Power Apps | Microsoft Learn
Get started: Migrate Access data to Dataverse - Microsoft Support
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi UBComma ,
Here are some steps that might help you:
- To export an Access database to Dataverse, you need to open the database in Microsoft Access, right-click the table you want to export, choose Export, and select Dataverse. You can also create a Dataverse environment, export data from Access to Dataverse, select tables and related tables, create linked tables in Access to the migrated tables in Dataverse, manage primary keys, names, and relationships, validate the data export, and preview the results in Access and Dataverse.
- To create a dataflow in the Power BI service of the data exported to Dataverse, you need to sign in to Power BI, go to Dataflows, select Create dataflow, choose Define new entities, select Get data from Common Data Service (current environment), enter your environment URL and select Next. Then you can choose the tables you want to import from Dataverse and select Transform data. You can then apply any transformations or calculations you need and save your dataflow.
Please refer to the following posts for more information.
Export Microsoft Access table to Dataverse | Chanmingman's Blog (wordpress.com)
Migrate Microsoft Access data to Microsoft Dataverse (contains video) - Power Apps | Microsoft Learn
Get started: Migrate Access data to Dataverse - Microsoft Support
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- UBComma
Thank you so much! This is very helpful
