Skip to main content

Power BI connector

  • March 11, 2021
  • 4 replies
  • 2536 views
J
  • Joe
  • New Participant

Does anyone know of a sure way to get data into Power BI?

I’ve tried this Loading GraphQL data (monday.com API v2) into PowerBI · GitHub

However it’s not working returning an error “We found extra characters at the end of JSON input.”
I have yet to identify why its returning this error as its a copy paste of what other use and say works.

Any help or insight would be greatly appreciated.

Thank you!

    This topic has been closed for replies.

    4 replies

    H
    Forum|alt.badge.img
    • Helen
    • monday.com Team Member
    • March 11, 2021

    Hi @Joe, welcome to the community!

    Do you mind providing a screenshot of your setup? This way, I can see what you’ve filled in. From the error returned, it seems like this is just a simple formatting issue and should be easy to fix.

    If it contains sensitive information, feel free to DM me.

    J
    • Joe
    • Author
    • New Participant
    • March 11, 2021

    Thanks @Helen, I sure hope so! I’ve removed the API key and board ID.

    image

    H
    Forum|alt.badge.img
    • Helen
    • monday.com Team Member
    • March 12, 2021

    @Joe thanks so much! This is definitely helpful.

    I noticed two things when looking over your code:

    1. What is the “Enquiry Type” in your column_values list of Ids? Could this be a typo?
    2. Also, unless you did not want a return of every single column value on your board, I believe you don’t even need to specify the exact column values. As such, a query like the following would work as well:

    image

    A
    • Anonymous
    • March 19, 2021

    This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

    Terms & ConditionsCookie settingsAccessibility statement