SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Data Virtualization Tools and Software Denodo Platform and Data Virtuality Tutorials and Downloads for SQL Database Developer

Connect Data Virtuality from Power BI Desktop

If you use Power BI Destop to visualize your business analytics reports as data source it is possible to connect Data Virtuality Logical Data Warehouse databases using new build-in connector for connection between Power BI and Data Virtuality. This Power BI tutorial illustrates the steps for report developers to create the database connection between Data Virtuality and Power BI Desktop.

Power BI Data Virtuality connection

Launch Power BI Desktop (latest version starting from January 2020)
Start selecting the data source to get the data for your Power BI report.
If you click on "Get Data" ribbon button you will be requested to select the Power BI connector
Report developers can filter for "Data Virtuality" as seen below to access the Data Virtuality connector built for Power BI to connect Data Virtuality servers.

get data from Data Virtuality for Power BI report

After connector selection is done, click on Connect to provide server and authentication information for a successful Data Virtuality connection.

Before connection details, following warning about third-party service connection could be displayed in front of the report builder.

Power BI Data Virtuality LDW connector

Click Continue for following steps

Power BI Data Virtuality connection settings

Enter the Data Virtuality server name or the IP address of the server.
By default port number 35433 will be used for communication.
If your server is configured for another port, then you should provide the server information as follows:

For the database name, most typical Data Virtuality installations use datavirtuality for the database name.

After you select either Import or DirectQuery options for the data connetivity mode of your report, click OK

Then report developer should provide a valid user credentials that will be used by Power BI to access Data Virtuality LDW

Data Virtuality credentials

Please note that when you press Connect button, the connection between Power BI Desktop and Data Virtuality database will be validated and the credentials will be saved and stored for future accesses.

Data Virtuality tables and views for Power BI report data

Power BI report developers can preview the data for the selected table or view and click on Load to add data as a data source of their report.

If the data source created or connected on Data Virtuality server via DV Studio has thousands of data objects like tables or views, sometimes Data Virtuality Studio cannot handle this data source based on the memory capacity of the Data Virtuality server. And in some cases, although there is not a visible problem on Data Virtuality instance for the user during his or her interaction over the Data Virtuality Studio, integration with other third party tools can have problems. For example, during integration with PowerBI Desktop using the new (beta) version of Data Virtuality connector.
If this is not the case with your Power BI connection, then you can work without any problem.
If you have this error and can not display the tables/views existing under specific data sources, I would recommend you to reduce the number of data objects, I mean tables or views for Data Virtuality data sources by using schema filtering or by providing a table name match expression.

Data Virtualization

Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.