Connectivity between Control-M and Power BI

+1 vote
Hi All,
Does any one have any idea about connectivity between Control-M and Power BI ?
I want to achive event based scheduling for Power BI Reports(Paginated Reports).

We are trying to implement even based scheduling in our project. Currenly , In existing architechture they are using control M for scheduling the crystal reports. Is there any other way ? Can we integrate Control M and Powerbi reports using some API ?
Aug 28 in Power BI by Edureka
• 160 points
88 views

1 answer to this question.

0 votes

There are few new APIs that will allow you to programmatically trigger data refreshes and retrieve refresh history for any dataset that you own. With these versatile new tools, you’ll be able to easily automate and scale out Power BI data refresh management – no more clicking through dataset settings or flipping through refresh histories. In addition, these APIs open the door to integrating data refresh into your existing ETL or deployment processes. 

Getting Started

To trigger refresh for a dataset in the Power BI service, simply make the following HTTP Request. You can craft this request using an HTTP.

Some additional tips:

  • Once you make the request, a data refresh will immediately be kicked off in the Power BI service
  • This works for any dataset imported to the Power BI service that you own
  • To get the group ID and dataset ID, you can make a separate API call, or simpler yet, just navigate to dataset settings in Power BI. The URL will have both the group ID and the dataset ID.
  • Like all requests to the Power BI REST API, you will have to attach an AAD access token.

For more information, see here https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/

answered Aug 28 by Rajiv
• 3,400 points

Related Questions In Power BI

+1 vote
3 answers

Difference between Power BI pro and Power BI Premium

My answer is applicable for a company ...READ MORE

answered Oct 30, 2018 in Power BI by chiranjeevi
• 160 points
709 views
+1 vote
1 answer
0 votes
1 answer

Difference between measure and calculate column in power BI

Hi Rahul,  With calculated columns, you can add new ...READ MORE

answered May 16, 2019 in Power BI by Cherukuri
• 32,490 points
4,974 views
0 votes
1 answer

Difference between Power Bi server and Power BI Service

Both the tools are quite similar but have ...READ MORE

answered Oct 29, 2019 in Power BI by Cherukuri
• 32,490 points
100 views
0 votes
1 answer

Difference between Power Bi Desktop and Power BI Service

Power BI Desktop is a robust resource for data analysis and reporting. It performs all reports, modelling using ...READ MORE

answered Oct 29, 2019 in Power BI by ch
• 3,450 points
165 views
+1 vote
1 answer

Topic -Power BI Paginated Reports with Excel or CSV file data source

Hi, @There, With Power BI Desktop, you can ...READ MORE

answered Aug 28 in Power BI by Carlos
119 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,120 points
246 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,120 points
1,275 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,420 points
338 views
0 votes
2 answers

Transform a heavy calculated measure (accumulated) into a column in Power BI

Hello, @Marinafr, If you are using Pro License ...READ MORE

answered 6 days ago in Power BI by Rajiv
• 3,400 points
76 views