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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
fpintos
Employee
Employee

Kusto queries throttled

I'm trying to build a PowerBI report that uses a Kusto query with Import and in the process of setting up the queries I get errors like this:
"Web.Contents failed to get contents from 'https://kusto.aria.microsoft.com/v1/rest/query?db=56468f6991c348029c6bba403b444607&csl=.show%20versi...' (503): Service Unavailable"

At this point, trying to run a query in the web fails with "...Throttled on ... _NumQueriesEmitted: Quota is 500."

Is the PowerBI connector overloading the server, and if so, how am I supposed to create a query with it?

Thanks!

1 REPLY 1
v-kelly-msft
Community Support
Community Support

Hi , 

Try to use another tool such as postman to check the query and confidential, if it's OK, try to use the following M code in query editor:

let Source = Web.Contents("http:..>",[RelativePath = "}&RowLimit=0&RootFolder=%2f<SitePath>%2f<SiteName>%2fLists%2f<ListName>Selection={<ItemID>}-{<ItemID>} in Source

 

 

Fill the web URL and RelativePath in above M code.

 

 
Best Regards,
Kelly

 

 

 

 

@fpintos

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.