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, 2020 in Power BI by Edureka
• 160 points
419 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, 2020 by Rajiv
• 8,890 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
1,146 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,990 points
7,387 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,990 points
275 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, 2020 in Power BI by Carlos
428 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,150 points
381 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,150 points
1,558 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,570 points
502 views
+3 votes
3 answers

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 32,990 points
69,542 views
0 votes
4 answers

How to combine multiple tables in power BI?

Click Advanced Editor and check if step #"Appended ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,480 points
25,592 views