Power Query Equivalent to "Starts with...Connect by Prior" in Oracle?

[Evogelpohl]

I was given an Oracle DB query that uses the hierarchical query structure, "starts with.. and connect by prior".

I confess I don't really understand what this is doing - not a DBA - but i get the basics (e.g. Manager/Emp.)  However, I'd like to reproduce this query using PowerBI Designer / Power Query.  (Yes, I understand I could use my friends SQL in Power Query directly, but I have other things I'd like to get as well).

Does Power Query have an equivalent function/feature to this?  If so, can someone point me to a good article?

Thanks

Eric.

[Greg_Deckler]

You can choose to connect to the Oracle DB and you can just copy and paste the query into the "SQL statement (optional)" field just below the Server field.

[Evogelpohl]

Yup, aware of that.  And it works.

However, I'd like to learn the Power Query apporach.  I want to make some significant changes to the SQL outside of the /starts with/ and /connect by prior/ portions of the code.

So, what if I didn't have the SQL to begin with?  Does Power Query know how to deal with this structure?  Would i use PATH in PowerPivot?

-Eric.

[curth · Accepted solution]

Power Query doesn't currently understand this kind of structure, and I don't recall having gotten any requests for it before. As always, feel free to suggest it at the UserVoice so we can get a gauge of the user demand.