Can't refresh any datasets on BI online service

[tommy-olsen]

Yesterday, all my datasets were refreshing just fine but today nothing happens.

- The automatic refresh hasn't done anything.

- When I press "Refresh now", I get a "popup" saying "preparing refresh" for a split second and then nothing happens.

The only way to update the data is to refresh the Desktop version and then upload it. 

I have datasets connection to an on-premises database and one connecting to a sharepoint site.

- The on-premises connection usually works perfect, but now nothing happens.

- The sharepoint connection usually brings up an error,  if I try to refresh, but now nothing happens (I just tried it this time as a test, as it usually doesn't work automatically).

Can you please help troublefinding - It seems like an issue on you online portal somehow.

Thanks in advance.

// Tommy

[djordjije]

I have the same issue as the original post. Using the Power BI service to connect to a CSV file inside One Drive - Business. This should refresh automatically every hour. It does not. Can't even manually refresh it. The little refresh status on the top right corner appears and disappears in a split second. 

[Shelley]

I am now having this issue! So frustrating. No solution here after seven pages of comments??? @msft-cap 

[Sandy]

Refreshes can fail for a whole bunch of reasons and given how critical refresh is to Power BI, we have created this article to help you trouble shoot: 

https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios

[Sandy]

Refreshes can fail for a whole bunch of reasons and given how critical refresh is to Power BI, we have created this article to help you trouble shoot: 

https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios

[erming]

Get Power BI online service IP address!
You need open/whitelist for IP traffic from Power BI server to your data source.
Test my Power Query Editor code. Upload it to your workspace and update the data. Now you get the PBI server's ip address..

let
    Source = Table.FromColumns({Lines.FromBinary(Web.Contents("https://ifconfig.co/ip"))}),
    #"IP-address" = Table.RenameColumns(Source,{{"Column1", "IP address"}})
in
    #"IP-address"

Best Regards,
/Raymond Erming/