Re: [MSAccessProfessionals] MS Access integration with Power BI

Sorry Ozair,

I knew it was working but only now our final findings from 3 years ago (with the help of Ben Clothier) come back to me again. The cData solution will be the simplest. Using SQL-Server you need to C# webservices from us that we can get you for free if you want to use them.

 

Accessing access tables from SQL-server will work fine but you need an active Access engine to run table macros and VBA.

Kind regards,

Rob

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Rob Koelmans
Sent: maandag 19 september 2022 11:30
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] MS Access integration with Power BI

 

Ozair,

I just saw this ODBC driver is a 999 dollars. A free and even better solution may be to go by the SQL server connector.

You create a small t-sql script in Power Automate (complete or using one or more stored procedures in SQL-Server). That way you can have SQL-server to format the requested data into JSON format. SQL Server is extremely efficient in that. You would have to check whether SQL-Server Express Edition supports everything but I guess so.

Rob

 

Connect Access to SQL Server (microsoft.com)

 

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Rob Koelmans
Sent: maandag 19 september 2022 11:07
To: MSAccessProfessionals@groups.io
Subject: 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