I have plotted a line chart in Power BI and then inserted it into PowerApps as a Power BI tile. I would like to add a series on the graph which would be based on user input from PowerApps. Is it possible to do as I couldn't find any way to do it. Any help would be appreciated.
Can you please share a little more about your scenario?
Are you building a Model-driven app and you want to add a Power BI component to your personal dashboard?
Do you want your line graph to update dynamically based on something else you select on your dashboard?
I'm trying to build an app in PowerApps, I have inserted a Power BI tile, as you can see in the screenshot. For all 5 series of the line chart it sources the data from Power BI. What I would like to do is to leave the first four series (10%, 20%, 30% and 40%) as they are, but I would like to plot another series (MgO) which would be based on the values that would be entered by a user of PowerApps in Text Input fields. Then the chart should be updated dynamically with the these values inside PowerApps as a Power BI Tile.
Does that make sense?
I couldn't find any way to do it, so not sure if it's possible.
Do you mean that you want to use data from powerbi and PowerApps in powerbi tile?
I'm afraid it's not supported in PowerApps currently.
For now, you could only use existing data analysis and reporting of powerbi in powerbi tile.
Here's a doc about Powerbi tile for your reference:
I suggest you express your views about customizing powerbi tile on PowerApps Ideas Forum. Your precious feedback will be very helpful for our work.
I think I understand what you mean.
What is your data source for the Power BI report? What you could do, though it might take a little work to set up, is this:
1) Add the fields from your canvas app that you want to capture into the same data source that the Power BI report is connected to.
2) Use a Patch function to write to the data source when the user uses the canvas app.
3) Add these new fields to your Power BI report.
So the user makes changes in the canvas app, those changes are written back to the same data source the Power BI report is connected to using a Patch function, then the Power BI report reflects the changes.
Let me know if that helps.
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."
Thanks @SKH19 , that's a good idea. I got to step 3, however, I cannot get my list connected to Power BI, as I'm facing the same problem as everyone on these threads:
There doesn't seem to be a clear solution to this. (I tried sharing and using my credentials as well as general website, nothing worked)
Are you using SharePoint Online?
When you are given the prompt to set up your connection to SharePoint, which option do you select?
You might need to clear your permissions in order to check, as it probably cached them since your first login attempt and now skips the authentication options.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand