HELP: PowerBI table API export to Marketo

[zstatkus]

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.

[v-juanli-msft]

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.