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 September 15. Request your voucher.
I have a large table which has Complaints ID and Zip Code. Zip code has recurring values because multiple complaints are received from the same zip code. I ran a Query Editor to obtain distinct values of zip codes and the total # of complaints from each. But when I close and apply, I think this new query goes back to the original table and messes up all the charts I have already built. I need to load this query to a 'new' table so I can perform other tasks with it. How can I do this?
Thanks,
Solved! Go to Solution.
Hi dhankash,
All the operation you have done in query editor will affect your report. Because data model(metadata) level will affect report level. So a simple solution to solve this problem is to duplicate a same "new" table in query editor and do operations on the duplicated table, then create visual based off the "new" table.
Regards,
Jimmy Tao
Hi dhankash,
All the operation you have done in query editor will affect your report. Because data model(metadata) level will affect report level. So a simple solution to solve this problem is to duplicate a same "new" table in query editor and do operations on the duplicated table, then create visual based off the "new" table.
Regards,
Jimmy Tao
Thank you. This really worked. However, I wish MS would provide an option to load new Queries to a new 'location' i.e. a new table if that is what the user wants to do. dk
User | Count |
---|---|
57 | |
54 | |
53 | |
47 | |
30 |
User | Count |
---|---|
175 | |
88 | |
69 | |
48 | |
47 |