Forum Discussion

srish's avatar
srish
Frequent Visitor
9 years ago
Solved

Publishing from Desktop

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 fro...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

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