Power BI connector

[Joe (Joseph Muir)]

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!

[Helen]

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.

[Joe (Joseph Muir)]

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

[Helen]

@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: