Unable to load Oracle data to a paginated report - failed to create windows identity for user

[watts_jim]

I have a paginated report that loads data from an Oracle DB.  It works fine on the Report Builder app on my desktop, but when run in the service it returns the following error.  The data source works fine for Power BI reports; paginated reports that use SQL Server data work perfectly, so it appears to be something on the gateway retrieving data for Report Server ?

Could not connect to the data source.

A data source used by this report returned an error.  If you continue to experience this error contract the report author or data source owner quoting: DM_GWPipelineGatewayImpersonationError.  Failed to create windows identity for user ouruser.name@ourcompany.com

[v-luwang-msft]

Hi @watts_jim ，

Pls refer the below steps:

1. Open Power BI Report Builder. Create the Datasource and test the connection. Pls use //ipaddressofdatabaseservice:port/sid as ServerName while building the datasource.

2. Write a sql query in sqlplus* or toad/sql developer  etc..  and test it. 

3.Once datasource created successfully in Power BI Report Builder, create the dataset. Now you have just paste the sql query created in step 2.  Lets say, we created below query 

   Select EmpName, EmpID, EmpJoiningDate where EmpJoiningDate = :EmpJoiningDate;  (Do not ignore : (colon) here, it is argument for Oracle sql query)

 PLEASE DO NOT create parameter seperately in power bi report builder.

Once you paste the query in query designer window, just Press Ok and your job is done. Report Bulder will create parameter automatically for you.

4. Run the report locally on your pc through report builder and make sure it is working fine there.

5. Go to  app.powerbi.com. Ensure workspace where you gone publish report is having Premium or Embedded capacity. Also , check the setting of  Admin Portal --> Capacity Setting --> Workload --> Paginated Report preview. The Paginated Report preview should be enabled. 

6.  If all these setting looks good then please publish rdl file to power bi service. Report should work fine there also.

refer:

https://community.powerbi.com/t5/Service/Power-BI-report-publishing-error-DM-GWPipeline-Gateway/m-p/... 

Best Regards

Lucien

[watts_jim]

I've been playing with the GAC registration commands, and have not moved passed the gateway error.  However, the report still fails, with the following :

  Unable to render paginated report
  Could not connect to the data source.

Since Power BI is working with the sources, and I can use SQLPLUS on the gateway server, I presume it is some other sort of config issue.  Has anyone seen this, or fixed it please ?

[watts_jim]

The format of the connection host does not make a difference.

[rachelgomez1234]

Perform the following checks:

If you are running the report synchronously through your Web browser, verify that the failure is not caused by a timeout on the HTTP server. Submit the same job asynchronously; if it finishes successfully, modify the HTTP server timeout in the application server configuration or consider executing your long running reports asynchronously (which is the suggested method). You can leverage the Reports Server notification feature to inform your users when their job has finished.

Verify that your overall response time of the server has not had any significant changes, by looking at the Reports Server statistics in reports servlet.

Verify that our database server is responding in a normal manner. Sometimes database load can have a significant impact on the performance, especially on long running reports.

Greeting,

Rachel Gomez

[watts_jim]

These are small queries, so timeout is not an issue.