Introduction To Microsoft Power Query. Its also pretty powerful. On the Power Query ribbon tab from inside the Get External Data group click From Web.
In this task you will create a Power Query query to source data from the web page. The reasons were to offer an alternative to OData and SQL for getting data from SQL Server connector. It basically enables business users to access data stored in data sources seamlessly whilst reshaping it to fit their needs.
Since last weeks post proved very popular it turns out people want video - who knew I thought Id post the recording of a presentation I did earlier this year at the Power BI User Group in Wellington New Zealand called Introduction to M in Power Query and Power BI.
With Power Query you can then bring all those sources together using your own unique combinations and uncover insights you otherwise wouldnt have seen. In this task you will create a Power Query query to source data from the web page. In September 2018 Microsoft announced the integration of Power Query Online for Microsoft Flow. It basically enables business users to access data stored in data sources seamlessly whilst reshaping it to fit their needs.