Excel sheet with Power bi

Hi albatoul ,

If you put excel at your local machine then all the time you need to follow this process .

What I would suggest, Please put your excel file in share point and refresh your report from Power BI services.

By this way you only need to replace excel sheet in sharepoint whenever it require and then refresh your report.

Thanks,

Samarth

If you're using power bi service, then one possible solution is to put the excel file in a shared OneDrive location, and import excel data from there into power bi. You can then set up a scheduled refresh for you power bi dataset.

thank you for your fast replaying I put it in OneDrive in my PC do you thing is google drive is better ? 

and is it possible for youser to update the sheet when it's in google drive ?

dear @ashkanduja

thank you for replaing I already add it in one drive then went to power bi 

click on Get data -> then web-> and add the file 

is this the right way ?

(ou can then set up a scheduled refresh for you power bi dataset.) can you explain this more please 

it's not working please  hellp me I'm alone learn by myself the problem is with the gateway it's show disable 

Hi albatoul ,

Did you install the gateway? Please share the error message or some screenshots.

Refer to

Install an on-premises data gateway | Microsoft Docs

Use the on-premises data gateway app | Microsoft Docs

Best Regards,
Eyelyn Qin

Hi albatoul ,

Please firstly erase some private information contained in your pictures like the username, file address...

According to your screenshots, the full path you entered is not correct, yours is ended with a folder name but not the excel file name

Please go to Transform --> Data source settings to get the full path that is ended with .xlsx

A similar thread:

https://community.powerbi.com/t5/Service/We-could-not-register-this-data-source-for-any-gateway-instances/m-p/605338

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi albatoul ,

I have a test on my side.

This means you have successfully configured the gateway.

Then click the "Scheduled refresh" icon of this dataset , map the data source and click "Apply".  Then everything will work fine.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

sorry it's taken so long I need help in this last step i don't know why it's show unathurize access I gave access but it's fail to refresh