Forum Discussion

powerbidu's avatar
powerbidu
Frequent Visitor
1 year ago
Solved

How to schedule refresh PowerBI dashboard with Excel as Data source

Hi all I have published my PowerBI on app.powerbi.com and am trying to create a scheduled refresh. My current data source is excel file. Due to org restrictions, I am unable to create a gateway. He...
Need Help
Tips and Tricks
  • pallavi_r's avatar
    pallavi_r
    1 year ago

    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

     

powerbidu's avatar
powerbidu
Frequent Visitor
1 year ago

Hi I do not have the access to apply for refresh. Could you kindly advise if I am doing something wrong? Thank you in advance.

 

pallavi_r's avatar
pallavi_r
Icon for Super User rankSuper User
1 year ago

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