Forum Discussion

Sreekanth1996's avatar
Sreekanth1996
Frequent Visitor
1 year ago

Issue : with Configuring Data Source Connection in Power BI Service Using On-Premises Gateway

Hi everyone,I am facing an issue while configuring the data source connection in Power BI Service using an On-Premises Data Gateway.Here is the background of my setup:I have imported data from a Post...
General Comment
collinq's avatar
collinq
Super User
1 year ago

How Sreekanth1996 ,

 

I found this article https://monocroft.com/how-to-fix-power-bi-postgresql-connection-error/#:~:text=To%20do%20this%2C%20login%20into%20the%20PostgreSQL%20server,connect%20to%20PostgreSQL%20without%20encountering%20the%20error%20anymore.

 

Which talks about this issue and talks about issues correlated to this error message.

 

I also found this article which has some troubleshooting steps:

https://powerbipoint.com/2024/01/22/fix-power-bi-refresh-error-could-not-load-file-or-assembly-or-one-of-its-dependencies-either-a-required-impersonation-level-was-not-provided-or-the-provided-impersonation-level-is-invalid/

 

Sreekanth1996's avatar
Sreekanth1996
Frequent Visitor
1 year ago

Thank you for your help, but I am unable to proceed further because I am a Power BI developer and don't have access to the server configurations. I was able to connect and load the data into Power BI Desktop by providing the credentials (server, database, username, and password as admin credentials). However, when trying to configure the data source with the same credentials in Power BI Service, I am getting the error mentioned in the screenshot, and I am not able to see the OAuth 2.0 option in the authentication method.

My PostgreSQL is hosted on Google Cloud Platform as a cloud-based data source provider. Please let me know exactly what needs to be done from the server side and Power BI side. If I am unable to handle the server-side configurations, I will pass the instructions to the DB Admin.