Forum Discussion
Power BI Dataset refresh option disabled
Hi FOlks!!
I have created report for which source is web URL - Azure status
Once i have published the report to POwer BI Services, and refreshed the dataset manually it throws below error
Also, Data Source Credentials and Schedule Refresh are disabled.
Please suggest Why Data Source Credentials and Schedule Refresh are disabled and how to refresh the dataset and schedule the refesh.
Thanks
Amit
No problem,
To make it simple to understand : in Power Bi desktop you connect to the URL via Web connector "API" that comes with Power Bi package. Once you publish the report to the service, the service itself will need a way to connect and refresh the datat. The Gateway is here for that purpose : connect and refresh the report in the service.
Take a look here it might help you understand better
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem
6 Replies
- amitchandakSuper User
amsrivas , First of all, open the gateway and check for any error. If you need a gateway, make sure there is no error there.
- amsrivasHelper IV
Hi amitchandak
Why Gateway is required for it, its simply data pulling from Web URL.
And it it really required, how to install it.
Thanks
Amit
- aj1973Community Champion
Use this link to know how to install it in your computer
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install
- aj1973Community Champion
No problem,
To make it simple to understand : in Power Bi desktop you connect to the URL via Web connector "API" that comes with Power Bi package. Once you publish the report to the service, the service itself will need a way to connect and refresh the datat. The Gateway is here for that purpose : connect and refresh the report in the service.
Take a look here it might help you understand better
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem