Forum Discussion
Manually refresh directquery table
Hi markperrone
Yes, you can create a button in your Power BI report that triggers a refresh of your DirectQuery table using Power Automate, with logic to only refresh when the result set is below your specified row count (X).
- Create a Power Automate flow that checks the row count of your table, only triggers a refresh if the count is below your threshold (X), returns a status message
- Embed this flow in your Power BI report as a button
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
There is no built -in path for a conditional update based on the number of lines in the desktop. Just create a card with calculating the lines and manually press when the card shows the amount more than, your threshold value
Hi markperrone
Yes, you can create a button in your Power BI report that triggers a refresh of your DirectQuery table using Power Automate, with logic to only refresh when the result set is below your specified row count (X).
- Create a Power Automate flow that checks the row count of your table, only triggers a refresh if the count is below your threshold (X), returns a status message
- Embed this flow in your Power BI report as a button
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.