How to expose windows authentication option when using TIBCO Data Virtualization connector in Power BI Desktop?

How to expose windows authentication option when using TIBCO Data Virtualization connector in Power BI Desktop?

book

Article ID: KB0073489

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All supported versions

Description

This article lines out the steps to follow in order to expose the "Windows authentication" option (in addition to the Anonymous & Basic auth options) in the 3rd "Get Data" screen when using the "TIBCO Data Virtualization" connector in the Microsoft Power BI Desktop. 

Screenshot showing the 'Windows authentication option":

User-added image
 

Issue/Introduction

How to expose windows authentication option when using TIBCO Data Virtualization connector in Power BI Desktop?

Resolution

(1) Navigate to the 'Start' Menu on the Windows desktop and open 'Run'.

(2) Paste in the below path to open the 'Extension Cache' folder of the Power BI Desktop application. 
Path: %localappdata%\Microsoft\Power BI Desktop\ExtensionCache

(3) Delete all the files present in the 'Extension Cache' folder

(4) Copy the included "TIBCO.TDV.pqx" file from the PBI driver install directory to the PowerBI Custom connectors folder. 

C:\Program Files\TIBCO\Power BI Connector for TIBCO(R) Data Virtualization\TIBCO.TDV.pqx
Copy to:
C:\Users\<MYUSER>\Documents\Power BI Desktop\Custom Connectors

(5) Restart Power BI desktop