cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kcantor Super Contributor
Super Contributor

Matrix and Table visual loses data on refresh

I have two smaller, uniquie data models that has worked for several months with no issues. They are in my personal workspace, not in an app and not in a group. They refresh as scheduled but when they refresh, they lose data instead of gaining it. For example, one shows all weeks of the year through current with the number of orders imported. When the model refreshes at 7:30 am, all weeks except for 2 drop off the report. It is not filtered and the database has no issues. It is a direct import table. If I open the data model on the desktop and refresh the data, it works perfectly and keeps all of the weeks. I can then republish and it will work again for several hours before going blank again.

I have removed the data model, reports, and dashboards and republished from scratch only to have the same thing happen the next day. As stated, this is occuring with two different models built on two different data sources.

We have had issues with data loading (like many of you) and have recently transferred the gateway to a different server but the 100+ other reports and the 50+ datamodels work perfectly.

Any ideas?



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




2 REPLIES 2
prihana Member
Member

Re: Matrix and Table visual loses data on refresh

Try using the import mode once and share the result

kcantor Super Contributor
Super Contributor

Re: Matrix and Table visual loses data on refresh

@prihana

I did the import method yesterday and today, the report lost data again.

I am at a loss on this one as it only seems to affect two data models that have no unique connections. My other models have the same data connections and do not suffer from this issue.

Both reports and models lost 90% of their data this morning as well.

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors