Refresh data in power bi using power app

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm entering data through power app which gets saved by clicking save button.

I have a 4 tables in power bi dataset ,In datatset "Currentsales" data has to be updated by this refresh button.

screenshot attached,

Now i have refrenced the dataset using groupid and datasetid.Now I don't know how to refrence that particular table in power app to be updated and where.

And also getting the error: Invocation of unknown or unsupported function.

Pls Help!!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

The screenshot is not accessible. You can refresh the Datasource using Power Automate. In building the flow, start with Powerapps and after that connect it with a button in Powerapps.

https://youtu.be/HzvsQ_CYF88

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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

Like
a
(0)

Report
Copy link

Link copied!

@eka24 ,I want to add a button that should refresh the dataset in Power App which is embedded in report.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Did you watch the tutorial I gave, any comments on it will help.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Do you want to update the Dataset records in your Power BI report inside your canvas app?

If you want to update the Dataset records in your Power BI report inside your canvas app, I afraid that there is no direct way to achieve your needs in Power Apps currently.

When you embedded a canvas app inside a Power BI report, you could not access the Dataset used in your BI Report within your canvas app directly. The PowerBIIntegration.Data formula could only pass the selected records from your Power BI Report to your embedded canvas app rather than the whole Dataset table.

As an fixed solution, you should add these Dataset tables used in your Power BI Report as individual data sources into your canvas app. Then you could update these data source records in your app through Patch function.

Please check and see if the following video resource could help in your scenario:

https://www.youtube.com/watch?v=b9gBXUdd55M

Regards,

Was this reply helpful? Yes No