Forum Discussion
On premesis dataset and datflow
Hi khansheh ,
The dataflow is not required for the gateway, you can get the detail in this official documentation.
And the following one is the thread which has the same problem as yours, please check its solution. Hope it can also help you solve the problem.
Gateway 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.
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.
Best Regards
Hey amitchandak
There are only 2 data connection one dataflow and one on premisis MS SQL server connection. The pbi doesnt show an error if i remove the dataflow and keep MS SQL server or remove MS SQL server and keep dataflow.
Resolver IIHi khansheh ,
The dataflow is not required for the gateway, you can get the detail in this official documentation.
And the following one is the thread which has the same problem as yours, please check its solution. Hope it can also help you solve the problem.
Gateway 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.
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.
Best Regards