BI Beginner: Power Query and OData

I’ve observed that not very many data professionals are familiar with OData . It’s an open data access protocol built on AtomPub and JSON . It provides a REST ful means of retrieving data, which is what this post is about. One of the things that makes OData important is that it is recommended by the Open Government Data Initiative. Although this post uses the familiar SQL Server AdventureWorks database, remember, OData is open. It’s not limited to SQL Server or even SQL databases in general. A small…(read more)