Forum Discussion
Power Bi_Service Now
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/
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
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
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.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