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,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.


Thank you.