Power BI
You are looking at an older version of the documentation. The latest version is found here.
The Data Virtuality Power BI Connector enables you to connect from Power BI to the Data Virtuality Server. Both Direct Query and Import mode are supported.
As a Certified Custom Connector, the connector is shipped with Power BI Desktop and the On-premise data gateway. While it requires no connector-specific installation, we recommend configuring the Data Virtuality Server as described below.
Pre-requisites
- Technical pre-requisites:
- An installed Data Virtuality ODBC driver;
- An installed Power BI Desktop;
- Optional: An installed On-premise data gateway.
- Other pre-requisites:
- Access to a Data Virtuality Server instance is granted;
- Information necessary to connect:
- The Hostname or IP address of the Data Virtuality Server;
- The Port of the Data Virtuality Server;
- A valid user account with appropriate permissions to access the desired objects in Data Virtuality Server.
- The system that runs Power BI can access the Data Virtuality Server.
Usage
Connecting
Choose Get Data -> (More…) -> Database -> Data Virtuality Platform. This can be done either at the startup screen or the Ribbon:
Enter the Data Virtuality Platform connection settings:
Enter credentials:
The credentials will be stored in Power BI. The stored credentials are accessible via File -> Options and settings -> Data source settings. The '
{"server":.., "database":..}
' visible above is the identifier used within Power BI for the specific connection. Thus, one set of credentials can be stored per unique combination of server and port (as specified, this means that localhost
and localhost:35433
are technically the same, but two different connections from Power BI's point of view) and database.
Selecting Data
Navigate through (data source and virtual) schemas and select the tables/view you want to use:
Adding Relations
Review the relational model and add relations:
Creating Reports
Build fast dashboards using your data stored in the Data Virtuality Platform:
SSL
The first connection attempt made by the Power BI connector will always use SSL. If that attempt can not succeed, the Power BI connector offers to connect to the same address without SSL:
The SSL settings will be stored with the credentials assigned to a particular connection and can be changed via File -> Options and settings -> Data source settings -> Encryption:
Configuration
comparableLobs
We recommend setting the system property org.teiid.comparableLobs
to TRUE
for the Data Virtuality Server being accessed by Power BI.