Auto refresh in Microsoft Bi from monday.com

I have copied this from a post and there was no solution as the user figured it out , can anyone help in what the solution was :slight_smile:

Has anyone get your dashboard autorefreshed in PowerBI using a gateway? I can refresh it on my desktop, but when I’m using online services it doesn’t work.
I’m using the https://api.monday.com/v2 link as a conector, I’ve tried introducing the api token together, but it didn’t work either.

Hi,

I ran into this problem again today, and was not helped by previous fixes either (Skipping the test for example). What helped for me was going to Options and settings > Data source settings > Monday API > Edit Permissions > Change to type Web Api > Fill your credentials.

Fixed.

Let me know if that helped. For reference, I was using the Power Query M code by Guichaguri: Power BI Monday.com Query - Power Query M · GitHub

Hi Thanks for coming back , really appreciate.

I tried this , pasted in my API certification of Monday in the field but then it all said failed on each monday board connected.

Tried V2 which is what monday says but also tried the other options.

Do you have to fill anything in the other tab options?

Best

Lee

HI, Can you help me to conect monday api to power bi (including items and subitems from a table)