Power Query - Power Query List of PQ Solutions

Post Reply
User avatar
paspuggie48
Posts: 659
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

This isn't a 'refreshable' PQ solution but just an example how one can get data, even from the Bet Angel Forum ;)

Power Query List of PQ Solutions.xlsx

This probably only works as I'm already logged in to the Forum, so if one tries to click on the hyperlinks in the Table then I'm sure you'd also need to be logged in. I don't know, you'll have to try 8-)

Actually, it's a mix of Power BI to get the data, transform it and then export that data as CSV file. I then used Power Query to connect to that CSV file to create the Table and add a Hyperlink (using the Hyperlink function).

Again, this is just an example of what one can do :D

PowerQueryPosts.png
You do not have the required permissions to view the files attached to this post.
User avatar
paspuggie48
Posts: 659
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

All posts span 2 pages, there is a way to paginate multiple pages but I did it a crude way.

Full list now attached.

Power Query List of PQ Solutions.xlsx
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2184
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

nice work. :)
Post Reply

Return to “Excel Power Query”