schedule update is disabled

[GeekAlfPro]

Hi,

i'm not pretty familiar with the authorizations of power bi.

i created a report with power bi desktop directly connected to a SQL Database

it's an ip in my lan.

when i try to plan the update, it fails

with the message : 

	Scheduled update is disabled because at least one data source has no identifying information. To restart the update, go to the settings page for that data set and enter the credentials for all data sources. Then reactivate the scheduled update.

i am sure of the credentials

Do i have to install a gateway ?

thanks

[GilbertQ · Accepted solution]

Hi @GeekAlfPro 

I would suggest installing the Standard (Enterprise) gateway.

And yes they are seperate installs.

[GilbertQ]

Hi @GeekAlfPro 

Yes you will need to install and configure the Gateway to connect to your SQL Server in your LAN

Here are details on how to do this: Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Docs

[GeekAlfPro]

Hello @GilbertQ 

Thanks!

is there still a separation between personnal gateway and enterprise gateway as shown on screenshot ?

do I have to install both ?

thanks