Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
khickey
New Member

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

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.

khickey_0-1708447962156.png

 

1 REPLY 1
selimovd
Super User
Super User

Hey @khickey ,

 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.