DMTS_DatasourceHasNoCredentialError Error in powerbiService.

[Anonymous]

I have created a powerbi pagenated report in reportbuilder. The data source is Psql Flexi server on Azure Cloud. I did installed ODBC drivers on my machine, configured it and build the report.
The report works fine in the reportbuilder. But when i publish the report in powerbi service. I am getting this error

"Unable to render paginated report

There was an error contacting an underlying data source. Manage your credentials or gateway settings on the management page. Please verify that the data source is available, your credentials are correct and that your gateway settings are valid."

Since my data source is not on premise i dont have to install a gateway. The problem lies with Managing credentials.
In the Manage page connection and gateway settings of the workspace i see that 
the status of my conncetion is offline 

Does anyone knows how to resolve this issue? 

[v-csrikanth]

Hi @Anonymous 
we wanted to kindly follow up to check if the solution provided for the issue worked or let us know if you need any further assistance req.
If our response addressed, please mark it as Accept as solution and click Kudos if you found it helpful.
Thank you.

[v-csrikanth]

Hi @Anonymous 
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you.

If yes, please accept as solution to help others benefit. If not, feel free to reach out.
Thank you.

[v-csrikanth]

Hi @Anonymous 

I wanted to check if you had a chance to try the suggested solution.
Please let us know if you need any further assistance.

Looking forward to your update!

If the above information helps you, please give us a Kudos and marked the reply as a solution.

Thanks,
Cheri Srikanth

[v-csrikanth · Accepted solution]

Hi @Anonymous 
Below are steps that resolve this issue:

1. Remove the Gateway:

   • In Power BI Service, navigate to your workspace and then to Data Source Settings.
   • If the gateway is selected and the option to remove it is greyed out, try to reconfigure the data source without selecting the gateway.
   • On the data source credentials page, click edit credentials and select none. This will bypass the need for a gateway.

2. Fixing the Credentials Issue:

   • Make sure you're using basic authentication or the appropriate method for PostgreSQL.
   • Enter the PostgreSQL credentials (username, password) along with SSL connection settings (if needed).
   • If the option to save credentials is disabled, it could be because Power BI is still trying to use the gateway. By switching to None (Cloud data source) in the credentials configuration, you should be able to save the credentials properly.

3. Check the Status:

   • After saving the credentials, ensure the connection status changes to Online.
   • If the status still shows as Offline, try refreshing the page, or check if there are any lingering configuration issues.

Thanks and Regards,
Cher Srikanth
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[rohit1991]

hi @Anonymous ,

Steps to Resolve:

1. Switch to Cloud Data Source:

   • Since your PostgreSQL is on Azure Cloud, you do not need a gateway. Remove the "Personal mode" gateway in the settings.

2. Set Up Data Source Credentials:

   • Go to Data Source Credentials in Power BI Service.
   • Edit credentials and select Basic Authentication or the required method.
   • Provide your PostgreSQL username, password, and ensure SSL settings are correct.

3. Verify Status:

   • After saving credentials, ensure the status changes to Online.

4. Test the Report:

   • Run the paginated report in Power BI Service to confirm it renders successfully.
     
     

for further reference please visit, https://learn.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-data-sources

[Anonymous]

Hi @rohit1991, Thanks for replying.
The option of changing the gateway is greyed out 

Is there any different way to remove a gateway. The gateway was already selected by powerbi service.
Also i am unable to save after adding credentials in the Authentication section. Is that becuase of the gateway?