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
Super Userkhansheh , For dataflow, it should not ask for on-premise gateway, It should only ask for credentials in the option below the gateway.
What is the error above SQL Server, if that is because of some unused connection, delete that from the file and republish
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.
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.
luohenResolver II
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
