Forum Discussion

giusizap's avatar
giusizap
New Member
10 years ago

Refresh Data Fails - Timed out

Hello everyone, I am unable to refresh my powerbi data online. My dataset get data from two data sources: Azure SQL Database and Azure Table Storage. The error is: "The update operation failed be...
Need Help
jbocachica's avatar
jbocachica
Resolver II
9 years ago

Well I just follow the message, they said ("Break it up") and I just did that to solve my problem.

 

  1. I create my connection to Table Storage (Wich doesn't allow to configure the timeout)
  2. Just duplicate my dataset and modify my "M" code to read the table and then just merge the tables.
  3. But keep in mind, the merge could not be done from the query editor page, must be from the design page.

 

After that, my Power BI is using about 120 MB per Second agains the 23 MB per second that was using before and the update is done in the time that must be done.