Re: [MSAccessProfessionals] MS Access integration with Power BI

Hi Ozair,

I found this:

Connect to Access in Power Automate Desktop via ODBC (cdata.com)

In general I would do all interconnectivity on the Microsoft PowerPlatform through PowerAutomate or Azure equivalent LogicApps. Works best.

Remember you can add TableMacros to Access tables to get create fantastic and simple middleware with PowerAutomate. You just fill in the procedure parameters into a dedicated table. It takes you a couple of weeks to build up routine for testing and debugging in TableMacros but you'll be 10 times more productive in there then than in VBA (providing you haven't built a toolset for yourself in ther but event those can be invoked from TableMacros).

Rob

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of ozairkhalidozair
Sent: maandag 19 september 2022 10:45
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] MS Access integration with Power BI

 

Hi,

Presuming we could use Power BI Desktop for free.
So has anyone tried using Power BI reports/visualizations inside MS Access?  

Best,
Ozair