When using MySQL with Power BI Desktop, you may come across this error:

Value 'preferred' is not of the correct type

 

It seems that this is caused by an incompatibility between Power BI Desktop and a later MySQL Connector Net version. First, check your version:

If you are running the MySQL Connector Net 8.0.11, you may experience the error described above. To resolve the issue, install the older version:

  1. Close Power BI Desktop
  2. Uninstall MySQL Connector Net 8.0.11
  3. Install MySQL Connector Net 6.10.7 (from here)
  4. Open Power BI Desktop
  5. The error “Value ‘preferred’ is not of the correct type” should be resolved, and you can use MySQL with Power BI again

A few years back, everyone was excited about the 3D and visualisation aspect of BIM. It seems that more and more, people are getting excited about BIM Data. Many companies are building and adapting business intelligence solutions that somehow connect to or wrap-around the BIM world. One of the most popular tools at the moment is Power BI. It is extremely flexible and easy to set up and use for data analytics.

When you connect the Power BI web service to your own database, you also have to provide some mechanism for Power BI to periodically update the base dataset. The common answer to this question is the “On-premises data gateway”.

When you install the gateway on your own hardware, there are two types of gateway to choose from:

On-prem-data-gateway-install-powerbi

If you are already running a data gateway for Power BI, what happens if you want to transition the ‘gateway’ role to a new machine? Well, you need one key piece of information: the Recovery Key from the gateway when you set it up originally. If you do have this, you can simply ‘take over’ the role from an old machine and apply it to a new machine:

  1. Download the PowerBIGatewayInstaller.exe gateway installer from this page
  2. Choose your gateway type
  3. Choose to “Migrate, restore or takeover an existing gateway”

  4. Enter the information, including the recovery key

  5. Done

If you don’t have a recovery key, you will have to:

  1. Install a completely new gateway:

  2. Switch the gateway used on the web app side (Scheduled Refresh page). You will probably have to do this for every dataset.

Feel free to reply with any of your cool BIM data workflows 🙂