DASHBOARD LIVE DATA FROM SQL SERVER

srkase — Wed, 07 Jul 2021 08:49:30 GMT

Hi,

In my laptop I have created one Dashboard report , with data from SQL server using direct query option. Have completed the dashboard and uploaded to app.powerbi.com to share with my organisation.

I also have created a gateway with sql server credentials and applied to the dataset.

The dashboard gets live data from our SQL server and is working fine.

Now the issue is,

Once I switch off the Laptop, the dashboard is not loaded and gives an error as

" The data source is inaccessible because the gateway *********** is unreachable".

Should my Laptop be in ON condition through out the day or is there any solution for this?

Thanks in advance.

Regards

SRK

Re: DASHBOARD LIVE DATA FROM SQL SERVER

Anonymous — Fri, 09 Jul 2021 05:59:40 GMT

Hi @srkase

The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services.

According to your statement, you configure your gateway and add sql server credentials correctly. You need to keep your on-premises data gateway online to make it work. I think your gateway is install in your Laptop. If you shut down your Laptop, the on-premises data gateway is offline and unreachable. We suggest you to install the gateway in the device where your data source is located.

So you need to keep the device which install the on-premises data gateway and has the data source(SQL Sever) online.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic DASHBOARD LIVE DATA FROM SQL SERVER in Developer

DASHBOARD LIVE DATA FROM SQL SERVER

Re: DASHBOARD LIVE DATA FROM SQL SERVER