I am using the Power Apps for Power Bi visual in my power bi report where I have forms that prompt the user to add/edit data after drill through.
However, when I try refreshing the PowerBIIntegration Object with PowerBIIntegration.Refresh()
I get an error saying 'Refresh' is an unknown or unsupported function in namespace 'PowerBIIntegration'.
I also tried Refresh(PowerBIIntegration.Data)
I get a different error saying only managed connections can be refreshed
This is the last step I need to complete the report I am working on and I have no idea how to fix this. All the documentation I find says to use PowerBIIntegration.Refresh()
but I can't seem to figure out why it is not working.
Any ideas on how to fix this?
EDIT: My data is direct query from dataverse
I am using the Power Apps for Power Bi visual in my power bi report where I have forms that prompt the user to add/edit data after drill through.
However, when I try refreshing the PowerBIIntegration Object with PowerBIIntegration.Refresh()
I get an error saying 'Refresh' is an unknown or unsupported function in namespace 'PowerBIIntegration'.
I also tried Refresh(PowerBIIntegration.Data)
I get a different error saying only managed connections can be refreshed
This is the last step I need to complete the report I am working on and I have no idea how to fix this. All the documentation I find says to use PowerBIIntegration.Refresh()
but I can't seem to figure out why it is not working.
Any ideas on how to fix this?
EDIT: My data is direct query from dataverse
Share Improve this question edited Mar 21 at 14:21 iBeMeltin asked Mar 21 at 14:15 iBeMeltiniBeMeltin 1,8421 gold badge4 silver badges18 bronze badges2 Answers
Reset to default 0You must create the app within the power bi report on Power BI Service not the desktop. This ensures the PowerBIIntegration.Refresh()
function is embedded in the app.
If PowerBIIntegration.Refresh()
is not working, follow any two approaches below:
Create a power automate that will refresh the report by auto trigger.
If the
PowerBIIntegration.Refresh()
is not working then use timer like options and it will trigger the auto refresh.I was facing the same issue I created a power automated flow to fix this issue.
https://community.fabric.microsoft/t5/Service/PowerBIIntegration-Refresh-PowerApp-workaround/m-p/3192799