Hi every one!
In a PowerBI reporting hosted in a Pipeline in the PBI Service, we're using data from onPrem SQL DBs via a onPrem gateway.
The problem:
In the last time our reports cannot refresh and we get a "DM_GWPipeline_Gateway_MashupDataAccessError" error.
The strange thing is, that this happens only mostly - means a few times a refresh is possible, but nearly everytime it fails.
- One behavior: we test the connections in the Gateway and they are validated or set to offline without a recognizable pattern, within minutes.
- Or: while having validated connections (showing "online") in the Gateway, at the same time a refresh of the data/semantic model is rejected from the service, claiming "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible."
We already checked the gateway - it has all needed rights and all needed ports are opened (confirmed by the gateways diagnostics)
But anyway, we made no changes to the gateway,. Further more we can exclude errors in the report itself, since this behavior is reproducible with old versions of the reporting too.
Does anyone has a clue how to fix this issue?
