You’re offline. This is a read only version of the page.
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.
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?
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
#1
WarrenBelz
146,745
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,091
Most Valuable Professional
Share
Report
All responses (
Answers (
