Re: [MSAccessProfessionals] MS Access integration with Power BI

You're welcome.

Resuming, the best way to work in your case is, have PowerAutomate assemble a t-sql script, have PA customize that script with replacing  placeholders by variable values and throw it with Exec Query in the database. The script can function as odbc client to access data (by itself or calling custom stored procedures). A rich data environment like SQL-server is a far better place to execute vertical functionality in than PowerAutomate. The only thing we had to build a CLR stored procedure for in C# was having T-SQL become a WebAPI client (sample projects on StackOverFlow and GitHub.

 

Ironically T-SQL is by far the best client application development environment we ever used.

Robl

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of ozairkhalidozair
Sent: dinsdag 20 september 2022 08:23
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] MS Access integration with Power BI

 

Rob,

Thank you very much!

Ozair