Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rbagdia
New Member

Embedding Excel Model with Power BI Web App and Inputs to Excel controlled from Web App

I have a fairly detailed Excel model with macros for running different scenarios and comparing them. For one project it is required to develop web based app for open public use. I have following some questions:

 

  1. I am considering to embed excel with Power BI, and host it on client server. Idea for us will be to easily make changes in the excel model, without worrying bout to depend on IT provider for manual coding changes post launch. This way we can focus on our strengths as a domain Consulting organisation. Want to understand what kind of licensing needs related to excel and Power BI to host public use of the model/app, and what costing for the same? 
  2. Can Web App built using Power BI provide/change inputs to the Excel model and retrieve updated outputs in real time for BI visualisations? What good examples and demo videos to ensure Power BI is best fit for such need?
  3. What different forms the inputs can be given using Power BI for rich user experience - slider, editable curves, matrix, clock etc?
  4. What things to keep in mind if it will be required to give user logins for people to login to the app, and store their model changes and results?
  5. What other open source tools available to embed excel with strong front web engine with powerful BI visualisation (like High Charts)? How do they compare with Power BI and licensing costs for open public use?

The complexity of excel model can be looked upon as 20 worksheets with 400+ line of codes in each, and some 120+ charts required. We are also looking for a Developer to help us put this Web App. 

1 REPLY 1
v-juanli-msft
Community Support
Community Support

Hi @rbagdia 

We can import data from excel into Power BI and keep the data updating in Power bi along with it in excel via schedule refresh.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-import-excel-workbooks

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-local-drive

 

there are many visuals in Power BI:

https://docs.microsoft.com/en-us/power-bi/developer/visuals/power-bi-custom-visuals

 

regarding web apps, if you mean powerapps, please refer to:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual

 

If you mean custom web appps, please consider power bi embeded analytics.

https://powerbi.microsoft.com/en-us/power-bi-embedded/

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors