Forum Discussion

Souheyl11's avatar
Souheyl11
Frequent Visitor
7 years ago
Solved

How can I replicate the changes made in Excel automatically into my Power BI report?

Hi   I've a PBI report feeded by an Excel datasource, however, every single change I make in my Excel datasource, is not populated into my PBI report, even after having hit the refresh button ! How...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Souheyl11

    From your screenshot, it seems your file stored on "onedrive" which means you file is stored online?

    If so, you don't need to add the data source to the gateway, just go to dataset->setting->schedule refresh->edit credential.

     

    Or if it is actually in your local drive, please ensure you enter the right file path and windows name and password.

    to make sure you use the right file path, please right-click on the excel file, then select "properties", in "General" part would see location of this file.

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Souheyl11

Does it works now?

How can i help you further?

 

Best Regards

Maggie

Souheyl11's avatar
Souheyl11
Frequent Visitor
7 years ago

Hi v-juanli-msft

 

Yes- it's partially OK- because I cannot get my data refreshed into PBI without first refreshing my tables into Excel, is there any way to refresh my excel pivot tables (included in my datasource file) directly in PBI without the Excel refresh action first?

 

Thanks