Power automate teams power bi

(0) Share

Report

Posted on by Prachiii

I want to create a power bi dashboard daily report . The data is coming in teams through a daily trigger of pipeline. How can this be completely automated for power bi desktop

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Prachiii

Can you provide additional detail please?

Was this reply helpful? Yes No
Prachiii 19 on at

Like (0)

Report

Hi @ScottShearer

I am working on to automate a process, wherein there is a pipeline which displays the count of items daily in teams channel, that data is to be automatically displayed to power bi daily

Was this reply helpful? Yes No
Prachiii 19 on at

Like (0)

Report

so I need information on how can this be done

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Prachiii

You might start with a When a New channel message is added trigger. Then, you'll have access to the message content, who posted the message, etc.. If the message is formatted, you should be able to extract the data that you want from the message. A split() expression or two will help with this.

Then, you'll want to update the data source being used by Power BI. Hopefully, you can update the data source. If you have published the Report to the Power BI service, you can have Power Automate refresh the data.

Can you tell me what data source is being used by Power BI and of the messages are formatted the same way every day?

Was this reply helpful? Yes No
Prachiii 19 on at

Like (0)

Report

the power bi data source has to be setup with this flow . The data is stored as a teams notification in the channel.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Prachiii

I suggest creating a SharePoint list to store the data. In your Flow, add the data to the SharePoint list (after you extract it from the post)using a Create Item action. Create a Power BI report using the SharePoint list as the data source. Publish the report to the Power BI service. If you do so, Power Automate can refresh the Power BI data.

Was this reply helpful? Yes No
Prachiii 19 on at

Like (0)

Report

How can I extract a particular value from string from teams .. suppose message posted daily is “count of itemA:1(dynamic) and count of itemB:2(dynamic)”

Was this reply helpful? Yes No