Power Bi_Service Now

[Anonymous]

Hello Expert

After Integration with Service now can export all the data from service now to excel,csv or txt  or some other format of  file or something. can we schedule export excel sheet to email? Is there any best approach to integrate with service now like API or adapter

[antonstorozhuk]

Hello,

The best way to connect Servicenow and Power BI would be to install our app on your Servicenow instance and schedule automated refreshes in Power BI.

Power BI Connector for ServiceNow app:

• https://store.servicenow.com/sn_appstore_store.do#!/store/application/87a42573879e0110fb5033773cbb35...
• https://www.alphaservesp.com/products/servicenow/power-bi/

We have a handy User and Admin Guides for your convenience, but feel free to reach out support team at support@alpha-serve.com if you need any assistance.

Cheers,

Anton

[Mariusz]

Hi @Anonymous 

There are many ways you can access the data in Power Bi Service ( please see the bullet points below ), however, I don't think there is a way of scheduling data exports as  Power Bi was designed for use in a cloud. 

If you need to prompt users to check their reports, you can set up dashboards and alerts on certain events that will send emails

• You can download the data for specific visuals in CSV or xlsx format.
• Access your data model ( dataset ) from Excel, go to Service > Datasets > More Options > Analyze in Exel.
• You can analyze your model in SSMS, or DAX Studio 
  https://www.biinsight.com/connect-to-power-bi-desktop-model-from-excel-and-ssms/

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

Hello Expert,

I got your point and its good

Access your data model ( dataset ) from Excel, go to Service > Datasets > More Options > Analyze in Exel. to through Email

would it it be auto refresh that means there are 1500 more records added before 5 or 10 mins . Can we do this with CSV files as it takes more records than ever

Regards

Shree

[Mariusz]

Hi @Anonymous 

It depends on your dataset.

• pro users can set up to 8 schedules a day every 30 min.
• the premium can set up to 48 schedules a day every 30 min.
• the direct query is live.

the only way you can use it in excel is through pivot tables.

power bi was not intended for data exports.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

thanks for response

 API Integration with service now. The below mentioned link says it hits to the source every 3 seconds. 

https://community.powerbi.com/t5/Desktop/Fetching-data-from-ServiceNow-in-power-query/td-p/438558

After integrating ..Can as refersh  as document it as and store it somewhere

Regards

Shree

[Anonymous]

also how srevice now will connect in excel

[Anonymous]

suggesiion please