Monthly Archive: April, 2021

21st April 2021

Excel Power Query – VBA to Edit a Parameter Value

This post is to document how to use Excel VBA to edit a parameter value without using the a cell reference in Power Query.

Excel/Power Query/VBA

7th April 2021

Power BI Desktop Connecting to Dataverse

Dataverse is a secure flexible data storage solution that is part of the very popular Microsoft Power Platform family. So connecting to Dataverse is an obvious request. Dataverse was previously known as Common Data Service. This post is from getting very frustrated mid-hackathon and trying to connect to Dataverse and just getting an odd error. If you want to learn...

Power BI/Power Query/Uncategorized