Publishing from Desktop

[srish]

Hi there,

I will be primarily working from the Desktop application but want to be able to publicly post dashboards for others to view. Is there a way to refresh the connection to a local file from Desktop on Service? Or do I need to overwrite the file by publishing each time from Desktop onto Service. What is the best practice here? I understand how to publish to web once I have the file within Service.

Thanks!

[v-qiuyu-msft · Accepted solution]

Hi @srish,

According to your description, it seems that you create a report which get data from a local file, then you publish the report to service, right?

In your scenario, you can install the on-premise data gateway on the server which has local file stored, then create a file data source which use the same connection information as defined in desktop. After you publish the report to service, you can configure the dataset to use that data gateway, then schedule refresh or refresh manually via Refresh Now. So you needn't to refresh in desktop then republish report to service.

Reference:
Manage your data source - SQL Server

Configuring scheduled refresh

Best Regards,
Qiuyun Yu