Skip to main content

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!

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.

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

image

@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

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

Terms & ConditionsCookie settings