We have an aggregated data source with a key (i.e. dense_rank) for each aggregation. This table is imported. We have an associated very large detail table with the same key calculation but its too large to import so we’re using directquery. Can we use power automate to manually query the detail after making selections from the aggregated data? We can’t have the directquery automatically refreshing. The imported tables should not be refreshed - only the detail. Thanks
Yes, you can set this up. Power Automate can trigger a refresh on just the detail (DirectQuery) table based on your selection, without touching the imported ones. The key is wiring up a Power Automate flow to your report, either via a button or custom visual, so it only runs when you want.
I’ve done this by connecting a Power Automate button in Power BI. When a user clicks, it kicks off a flow that either queries the data source directly or refreshes just that visual (using parameters if you’re filtering). The imported tables stay put. Not the slickest native experience, but it works and avoids unnecessary refreshes.
1 Like