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 ...
  • 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

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?

  • H20treddr's avatar
    H20treddr
    Frequent Visitor
    9 years ago

    To start , I loaded as an excel file published to one-drive cloud and clicked to create a report from there.  I appears that was was able to update the data but publishing from excel on my local machine to the one-drive file, then this was refreshing my report / dashboard.

    • Anonymous's avatar
      Anonymous
      Not applicable
      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