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

     

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi powerbidu ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.