Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Data Source Credentials Option Greyed Out for ODBC Connection (Denodo)

Hi Community,   I am using 32 bit ODBC DSN to Connect Report builder to Denodo. I have Created Paginated Report using Configured 32 bit ODBC DSN and Report is working fine in Report Builder but whe...
Denodo
ODBC
Paginated Report
Power BI report builder
  • Anonymous's avatar
    Anonymous
    5 years ago

    I have changed connection string in report builder by removing all other struff and keeping only DSN="Dsnname". It worked for me. Also microsoft is working on this. i think this could be bug.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-yalanwu-msft ,

 

Thank you for the quick response.

I have installed 32 bit ODBC driver and created 32 bit DSN with the name azurepbigwODBC for ODBC connection with Report Builder.

Then I have added same DSN on 64 bit Gateway machine. Also i have added ODBC DSN in "Manage Gateway" power BI Section but no sucess.

 

Note: I have 32 bit and 64 bit both ODBC drivers installed on my local machine and gateway machine have 64 bit gateway.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I have changed connection string in report builder by removing all other struff and keeping only DSN="Dsnname". It worked for me. Also microsoft is working on this. i think this could be bug.