Forum Discussion
Helper IODBC connector does not update credentials from ODBC driver - PostgreSQL
Greetings, good people!
I have ODBC POSTGRESQL driver configured with several hosts and databases so the power bi ODBC connector can get to them ( all actions performed on windows machine ). Test connections were succesfull for every database.
The odbc connector in power bi asked me for credentiales the first time I selected a source on the driver, I thought it was weird since I supposed the credentials should be imported from the ODBC driver. Nonetheless, the connection worked for the first database. However, when I tried to connect to other sources from the ODBC driver power bi didn't ask again for credentials, because it used the previous source credentials, hence producing an error:
This is because credentials are of course, different for each database, but power bi got the first credentiales fixed or something. Maybe somenone migh give me a hand to force power bi to ask for credentials or to forget previous credentials? Thank you in advance.
Hi , Jhorman_Gomez
According to your requirements, it seems that your PBI dekstop failed to connect to the ODBC data source because the application remembered the credentials, cached the data, and wanted some help with "forcing Power bi to ask for credentials or forgetting previous credentials". If convenient, you can find the ODBC-related cache credentials in the corresponding deksotp file "Data source settings" and delete them:
If this method does not allow the application to force the new credentials you entered, you can go directly to the folder and navigate to the path "C:Users<user name>AppDataLocalMicrosoftPower BI DesktopUser.zip", and delete the configuration folder that stores all data source credentials for local desktop.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
- v-yueyunzh-msft
Community Support
Hi , Jhorman_Gomez
According to your requirements, it seems that your PBI dekstop failed to connect to the ODBC data source because the application remembered the credentials, cached the data, and wanted some help with "forcing Power bi to ask for credentials or forgetting previous credentials". If convenient, you can find the ODBC-related cache credentials in the corresponding deksotp file "Data source settings" and delete them:
If this method does not allow the application to force the new credentials you entered, you can go directly to the folder and navigate to the path "C:Users<user name>AppDataLocalMicrosoftPower BI DesktopUser.zip", and delete the configuration folder that stores all data source credentials for local desktop.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Jhorman_GomezHello v-yueyunzh-msft , many thanks, first approach worked very well. I'll save the second approach as plan B for future scenarios. Regards.