Forum Discussion

H20treddr's avatar
H20treddr
Frequent Visitor
9 years ago
Solved

add or replace data in data set for a dashboard or report

Hi I just started using Power BI and I was able to create a report and also a dashboard.  I would like to know how I can upload a new data set INTO an existing Dashboard or Report using excel.  Said another way, keeping all my fields/hearders the same I want to replace the underlying data for a report / dashboard.

 

Thanks

  • Anonymous's avatar
    Anonymous
    9 years ago

    H20treddr,

    In Power BI Service, go to Settings->Datasets and find your dataset, turn on "OneDrive Refresh" for the dataset. This way, once you change data in Excel file, changes will be updated in Power BI too, usually within about an hour.



    Regards,
    Lydia

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    H20treddr This sounds like you just want to set up refresh. For that you can download the On Premises Data Gateway (Personal) then set the schedule of the dataset in the settings of the dataset.

     

    If you want to replace the file location, you can do that in Power BI Desktop, then just republish and it will overwrite the dataset in the Service.

    • H20treddr's avatar
      H20treddr
      Frequent Visitor
      9 years ago

      Thanks Eno1978.  Currently I am TRYING to publish from excel on my local machine to a file on my one-drive to update the dashboard.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        H20treddr Did you start by building your report in the Power BI Desktop? Or are you doing everything in the Service?