Power BI Dataset refresh option disabled

[amsrivas]

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

[aj1973]

Hi @amsrivas 

I tried the URL and the refresh is working fine using my personal Gateway installed in my computer.

Use ananymous as credential in the desktop and the service.

[amsrivas]

Hi @aj1973 ,

I am newbie to the Power BI and might be question did sound funny.

Why do we need to install Gateway, whay would we need that.

Thanks

Amit Srivastava

[aj1973 · Accepted solution]

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

[amitchandak]

@amsrivas , First of all, open the gateway and check for any error. If you need a gateway, make sure there is no error there.

[amsrivas]

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

[aj1973]

Use this link to know how to install it in your computer

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install