Forum Discussion

YuriK's avatar
YuriK
Regular Visitor
6 years ago

Help Querying Monday.com on Powerbi

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!

Need Help

3 Replies

  • AminR's avatar
    AminR
    New Member
    4 years ago

    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?

     

     

     

     

  • nicstt's avatar
    nicstt
    Icon for Helper I rankHelper I
    6 months ago

    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.