Explore >> Select a destination
|
You are here 
|
www.thepoweruser.com | ||
| | | | |
blog.crossjoin.co.uk
|
|
| | | | | I can hear you yawning already - yet another blog post on getting data from multiple Excel workbooks in Power Query and Power BI. Just about everyone who has ever written a blog post on Power BI has written about this subject, including me. However there's a twist this time: what if your Excel workbooks... | |
| | | | |
blog.crossjoin.co.uk
|
|
| | | | | The Web.Contents() function in M is the key to getting data from web pages and web services, and has a number of useful - but badly documented - options that make it easier to construct urls for your web service calls. Consider the following url: https://data.gov.uk/api/3/action/package_search?q=cows It is a call to the metadata api (documentation... | |
| | | | |
blog.crossjoin.co.uk
|
|
| | | | | If there's one feature of Power Query that's guaranteed to get Excel users very, very excited indeed it's the ability to combine data from multiple workbooks into a single table. The bad news is that this is something that Power Query can't do through the user interface (although so many people have asked for it... | |
| | | | |
curatedsql.com
|
|
| | | |||
