How to get all Connectors in Excel Power Query which exist in Power BI

[msofficesolutio]

How to get all Connectors in Excel Power Query which exist in  Power  BI 

[v-juanli-msft]

Hi @msofficesolutio

If I am understanding your question correctly, you are wanting to copy your connections made in Query Editor in Power BI into the Power Query (Excel)  , correct?

If that's that case, then simply open your advacnced editor in Power BI and copy/paste the entire code into your advanced editor in Power Query. 

Best Regards

Maggie

[msofficesolutio]

I could see there are more connectors in (Power Query )Power BI then connectors in Power Query(Excel) is there any way I can get all Power Query (Power BI ) connectors in Power Query(Excel) 

[v-juanli-msft]

Hi @msofficesolutio

When you go to Edit Queries, Get Data, you will see more data source connectors than connectors Power Query(Excel).

Some connectors doesn't support for Power Query(Excel).

To workaround this, you could connect data via power bi, then use excel to connect power bi dataset.

https://powerbi.microsoft.com/en-us/blog/analyze-in-excel-from-power-bi-publisher-july-update/

http://radacad.com/power-bi-and-excel-more-than-just-an-integration

Best Regards

Maggie