Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Best practices when using Power BI as reporting tool

Walt Janssens
Tera Contributor

‎06-04-2024 06:24 AM

Hi all,

 

Does anybody know the best practices when using Power BI as reporting tool. We have some Power BI reports that query several tables from ServiceNow using REST API. When refreshing the report, all of ServiceNow's semaphores are being used. This often results in several 429 rejections for other interfaces, which will thus be blocked during the refresh.

What are the best practices in this? Are there other ways to load the data into Power BI?

Thanks in advance for the help! 

0 Helpfuls
  • 749 Views
1 REPLY 1

wobloz
Tera Contributor

‎06-27-2024 05:04 AM

Hi Walt, 

 

The best practice is NOT to connect Power BI directly to a production system - ServiceNow. The industry standard (design pattern) is to have a reporting database with up-to-date data. You can use SnowMirror or similar tools to build such a read replica.

 

Kind Regards,

Pavel

0 Helpfuls