Forum Discussion

zstatkus's avatar
zstatkus
Frequent Visitor
7 years ago

HELP: PowerBI table API export to Marketo

Hello,

 

I have a table built in PowerBI from two different datasets (user data and sales data connected together with email address) that I need to export into Marketo, I am building an automated email program that triggers emails upon a user hitting certain milestones. The data is updated daily into PowerBI and want to attach the fields/columns into Marketo as custom fields. What is the best way to get this data imported into Marketo from PowerBI? How can I automate this data gathering process? I have read that a Rest API would complete this but need clarification and assistance.  Any and all help is appreciated!

 

Thank you in advance.

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi zstatkus 

    It seems you need connect to Power BI data with Marketo.

    If so, please ask Marketo support team for a clear answer.

    As searched, i can't find any document about this.

     

    For any workaround, i provide some ideas, maybe it is useful for you.

    data in Power BI can be exported to excel, csv or SQL Server database, then you import data from these files to Marketo.

    Reference:

    export the data model from Power BI Desktop or Power BI Service to CSV or SQL Server

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.