How to schedule refresh PowerBI dashboard with Excel as Data source

Hi powerbidu 

You can refresh it without gateway using the following steps.

Step 1 - You need to open the file in your one drive where it is stored. Go to file->info->copy path as below

Step 2 - After getting this path from here, open your pbix file->get data from the above path.

Step 3 - Publish it workspace. Data Source credential and refresh will be enabled.

You can also check in the below video from Guy in a cube at time 2:50

https://www.youtube.com/watch?v=CYSMZxaXNLk

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi