Dublin Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Refreshing Calculated Tables

  • 1.  Refreshing Calculated Tables

    Posted Jan 18, 2019 11:20 AM
    Hi All,

    Hoping for a bit of help.

    I have a composite model including both direct query and import tables. In this model I also have a calculated table that unions between direct query sources and import sources.

    Unfortunately the data validation is showing a small discrepancy and I think its due to the calculated table not refreshing when the direct query table refreshes.

    However the documentation says: "Calculated tables are re-calculated if any of the tables it pulls data from are refreshed or updated in any way."
    Using calculated tables in Power BI Desktop - Power BI


    Has anyone come across this situation? I really need the calculated table to refresh when the direct query source refreshes.

    Regards,
    Gerry




    ------------------------------
    Gerald O'Flanagain
    Reporting Specialist
    Dublin
    868678
    ------------------------------


  • 2.  RE: Refreshing Calculated Tables

    Silver Contributor
    Posted Jan 20, 2019 11:17 AM
    Hi @Gerald O'Flanagain,

    As you have DQ and Imported data in the same model you are under a Composite Model scenario.

    In this case you are going to have to refresh the calculated tables if these are coming from a Imported dataset. If someone as any tip how to work around it, please share.

    " Calculated tables are always imported, and their data is refreshed when you refresh the tables. If a calculated table refers to a DirectQuery table, visuals that refer to the DirectQuery table always show the latest values in the underlying source. Alternatively, visuals that refer to the calculated table show the values at the time when the calculated table was last refreshed."

    See more at: Composite models: calculated tables

    Hope it helps

    Regards,
    Jose

    ------------------------------
    Jose Almeida
    Data Analytics & Reporting Consultant
    bordalos.com
    ------------------------------



  • 3.  RE: Refreshing Calculated Tables

    Posted Jan 20, 2019 12:44 PM
    Thanks Jose, that's what I was afraid of.

    At least now I can focus on finding a different solution.

    ------------------------------
    Gerald O'Flanagain
    Reporting Specialist
    Dublin
    868678
    ------------------------------