Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have built a report using the Paginated report builder connecting to oracle that runs an SP. It works on my local machine. I have queries pulling values for parameters that get passed to the oracle sp. Everything works locally. When I deployed to PowerBI.com the parameters are populated so I know the report can read from the oracle database. When I click view report and run the SP I get this error:
Seems like it should work. You might try the Get Help option from the service?
I've looked at the documentation and get help. The log files on the data gateway are not providing much information either. Is there a way to see what is being passed from the report to the oracle database via the gateway....the actual string sent.
Hi @derekwilson74 ,
Try to turn on "Additional logging" option and export gateway logs after reproducing the issue.
Reference: Troubleshoot the on-premises data gateway | Microsoft Docs
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |