Forum Discussion
Gateway connectivity issue
Anonymous
No problem, glad to provide it :)
I finally resolved it publishing the report from within the production environment and for future developments and maintenance this datasource will be accesed through the Power BI Service data connector like we discussed.
Thanks for your help!
Anonymous
Thanks again for your response but I'm afraid I cannot mirror DEV to look like PROD :(
Nevertheless, before coming here for help I tried something like you said, but I couldn't publish the report with PROD's connection string (from DEV) due to connection and validation errors that prompted as soon as PBI Desktop tried to validate the existing schema.
Also, I couldn't find a way to modify the published report connection string inside the service.
Maybe I did something wrong but I couldn't achieve any of these. Could it be cause I'm employing a Direct Query connection?
Thanks!
l2aFa Thanks for the feedback. No, I think it sounds like the solution I suggested won't work because of the validation. Thanks for responding with your testing it out. I'm going to ask around on this one, just because I don't like the result :) I'll respond if I can scrounge up any more detail, but it looks like publish from the Prod environment has to be done, or somehow getting the Service connection to connect the same way so the datasources match look like the only options.
Anonymous
No problem, glad to provide it :)
I finally resolved it publishing the report from within the production environment and for future developments and maintenance this datasource will be accesed through the Power BI Service data connector like we discussed.
Thanks for your help!