Visual not displaying - How to reset and rebuild a table

[errepinna]

Hello.

I'm having an issue with Power BI. I got this table that just refuses to produce any visualization. I know for sure I'm not making mistakes because I've got many tables set up in the exact same way and they all work.

It's pretty simple: there are four columns. One has an ID related to an entity. One has another ID related to another entity. One is a date. One is a number (either 1 or 0). I kept it really simple. I'm pretty sure it doesn't work because of some glitches. I've been working on a PC with not much RAM, which caused many crashed and unbelievable lag. Now I'm working with 16GB and the situation got much better, however this table didn't fix itself. I'm thinking about rebuilding it from scratch, but I was wondering if there's another solution pro futuro.

Is there like a way to rebuild a table from scartch automatically?

[Anonymous · Accepted solution]

Hi @errepinna ,

I think your data has been broken during last operations.

Unfortunate, current power bi not contains any feature to fix broken files.

In my opinion, I'd like to suggest you to open the recovered folder to filter out the recently backup files.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@errepinna , Can you share the error which the visual is showing. I doubt you are trying to get two unsummarized columns from two tables on many side. that is causing it 

[errepinna]

The visual would just be empty (background was shown and also axis titles). I've already deleted the original table and made a new one, which fixed the issue completely.

EDIT: I should have also specified that the visual originally worked as intended. It broke after I closed and opened the file again.