Skip to content
eWay-CRM PowerBI Data Source
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
Images
.gitignore
README.md
eWay-CRM.mproj
eWay-CRM.sln
eWay_CRM.pq
eWay_CRM.query.pq
eWay_CRM16.png
eWay_CRM20.png
eWay_CRM24.png
eWay_CRM32.png
eWay_CRM40.png
eWay_CRM48.png
eWay_CRM64.png
eWay_CRM80.png
resources.resx

README.md

PowerBI

Using this data source users are able to build reports in PowerBI using data from eWay-CRM.

Install Connector

To get started you need to first create [Documents]\Power BI Desktop\Custom Connectors directory.

After that download the latest version of the eWay-CRM Data Source into [Documents]\Power BI Desktop\Custom Connectors directory.

As soon as you start PowerBI Desktop you will notice a warning about Uncertified Connectors.

uncertified_connectors

To get rid of this warning you need to modify security settings as displayed on the picture below. Go to Security tab in the Options dialog. After you apply the changes restart Power BI Desktop.

security_settings

Get Data

As soon as eWay-CRM Data Connector is installed start PowerBI Desktop again and click on the Get Data.

Locate eWay-CRM in the data sources.

get_data

Fill in your eWay-CRM credentials. Password has to be hashed using MD5. You can use our tool MD5 Generator to create the hash.

authentification

After that Navigator menu will appear with all supported tables.

Select required tables and click Transform Data to convert JSON structure to a Table.

navigator

Click on the Expand icon in the Column1 header and select required columns. After you click OK data will be converted to a table.

expand_columns

You can’t perform that action at this time.