Fleetio Power Query Connector
Microsoft Power Query is data transformation and preparation engine, that allows you to connect to external data. A couple of common applications in the Microsoft ecosystem that use power query includes Microsoft Excel, Microsoft Power BI, and Microsoft Power Apps.
Getting Started
To showcase how our Power Query Connector works, we will be walking through the setup of using Microsoft Power BI Desktop
Our Power Query Connector is not officially certified connector through Microsoft. While you cannot currently use our connector within Power BI Service, you can still build reports with Power BI Desktop and then push the results to Power BI Service. Scheduled refreshes are currently not supported
Using our Power Query Connector
While our connector is in the process of becoming a certified connector, you must have access to our power query connector configuration file. If you are interested in using the connector, please refer to our GitHub Repository for more information
Below is a quick start on how to use our Power Query Connector with Power BI Desktop:
In order for our custom connector to work with your Power BI Desktop environment, you will need to check (Not Recommended) Allow any extension to load without validation or warning in the Power BI security settings. Please confirm with your security organization before changing this setting
- Install Power BI Desktop
- Under \Documents\Power BI Desktop\Custom Connectors, be sure to paste the Fleetio.mez extension that can be downloaded here
- Open PowerBI, and go to File > Options and settings > Options > Security > Data Extensions. Check the option (Not Recommended) Allow any extension to load without validation or warning
- Restart Power BI Desktop
- Go to Get Data and search for Fleetio (Beta) (Custom) in the list
- After, simply follow the prompts from Power BI to get your data connected
Building
Our Microsoft Power Query Connector was built with the Power Query SDK