cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous5
Helper III
Helper III

Power Query Data Sources

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

3 REPLIES 3
v-alzhan-msft
Community Support
Community Support

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.

 

 

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

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?

 

2020-04-15_13-47-36.png2020-04-15_13-45-29.png

Appreciate any insight.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,866)