Unanswered

Power BI tile integration in PowerApps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

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.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

SeanHenderson 1,104 on at

Like
a
(1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous,

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:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-power-bi-tile

I suggest you express your views about customizing powerbi tile on PowerApps Ideas Forum. Your precious feedback will be very helpful for our work.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Best regards,

Was this reply helpful? Yes No
SeanHenderson 1,104 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
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."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @SeanHenderson , 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:
https://community.powerbi.com/t5/Service/PowerBI-linked-to-SharePoint-Lists-require-a-Personal-Gateway/td-p/3481
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)

Was this reply helpful? Yes No
SeanHenderson 1,104 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
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.

Was this reply helpful? Yes No