Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 and I have set up Gateway for that SQL server and currently updating those reports using that gateway.
Thanks in advance.
Regards
Abduvali
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |