get the mquery structure of each data source connector within power bi config files

[sheetals]

Hi all,

Is there any way I can find the mquery structure/syntax of every datasource connector supported by powerbi within any of the power bi config files?

for ex: oracle db mquery syntax : Oracle.Database()

[sheetals]

I read from here custom connector  it is a .pq file, where can I find it for all the connectors?

[V-lianl-msft · Accepted solution]

Hi @sheetals ,

If you want to get the Mquery in pbix file, you can refer to the reply of this thread(12th reply):

https://community.powerbi.com/t5/Desktop/DataMashup-file-no-longer-exists/td-p/1145141 

In addition, this is all access data functions:

https://docs.microsoft.com/en-us/powerquery-m/accessing-data-functions 

Connectors in Power Query

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.