Skip to main content
Gayathiry1
Level 3
May 4, 2026 1:32 PM UTC
Solved

Marketo - Power BI analytics - data pull

Hi All,

Quick question - can we get the report as attached as the end result from the data pull in Marketo power BI analytics? 

 



Please share your thoughts!

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
BlaneMcMichen-1
BlaneMcMichen-1Accepted solution
Adobe Employee
May 5, 2026 2:42 PM UTC

Hi,

Regarding your two questions:

  1. Adding custom fields requires Admin permission and is described in the documentation here. (It is still labeled RCE in Admin.)
  2. I am not aware of any documentation related to your use case. As I said before, you are attempting to create a report that is a combination of two different types of reports.  It may be possible but you may need the assistance of a Microsoft BI Analytics expert to do it.
View in thread

4 replies

BlaneMcMichen-1
Adobe Employee
BlaneMcMichen-1Adobe Employee
Adobe Employee
May 4, 2026 3:00 PM UTC

Hi,

I don’t think you can get it very easily because you are mixing 1-to-1 profile data with 1-to-many activity data. This creates a nesting relationship that wants to evaluate the profile data as a first/last relationship.  (You will also need to add some of your data as custom fields to be imported because not all fields are pushed to the data lake.) As a result you get something like this image.

NOTE: You cannot get realtime reporting because data is pushed every night.

 

Translate
    Gayathiry1Author
    Level 3
    May 4, 2026 3:52 PM UTC

    Thanks ​@BlaneMcMichen-1 for your response. This is really helpful

    Few questions:

    - Can we get person details in the data pull (like first name, last name,...)
    - How to fetch the custom fields to the list in Power BI analytics, do we need any kind of access? Please confirm.

    - can you please provide any documentation for the work instructions to create 1-to1 profile data / 1-to-many profile data?

    Thanks in Advance

    Translate
    BlaneMcMichen-1
    Adobe Employee
    BlaneMcMichen-1Adobe EmployeeAccepted solution
    Adobe Employee
    May 5, 2026 2:42 PM UTC

    Hi,

    Regarding your two questions:

    1. Adding custom fields requires Admin permission and is described in the documentation here. (It is still labeled RCE in Admin.)
    2. I am not aware of any documentation related to your use case. As I said before, you are attempting to create a report that is a combination of two different types of reports.  It may be possible but you may need the assistance of a Microsoft BI Analytics expert to do it.
    Translate
    Gayathiry1Author
    Level 3
    May 12, 2026 9:48 AM UTC

    Thanks ​@BlaneMcMichen-1 

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...