Forum Discussion
Skilled SharerGateway Error - Cannot be added to gateway
I took my reports off the service, rebuilt the dataflow and uploaded them again. It seemed to have fixed the issue, still not sure what caused the failure but the classic on/off approach has saved the day again.
Thanks.
I took a different approach. Too troubleshoot, I turned off all the 'include in report refresh" in power query for the tables connected to a dataflows. Uploaded and to and check to see if refresh worked. It did. Then I turned them all back on, and everything worked.
Dataflows are still in beta, seems to be a bug. But at least now I can combine data from multiple excel online spreadsheets.
Is this new source on the same SQL Server but within a different database? If so, you'll need to configure another gateway connection for this database.
Skilled SharerHi Anonymous, appreciate the reply.
Both of the sources are within the same database and I have a Pro account.
- jcarville
Could it have anything to do with permissions and privacy levels? Both data sources have a privacy level of organisational and the gateway also has organisational as its privacy level.
Based on that, everything should be ok. There must be something else at play.
- jcarville
I took my reports off the service, rebuilt the dataflow and uploaded them again. It seemed to have fixed the issue, still not sure what caused the failure but the classic on/off approach has saved the day again.