Change gateway from personal to enterpise

[Cubozoa]

While publishing a report, I am gettin the below error,

Publishing succeeeded,but the published report can't connect to the data source because we were unbale to find  gateway.Please install and configure an enterpise gateway .

I have already installed On-premises gateway .

[v-jiascu-msft]

Hi @Cubozoa,

Did you solve your problem? Could you please mark the proper answer if it's convenient for you? That will be a help to the others.

Best Regards!
Dale

[v-jiascu-msft]

Hi @Cubozoa,

Did you add a data source for this connection? 

"For data sources other than Azure SQL Database or Azure SQL Data Warehouse that use DirectQuery, and Enterprise Gateway must be installed and the data source must be registered to establish a data connection."

Best Regards!

Dale

[Greg_Deckler]

What is the data source?

[Cubozoa]

It is SQL Server

[Greg_Deckler]

Are you using Direct Query?

[Cubozoa]

Thats right !!

[Greg_Deckler]

Ah, OK, that explains why it is asking for an Enterprise Gateway then. I believe that this question has come up in other threads but not sure if there is a clear answer on using Personal Gateway and Enterprise Gateway at the same time. Let me do some research but most of the threads I have seen on this did not have a clear resolution.