Refresh Data

[butterscotch]

Hello !

 Im facing an issue where i have a dahsboard and the data will be modified by user using powerapps that has been embedded in my power bi dashboard. the thing is, everytime i update  data field in powerapps, the data wont immediately reflect on power bi dashboard, instead i need to open data source file (excel) then close it again and the open it again (this time around i can see the changes that i made using powerapps just now). afterwards, i navigate to power bi then click refresh button then finally the data will be reflected on power bi. how to takcle this issue ?

Thank you in advance !

[tharunkumarRTK · Accepted solution]

@butterscotch 

 You can not expect your dashboard to be live with import storage mode. You need to switch to direct query storage mode and suported data sources. For your requirement, dont use excel as a datasource. Instead opt for dataverse/SQL Server.

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[butterscotch]

understood sir, thank you !

[tharunkumarRTK]

@butterscotch - You are welcome

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun