Power Query Data Sources

(0) Share

Report

Posted on by Anonymous5

107

Hello,

I came across the article below that highlights the use of Power Query. About halfway down the page it notes that you can get the "full Get Data experience" with multiple sources available. Is this a feature that still exists? I see the article is about a year old so perhaps it was dropped.

https://eriksvensen.wordpress.com/2018/09/25/powerquery-everywhere-now-in-microsoftflow-as-well/

If so it would open up quite a few options.

Rgds

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous5 ,

The "Transform data using Power Query" action still exists in Microsoft flow, you could take a try with the action in your flow to achieve your requirement.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Anonymous5 107 on at

Like (0)

Report
Copy link

Link copied!

Hi Alice,

To clarify I HAVE been using the Get and Transform Data for the SQL connector. If you notice in the article there is an entire panel of OTHER data sources that are shown. This is what I’m after.

I noticed it mentions an Enterprise gateway. I’m using an on-premises gateway for my Flows.

Rgds

Was this reply helpful? Yes No
Anonymous5 107 on at

Like (0)

Report
Copy link

Link copied!

All,

I'm blowing the dust off this one to see if anyone is experiencing the same issue as I am. When working in Power Automate under the SQL Power Query, I can see that there are other potential data sources are available but when I select Excel for instance, I am presented with a screen for the source details but the window will timeout and revert back to SQL only. I am unable to utilize this feature. Is this an issue specific to my account or is this a bug?

Appreciate any insight.

Was this reply helpful? Yes No