Solved: Re: Power BI Data(Excel) refresh using PowerApps

Anonymous · ‎04-10-2020

Hi Team,

I want to refresh Power BI Data using PowerApps. Data source is excel and it is saved in a shared drive. When ever new comments are added to excel it has to be populate in PowerBI(in real time). My manager asked me to implement PowerApps, However i am very new to PowerApp and no much idea whether it is possible or not. Any suggession would really help.

Thank you,

Vikas

mwegener · ‎04-10-2020

Hi @Anonymous ,

take a look at this.

The process chain should be.

PowerApp --> Power Automate --> Power BI Refresh

https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials

View solution in original post

mwegener · ‎04-10-2020

Hi @Anonymous ,

take a look at this.

The process chain should be.

PowerApp --> Power Automate --> Power BI Refresh

https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials

parry2k · ‎04-10-2020

@Anonymous hope this link helps.

Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.