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.
Hi everybody,
I've got a single column table with a list of sources.
A list of mailbox addresses for an Exchange.Contents(Parameter) source to be clearer.
I need to add a column with the Parameter text for each table extracted and then automatically append each of them.
I need that the append query to be refreshed automatically if I add an address in the mailboxes list.
Is this possible with an mQuery?
So I can have a table with all the emails appended in row charachterized with the proper mailbox name (add column), and without querying and appending manually for each mailbox address.
Thank you in advance!
Solved! Go to Solution.
No need to append anything. Just add a column to your existing table where you call the function like this:
So you reference the column with the adresses as your parameter. That will return one table in each row. If you expand that newly created column, all your results will be returned within one consolidated table that also still has the column with the mailbox adress for you to distinguish between the different mailboxes.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Invoking @ImkeF... I would think that perhaps a custom function could do the trick for this.
No need to append anything. Just add a column to your existing table where you call the function like this:
So you reference the column with the adresses as your parameter. That will return one table in each row. If you expand that newly created column, all your results will be returned within one consolidated table that also still has the column with the mailbox adress for you to distinguish between the different mailboxes.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Thank you @ImkeF !! This works great!
I only hope that the time filter I'd like to activate on the time column will work, because it's a very large amount of data, and if it import all the rows and then filters it I thinks it's going to be out of memory and crash.
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |