The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a situation where I have a new data file with the same columns as an existing file. The existing file has an associated query and visuals already displayed. Is there a way to update all of those visuals to the new file, given that the column headers are the same?
Trying to find a workaround to avoid clicking into each visual and updating the fields referenced in the charts and graphs from the old/stale query to the new one.
If I am not taking the right approach and there is a more backend method of achieving this that someone has thought of please let me know. Thanks!
Solved! Go to Solution.
You can go into the advanced editor of the query and update the source string with the new file location string. Then everything should just update accordingly.
Hello @ChrisR22 ,
yes as @CoreyP mentioned, you'll get to have the same table structure and the same fields in visual but the table in loading the new records fom the new source.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
You can go into the advanced editor of the query and update the source string with the new file location string. Then everything should just update accordingly.