Removed source of main data table-->want to still use original table with other data sources.

[Anonymous]

Hi! I need help with my dashboard. I was originally calling in three data sources, each had their own table, but was doing all of the calculations and transformations within the table I chose (total), which the data source for has been deleted since we are no longer using that 3PL. Because of this issue, my dashboard has not refreshed since November. It fails to refresh because of this and I am wondering how I can get this working with the two sources left. I know I shouldn't have made the main table connected directly to one of the data sources (this was the first dashboard I ever made, so lots of lessons learned), but I have put a lot of work into it and want to avoid having to redo it. There is no hard-coding in the tables calling the old data source but I think just the nature of it originally being the table for that source is causing an error.

[selimovd]

Hey @Anonymous ,

I'm not sure if I understood the question (if there was any)?

You had 3 tables and one table doesn't exist anymore as source system. If you want to refresh the report, remove the non-existing table that is causing the error. Of course you also have to fix the visuals, otherwise they will also get errors.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic