Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Can't refresh any datasets on BI online service

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

Status: Delivered

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

Comments
djordjije
New Member

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
Continued Contributor

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

Sandy
Impactful Individual

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
Impactful Individual
Status changed to: Delivered

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
New Member

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/