cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BrettHarris
Regular Visitor

Query Advanced Editor

My data source in Microsoft Dynamics accounting software.

In one of the tables there is a text column "Description"

I was looking at the advanced query editor for a solution to my issue

What I am attempting to do is, when the data is refreshed, exclude from the data refresh rows with particular text entries.

Is this possible in the advanced editor and what would the code look like.

 

 

 

 

1 ACCEPTED SOLUTION
HotChilli
Super User II
Super User II

In Power Query, look for the dropdown in the column header for 'Description'.  You can investigate the Text Filters section. See if one of the options is what you're after.

You can then examine and edit the Advanced Code that is created as a result (if required)

It's easier to use the dropdown when starting out.

View solution in original post

2 REPLIES 2
HotChilli
Super User II
Super User II

In Power Query, look for the dropdown in the column header for 'Description'.  You can investigate the Text Filters section. See if one of the options is what you're after.

You can then examine and edit the Advanced Code that is created as a result (if required)

It's easier to use the dropdown when starting out.

View solution in original post

Genius thanks.  Worked like a charm.  Will have to remember this approach.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.