cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AGo Member
Member

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 in the BI Service parameter management section.

The problem is that the gateway connection pretends both connection to be active. The DB2 connection won't ever be active for the gateway, if only it was possible to make the dataset start refreshing it will succeed because all the data it needs are also on ODBC. Any solution or workaround possible?

 

 

Cattura.JPGgateway error

 

Similar to a @Seth_C_Bauer yet resolved issue, but also the database type is different, not only the servername.

 

Thanks in advance!

 

1 ACCEPTED SOLUTION

Accepted Solutions
AGo Member
Member

Re: parametrized connection gateway error

So, in conclusion, this topic doesn't have a solution.

 

Thanks anyway.

2 REPLIES 2
Community Support Team
Community Support Team

Re: parametrized connection gateway error

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
AGo Member
Member

Re: parametrized connection gateway error

So, in conclusion, this topic doesn't have a solution.

 

Thanks anyway.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 32 members 1,063 guests
Please welcome our newest community members: