Forum Discussion
Refresh Data
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 !
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
3 Replies
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
understood sir, thank you !
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
