Forum Discussion

cconnors_mhc's avatar
cconnors_mhc
Frequent Visitor
5 years ago
Solved

Scheduled refresh issue with cloud data source

Hello,   I scheduled a daily refresh at 7am earlier this week, yet it has not completed a resfresh once. Nor is it showing any errors. The "Next Refresh" shows the correct data and time, yet nothin...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    cconnors_mhc 

    No my bad, you are not using dataflow. However you should change the way you connect and build your report. Here are the steps. Your Excel file is in Sharepoint not One drive for business:

    1. In power bi service go to Get Data and 

       

    2. Connect to your Excel file

       

    3. A dataset will be added to the service

       

    4. Go to your desktop and Get Data 

       

    5. Look for you dataset, build the report and Publish it to the service. The lineage should look like this

       

    6. The refresh will be automatically and Hourly 

       

    I hope it's more clear now. Let me know how it works our for you.

     

aj1973's avatar
aj1973
Community Champion
5 years ago

cconnors_mhc 

No my bad, you are not using dataflow. However you should change the way you connect and build your report. Here are the steps. Your Excel file is in Sharepoint not One drive for business:

  1. In power bi service go to Get Data and 

     

  2. Connect to your Excel file

     

  3. A dataset will be added to the service

     

  4. Go to your desktop and Get Data 

     

  5. Look for you dataset, build the report and Publish it to the service. The lineage should look like this

     

  6. The refresh will be automatically and Hourly 

     

I hope it's more clear now. Let me know how it works our for you.

 

cconnors_mhc's avatar
cconnors_mhc
Frequent Visitor
5 years ago

aj1973 Thank you! My excel file is located in onedrive for business, but I needed it to show as a web query not local file in Power BI desktop. The path pulled from the excel file reads sharepoint but it is loctaed in a shared Onedrive for business.  I followed the video here https://www.youtube.com/watch?v=uxMlV9KKf6E&list=RDCMUCsOfIwAXj1fT6LDqEDEAb4g&t=18s , however, I ran into issues with the scheduled refresh. 

 

Instead of using the workflow explained in the video I will try the process you have given me. Thank you!!