Forum Discussion

Peter2's avatar
Peter2
Frequent Visitor
8 years ago

Refresh Data

Hi, I have a few questions about refreshing data:   If I create a data model in Power Pivot for Excel and import the excel contents into Power BI Desktop, can I refresh the data in Power BI Desktop...
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

HI,

 

To answer your first question, I am assuming that the source data for your Excel model is coming from some external data source (such as CSV/Excel files lying in a folder).  If that be the case, then when you import the Excel file (with your PowerPivot model) into PowerBI desktop, refresh should work seemlessly i.e. in you add more CSV/Excel files in the source data folder, a refresh of your PowerPivot desktop file should pick up the new data.

 

Hope this helps.

  • Peter2's avatar
    Peter2
    Frequent Visitor
    8 years ago

    Hi Ashish, thanks for your reply.

     

    Some of the tables, such as the date table are in excel while other tables containing accounting data are in an Accounting Package called Accpac (SQL). I have specific permissions to get the SQL Data, Is it possible that thie permissions will prevent Desktop from refreeshing the data, I don't have a problem with refreshing the Power Pivot data from all the data sources.

     

    Thanks again

     

     

    Peter

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      I do not know.  Sorry.  May be someone else can help.