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!
l2aFa Maybe I didn't explain myself. I know the connection from the DEV machine to PROD won't work based on your description. But if DEV mirrors PROD, you can develop against DEV in the PBIX file. When you are done. You can alter the connection string in the PBIX in DEV to use the PROD connection. This will break the report. Publish to the Power BI Service. I assume, the report begins to work because the connection to PROD is valid. (Is this not the case?)
If you are locked into DEV, this is an extra step, but my assumption is that it would work...
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!