Forum Discussion

knpbi's avatar
knpbi
Advocate I
9 years ago

On-premise data SQL Server and smartsheet

I created a report using data from on premise SQL database and publshed to power bi service. The data was imported not direct query. Report worked, but once I added data from Smartsheet(www.smartsheet.com) and published it, I am unable to use the on-premise gateway. Gateway connection is disabled.

 

Any ideas on what could be wrong? Or, is this a need that is not supported?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi knpbi,

    I am not familiar with smartsheet. Based on my research, smartsheet is an online service application which is used for collaboration and work management.

    Currently, when you combine on-premises SQL Server data source and online data source in a dataset, you are not able to use on-premises gateway to schedule refresh for the dataset, this is a known issue that has been submitted in the following link and the feature using on-premises gateway to work with online data sources is under review, please vote it. The current workaround  is to use the personal gateway to schedule refresh for your dataset.

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources

    Thanks,
    Lydia Zhang

    • knpbi's avatar
      knpbi
      Advocate I
      9 years ago

      Thanks for the pointer to the link.