Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
  • 1.  Refresh model as well as data

    Posted 6 days ago
    Edited by Pete Whittle 6 days ago
    I have linked a report to a cloud database via API, building the data model in several steps from a JSON file. It all works well. New data comes in with 'Refresh' and is added to the report.
    I added a new field to the database and need it to be added to the model. I added a record and it came into the PowerBI report with Refresh, but the new field has not been added. Obviously I have to force the power query to run again and include the new field, but I'm not sure how to do that.

    Someone suggested adding the dataset all over again, but that means I have to rebuild the whole report - not preferred.

    Much appreciated, thanks.
    ------------------------------
    Pete Whittle
    ------------------------------


  • 2.  RE: Refresh model as well as data

    Posted 6 days ago

    Hi,
    Open your pbix, Open Query, click 'Refresh' icon (or right click on table you want refresh).

    When you refresh in Query view you do not refreshing data. You refresh structure/source.
    After validate and close query, refresh new table. It's refreshing data.

    Regards,



    ------------------------------
    Adam Artur Boltryk
    Business Analyst
    ------------------------------



  • 3.  RE: Refresh model as well as data

    Posted 6 days ago
    Thanks Adam​

    ------------------------------
    Pete Whittle
    CEO
    Toowong DC
    ------------------------------