Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.

Reply
PBISQL
New Member

Help needed with M query

I've used GraphQL API to establish a connection between Power BI and Monday.com. I can now access the main board, however, every task on the main board has got its own separate board (specified in 'Link' column - Exhibit A). Now, I'm trying to find a way to automatically import every of the aforementioned boarda by using the URLs in the 'Link' column.

I've been using this solution to solve my problem, however, the moment a try to use a custom function in order to modify my perfectly working M code (exhibit B) I get an error (Exhibit C, D, E). I'd really appreciate your help!

(Exhibit A)
Monday com.png

 

 

Exhibit B (if I manually specify board ID the query will work just fine)

PBISQL_0-1675155879866.png


Exhibits C, D, E (if I create a custom fuction (LGA) in order to feed board IDs through a parameter my function the query will stop working)

PBISQL_1-1675156170843.png


PBISQL_2-1675156404271.png

After enerting a board ID i get this error.

PBISQL_3-1675156473534.png

 

 

 

0 REPLIES 0

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.