Forum Discussion

New Member

8 years ago

Return raw data from Mixpanel to PowerBI

Hi all, I'm new to PowerBI, loving it so far. I connected Mixpanel with PowerBI and tried to export data from Mixpanel to PowerBI. However, the Invoked Function I got from the query against Mixpan...

Anonymous

Not applicable

8 years ago

duongnguyen,

Could you please use the Web connector in Power BI Desktop, enter the following example URL mentioned in this article and check if it renturns raw event data?

https://data.mixpanel.com/api/2.0/export/?from_date=2012-02-14&to_date=2012-02-14&where=properties%5B%22%24os%22%5D+%3D%3D+%22Linux%22&event=%5B%22Viewed+report%22%5D

Regards,
Lydia

duongnguyen

New Member

8 years ago

Hi Lydia,

Thanks for your help. I have tried multiple times. I tried today again and got 404 error.

My URL is https://data.mixpanel.com/api/2.0/segmentation/?event=Create%20Page&from_date=2017-08-26&to_date=2020-02-02&on=properties%5B%22properties%5Bcreate_page_type%5D%22%5D

Do you know any potential reason why this occurred?

Thanks!

Duong.

Anonymous
Not applicable
8 years ago
duongnguyen,

Do you get results when you directly enter the above URL in Browser? Please follow the instructions in the similar blog below to use M code to retrieve data from your data source. You would need to pass API key and API secret in the M code.

http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/

Regards,
Lydia

Forum Discussion

Return raw data from Mixpanel to PowerBI

Related content

Mixpanel API call returns different row counts on desktop and service

POWERBI Subscription

PowerBI Workspaces

Measure returning incorrect value

iframe powerbi