Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Error in visuals because I deleted a table - retrievable?

Okay so I am a final semester student. For my internship I am creating a report, but I deleted some of my data tables forgetting that some of the data was referenced as values in text parts of my re...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thank you. 'Fix this' was the first thing I tried but unfortunately that is doing nothing. It doesn't seem to know how to fix it. Did try it on another visual (table) that was broken and it fixed that, but now this. If I go into 'See Details' I get no details.This looks like it should give me a list of fields that need fixing, but it's blank.

     

     

    This is kind of what the visual is about, although this is just a practice one to get used to Power BI. Obviously there's a lot more text in the real report, and a lot more variables. The parts underlined are the variables (or 'values') I referenced or calculated from the data. 

     

     

    This is where I set up the values for the above data. But I can't get into values for any of the broken text box visuals. If I could get into here I could change the values to only refer to current data tables. But I can't seem to get into the values table without clicking on the visual itself, but with the visual broken, all available options are greyed out.

     

    The above is just a file I began practicing on. I do have backups, but I think the problem happened several backups ago, and I worked on other things while I tried to figure out online how to fix it. Perhaps I could recreate the later visuals by copying the DAX and PowerQuery, as I tried to do for this problem by copying the PowerQuery and DAX for deleted visuals.  I'd just prefer not to waste a whole lot of time on that if there's an easier way. My internship is finished soon, around mid-July if my extension is granted, so time is a big factor here.