Forum Discussion
Solved
connect to Informix from report builder failed
Hi, I am trying to connect to an Informix database using Report Builder, but I’m encountering an issue. Here’s what I have done so far: Installed the Informix ODBC driver (both 32-bit and 64-bit)....
Hi, rodg
Try to paste the query into Text to run, ODBC connector only supports? To occupy a placeholder for a parameter in Power BI Report Builder:
The order of the parameter pages will determine the ? location.
In stored procedures, we usually can't define one? as a query variable, so you're getting an error. Try writing a query inside the Report builder.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jianpeng Li
I have a working version.
Thanks !
Ronny