Forum Discussion
Question about PowerQuery in Published Report
Hi hakimipous ,
Documents for your reference.
What is an on-premises data gateway-
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem.
Install an on-premises data gateway-
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install
Manage an on-premises data gateway-
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-manage
Refresh data from an on-premises SQL Server database-
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi hakimipous ,
You can also Schedule the refresh in Power BI Service to get the latest data from the source - https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
Best Regards,
- Pavan M.
Hi Anonymous , thanks for replying
But you can't add a Microsoft SQL server as Dataset source, right?
What Anonymous meant, was that after publishing the report from Desktop to the Service, you can set up a scheduled refresh as per the link provided. You would need:
- a gateway installed for that,
- and add the datasource as an entry to that gateway,
- and add your user to the gateway entry so you can use it
- in the dataset settings for scheduled refresh, make sure the gateway connection is correctly filled and applied
