Comment on Utilize query from Marketing reports in data flows by Utilize query from Marketing reports in data flows | 365 Community
The article discusses how to utilize queries from marketing reports in data flows. The author encountered formatting issues when trying to replicate marketing insight data from a data lake to Customer Insight. They found that the marketing reports released by Microsoft for Power BI can serve as inspiration for querying the data. The author shares their experience of trying different approaches, including using the Azure Data Lake Gen2 adapter and the dataflow connector, before finally finding success by copying the data query from a Power BI marketing report and modifying it for use in a data flow. They provide the final M-script that worked for them.
Article 19m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time