Forum Discussion

nbarsley's avatar
nbarsley
Helper I
1 year ago
Solved

Union Power BI Service Datasources

Hi there! I've got a large dataset that is somewhat slow to refresh and my team would like the data updated every 30 minutes. I've been thinking about how I can cache the stale data in one dataset i...
Dataflow
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi nbarsley Could you follow these please 

    • Publish both stale (daily) and current (30-minute) datasets to the same Power BI workspace.

    • In Power BI Desktop, use Get Data > Power BI Datasets to connect to both datasets. Build a composite model by querying both.

    • Create a calculated table using DAX:

      CombinedData = UNION(Dataset1[TableName], Dataset2[TableName])

    • Use the CombinedData table to build your report visuals.

    • Publish the combined model to the Power BI Service for dynamic updates.

    If this post helped please do give a kudos and accept this as a solution 
    Thanks In Adavnce

     

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi nbarsley,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Thanks and regards