Forum Discussion
Solved
parametrized connection gateway error
I created a parametrized connection, I'd like to use this report with parameter beacuse I set it to "DB2" when developing on desktop and then change the parameter to ODBC before uploading or directly...
So, in conclusion, this topic doesn't have a solution.
Thanks anyway.
Hi AGo,
>>I'd like to use this report with parameter beacuse I set it to "DB2" when developing on desktop and then change the parameter to ODBC before uploading or directly in the BI Service parameter management section.
It seems like power bi gateway cannot recognize your parameters, DB2 and odbc are different connectors.
When you get data from datasource, power query will generate and cache get data steps with specific connector in query editor.
I don't think you can direct change connection string and datasource type on power bi service.(It should be matched with report file)
Regards,
Xiaoxin Sheng
So, in conclusion, this topic doesn't have a solution.
Thanks anyway.