Utilize query from Marketing reports in data flows
The author shares their experience of replicating marketing insight data from a data lake to Customer Insight. They faced issues with formatting and file endings, but found that Microsoft's Marketing reports for Power BI could be used as inspiration for querying the data. The author tried copying the entire data query part from the report, but it didn't work. They then removed all unnecessary components and moved it into one single M-script with a hardcoded reference to EmailClicked, which worked. The author provides the M-script and highlights the datalake name, container, and table.
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