Power Query M - Can you have multiple queries in the same file . pq? (Visual Studio with SDK)

Asked

Viewed 4 times

-1

I am developing a connector, whose idea is to return N queries to the caller.

I already varri the internet and several tutorials from Microsoft.

Inside a file . pq, I have the following:

Let

TabelasSistema = Sql.Database("xxxxxxxxxxxxx.xxxxxxxxxx.us-east-1.rds.amazonaws.com",
"XXXXXXXXXXXXXX",
[Query = "select TABLE_NAME [NOME TABELA] from information_schema.tables order by 1"]
)

in

TabelasSistema

This works perfectly. It’s a simple query. I need, in this file, to be able to have N simulated queries (several separate selects).

That’s possible?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.