Forum Discussion

Adam1V's avatar
Adam1V
Frequent Visitor
6 years ago
Solved

Sharing Question

Hi, A couple of quick questions from a PBI newbie.   I have a PBI Free account, soon to be a Pro account. While im the only one with a Pro account, the reaminder of the business has Office 365, wi...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Adam1V 

    Because your other data source is on-premises, the gateway is inevitable to be configured.

    You need to do some more steps for your datasource of sql server:

    1.Download a gateway(recommend first type On-premises data gateway ) and Make sure the gateway works well

    What is an on-premises data gateway? 

    2.Manage you data source (sql server)

    Please refer ro this article 

    manage datasource  / manage your datasource (sql server) 

     

    3.Merge or append on-premises (sql server) and cloud data sources (onedrive/sharepoint .. ) in the same query

    Please refer to this article:

    Merge or append on-premises and cloud data sources 

     

    4.If you have configured it correctly ， you will see something similar to the figure below.

    (Don‘t forget to map your sql server to "new data source" your create)

     

    5.You will  find the option of "scheduled refresh"  available （I'm not sure here）

    Please refer to this article  to configure your scheduled refresh

    scheduled-refresh 

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.