Forum Discussion
Query from PowerBI as automated refreshed table for use in PowerApp
Hello everybody,
i have a combined table in a PowerBI Dataset and am refreshing the Dataset 2 times a day.
I want to use the data from this table in a PowerApp and haven't figured out a good way to use the refreshed data.
I tried to use the query in an online excel file but had no option to automatically refresh it.
It would be really good if someone has an idea how to do it.
Thank you in advance!
Daniel
5 Replies
- lbendlin
Super User
You can use a custom connector to run DAX queries against your dataset and consume the result in Power Apps.
v-jingzhangCommunity Support
Hi Anonymous
You can create a dataflow in Power Platforms and use it in your PowerApps. You can set scheduled refresh for it. It's like Online Power Query experience.
Here are some docs for your reference:
Create and use dataflows in Power Apps - Power Apps | Microsoft Docs
Create and use dataflows in Microsoft Power Platform - Power Query | Microsoft Docs
Hope this helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
