Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
Genius thanks. Worked like a charm. Will have to remember this approach.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |