M Query from SQL Server stored procedure

[hctr83]

Hi all,

I'd like to build a query in the advanced editor and I need to do it dynamically reading data from a SQL Server database. I've created a stored procedure that returns the complete M query that I need to execute:

let
   Source = Sql.Database("SVBINTBD02", "BI_staging",
     [Query="EXEC [altaonl].[LlamadaAppInsightsErroresProspects]"])
 in
   Source

This sentence returns the text of the query that I want to be executed in M language.

How can I do it?

Thanks in advance,

Héctor

[v-jiascu-msft]

Hi @hctr83,

You already can do it. What's your expected result? Or what's the problem?

Best Regards,

Dale

[hctr83]

Hi Dale!

Thanks a lot for your comment.

The string returned by the stored procedure is the query that I want to be executed (it's a query wrote in M language to get data from Application Insights -> in Azure).

How should I write it in the advanced editor?

Best Regards!

[v-jiascu-msft]

Hi @hctr83,

As far as I know, this isn't available for now. What's your purpose? Maybe we can find another approach.

Best Regards,

Dale