Forum Discussion
Gateway Refresh Redshift - DM_GWPipeline_Gateway_MashupDataAccessError
After some trial and error, we ended up creating a separate ODBC connection to the Aurora instance that held some tables we accessed through an external schema within our Redshift instance. I did testing with only the Redshift tables with no issues refreshing through the gateway. Once I introduced even one table from the external Aurora schema, the refreshes started to fail. Unsure of what the actual root cause is, but the workaround is solid.
I can't explain why this was working but now isn't but I have just revolved an issue generating the same underlying error code as the one you are seeing. In my case a query was merging on-premise SQL DB and Sharepoint online. Raised a ticket with Microsoft support and the only resolution tha tworked was to copy the SQL data through the gateway using a PBI Dataflow and then consume the Dataflow from the Power BI report.
After some trial and error, we ended up creating a separate ODBC connection to the Aurora instance that held some tables we accessed through an external schema within our Redshift instance. I did testing with only the Redshift tables with no issues refreshing through the gateway. Once I introduced even one table from the external Aurora schema, the refreshes started to fail. Unsure of what the actual root cause is, but the workaround is solid.