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

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