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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Joerobert
Helper II
Helper II

Applying filters in Query Editor across multiple queries

Hello,

 

I am new to power bi and have come across aproblem that cannot resolve. I am working with a large oracle database and after pulling in multiple queries into my desktop, my project file size is + 500mb. I have applied filters in query editor to various columns however after loading the queries (and assigning the relationships), i am noticing that the queries are now filtering each other. How can I apply a filter to one query and have it applied to the other queries during load. This seems a little odd to me since I am not apply the relationships until after loading the data.

 

Thanks

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

I would think that would only be possible if you created your other queries as references to a single query. Otherwise, that would not occur.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

I would think that would only be possible if you created your other queries as references to a single query. Otherwise, that would not occur.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.