Forum Discussion

Abduvali's avatar
Abduvali
Skilled Sharer
9 years ago
Solved

Single Gateway Issue

Hi Community,   I'm having an issue with updating my datasets in Power BI web. Data in my new reports pulled from Azure database but I also have reports build on data coming from normal SQL server ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Abduvali,

    Do you install Power BI on-premises gateway or Power BI personal gateway? If you install on-premises gateway, add Azure SQL Server data source under the registered gateway, you will be able to schedule refresh for you dataset that contains on-premises SQL Server data source and Azure SQL data source. If you install personal gateway, just enter credential for Azure SQL Server, and you should be able to schedule refresh for your dataset.

    Besides, you don’t have to install multiple gateways to update datasets. Just add data sources of other datasets under your currently registered gateway, you will be able to refresh other datasets.


    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Abduvali,

Do you install Power BI on-premises gateway or Power BI personal gateway? If you install on-premises gateway, add Azure SQL Server data source under the registered gateway, you will be able to schedule refresh for you dataset that contains on-premises SQL Server data source and Azure SQL data source. If you install personal gateway, just enter credential for Azure SQL Server, and you should be able to schedule refresh for your dataset.

Besides, you don’t have to install multiple gateways to update datasets. Just add data sources of other datasets under your currently registered gateway, you will be able to refresh other datasets.


Thanks,
Lydia Zhang

  • Abduvali's avatar
    Abduvali
    Skilled Sharer
    9 years ago

    Anonymous

     

    Hi Lydia,

     

    Thanks for the advice.

     

     

    Regards

    Abduvali