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

All responses (3)

Answers (0)

Anonymous5 107 on at

Like (0)

Report

Re: Power Query Data Sources

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.
Anonymous5 107 on at

Like (0)

Report

Re: Power Query Data Sources

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
v-alzhan-msft on at

Like (0)

Report

Re: Power Query Data Sources

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.