Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Data Refresh in PBI Report

Hello. i just started using PBI and I have a problem finding the 'Refresh Data' button as the interface in PBI Report has changed from 2 years ago. I want to make sure that everytime the excel in sharepoint has been updated with new data, the PBI can also update the dashboards with the updated one. Is the button hidden or have they simplified both refresh visual and refresh data into the button on the top right? Im not sure if refresh visual is the button im looking for.

.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    "Refresh" applies mostly to datasets semantic models or individual tables/queries. The "Refresh" button refreshes all queries, but your can also right click on individual tables and refresh only the query for that table.

  • josef78's avatar
    josef78
    Memorable Member
    2 years ago

    I'm not sure about what you are talking... "button as the interface in PBI Report" if about interface in PBI Report on Power BI Report Server portal (as end user), or interface of Power BI Desktop (as developer).

     

    If on Power BI Report Server, there never has been button to refresh data model. There is button to refresh data in visualization from direct underlying data. It's mean, if you are using import mode, is refreshed only data from internal vertipaq database (which are not changed). If you are using live connecton, visual are refreshed from dedicated SSAS model (which could have been updated meanwhile by another process). Or if you are using direct query, in this case visuals are updated with new fresh source data.

     

    Only way how update import mode data, is run scheduled refresh (automatically or manually).

     

    Second, If in Power BI Desktop, you can refresh source data to model anytime pressing refresh button in Power BI Desktop.