Hallo and thank you for reading this. Power Bi file, which is callinig monday api, in our company is not working anymore due authorisation issue. It used to work 3 Months ago. Now the error “Ein Web-API-Schlüssel kann nur angegeben werden, wenn ein Web-API-Schlüsselname angegeben wurde.”
Here is the connecting M Query:
Source = Web.Contents(“https://api.monday.com/v2”,
[Headers=[Authorization=“Bearer eyJhbGc…”,
#“Content-Type”=“application/json”
]])
I checked the token in Insomnia, it works fine. I think , the issue is on power bi side.
I’m late to this, but it will hopefully help others.
Although we can do it ourselves, sometimes, the most cost-effective solution is finding a third party to do it for us.
Where am I going with this? Well, I have been using Tugger 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,
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.
