How To Create A Power BI Report

How To Create A Power BI Report

Guides, Support Resources

 Power BI can be used to report on data extracted from Market Dojo. Currently questionnaire answers and events are supported.

You can use our API to access data stored in Market Dojo and use it to build reports. The examples below are specific to Power BI, but can be used with any reporting solution which accepts JSON format data. If you need help, Market Dojo’s Customer Success team can help you get started with our reporting solutions.

Steps

  1. Login to Market Dojo
  2. Goto your profile page, make a note of your E-mail and Market Dojo API Key
  3. Go to https://secure.marketdojo.com/api/v1/documentation  
  4. Search for ‘reports’ to find the reports section.
  5. Choose which report you wish to use (either questionnaire or events).
  6. If you are using the questionnaire report, you will need to find the questionnaire ID. This can be found by visiting the questionnaire in Market Dojo and examining the URL. The id will the number shown in place of xxx in the following url:
  7. [OPTIONAL] the documentation page can be used to try the api. Note that if you try the api on this page, you will not require the email and api key as you are already logged in.
  8. Make a note of the url for the report you wish to create. Either:
    https://secure.marketdojo.com/api/v1/reports/events
    Or
    https://secure.marketdojo.com/api/v1/reports/questionnaires/XXX (replace XXX with your questionnaire ID)
  9. With the details noted in points 2 and 8, you can now build your report
  10. Switch to Power BI
  11. Create a new report, Click ‘Get Data’ Choose ‘Web’ as the source.
  12. Choose the ‘Advanced’ option, enter the url noted in point 8 above, then add the email and API key as extra parts (note the ?email=  and &api_key= text) as shown in the screenshot below.
    power bi APi
November 25, 2020

no comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Us

Kontakt

Consultation Call
Vorname*
Nachname*
Firmañía*
Telefonnummer*
Email*
Ihre Wünsche
Lead Gen
Lead Source
Lead Source Detail

Contacto

Consultation Call
Nombre*
Apellido*
Compañía*
Teléfono*
Email*
Me interesa
Lead Gen
Lead Source
Lead Source Detail

Contactez-Nous

Consultation Call
Prénom*
Nom*
Société*
Téléphone*
Email*
Interessé par
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in
Lead Gen
Lead Source
Lead Source Detail

GET IN TOUCH

Test