Help Querying Monday.com on Powerbi

[YuriK]

hey! I'm trying to query monday.com but I can't seem to get it to work.
I got to
web > add the URL (api.monday.com/v2) > advanced > set header as Authorization and use my key > select anonymous, and it keeps saying that my credentials are incorrect even though I know for sure I got the right API key and URL

thanks!

[nicstt]

I'm late to this, but it will hopefully help others.

I have been using Tugger (https://tuggerapp.com/) for a while now. I joined 'em before they even had a Monday connector; what they do is pull (or Tug as they call it) you data into their data warehouse. (It's also nice to see that they are now ISO 27001 certified.) Although, I'm software dev, the subscription they charge is easily worth the development cost.

Once your data is in Tugger's warehouse, they provide secure OData credentials to import into the reporting option of your choice, such as: Power BI, Excel and Tableau.

Trying em out is a no-brainer, IMO, as they offer a free trial.

[AminR]

I have successfuly extracted data from Monday.com and it is working perfectly in Power BI Desktop however when it comes to Power BI Service and I want to add it to the Gateway, it recognise the URL but it takes several hours and do nothing

has anyone published a Power BI report with connection to Monday.com in Power BI Service?

[v-eachen-msft]

Hi @YuriK ,

You could go to https://community.monday.com/  for further api help. 

You could also use power query to set connection directly.