PowerBi service refresh failure

Taniya · ‎02-19-2020

When i publish from desktop i get a publish to powerbi success message but in service the data in report is not getting refreshed.
Also the schedule refresh on report is failing everytime.
This problem is arising from last 5 days before that it was working fine(FYI - before 5 days more data was loaded into database from where we fetch the data for reports and since then this problem is occuring)

vanessafvg · ‎02-20-2020

@Taniya what is the error you are getting?

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Taniya · ‎02-20-2020

vanessafvg · ‎02-20-2020

also read through this post and see if it helps, particuarly the last recommendation

https://community.powerbi.com/t5/Service/Memory-error-Memory-Allocation-failure/td-p/229420

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

vanessafvg · ‎02-20-2020

hi as the error specifies, its having an issue with memory of the load. I think you might need to do some optimisation. A good place to start is removing unecessary columns.

how much data was added?

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!