Forum Discussion

ricardoCB's avatar
ricardoCB
Regular Visitor
1 year ago
Solved

Onedrive automatic update does not work

Good morning everyone, I have an Excel file as my data source saved in SharePoint, along with my Power BI file. I imported the Excel file directly in the Power BI Service, configured the connection ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi  ricardoCB  ,
    Thanks so much for the detailed update!
    I really appreciate you walking us through the exact steps you followed. Given that manual refresh works but scheduled refresh still doesn’t trigger even with the Web connector and direct SharePoint file URL, it looks like everything on your end has been configured correctly.At this point, the issue likely requires deeper investigation from the Power BI support team.

    I recommend raising a support ticket so the engineering team can review backend logs and assist further.
    To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

    Hope this helps.If so,consider accepting it as solution.



ricardoCB's avatar
ricardoCB
Regular Visitor
1 year ago

Hello ! It is a xlsx file !!!

thanks

 

 

lbendlin's avatar
lbendlin
Super User
1 year ago

That's what the extension says, but what's inside? Can be a .xls in disguise.  Open it in Excel, make a change, and then re-save as .xlsx 

  • ricardoCB's avatar
    ricardoCB
    Regular Visitor
    1 year ago

    Unfortunely does not work. I did with a brand new xlsx file. 

    PBIonline connects to sharepoint folder but does not refresh :

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi ricardoCB ,
      Thank you lbendlin  and rohit1991  for the helpful response!
      Thanks for the update. It sounds like the issue might be with how the Excel file is connected through the SharePoint Folder connector. Double check your data source credentials in the Power BI Service and ensure you are signed in using OAuth2. If the manual refresh still hangs, try using the Web connector with the direct file URL from SharePoint instead. 

      Hope this resolve your query.If so,consider accepting it as solution.

      Thank you.

      Regards,
      Pallavi.

      • ricardoCB's avatar
        ricardoCB
        Regular Visitor
        1 year ago

        Thank you all for the support, but unfortunately, this setup definitely doesn’t work.
        The automatic refresh does not work for Power BI files connected to an Excel file stored in SharePoint.

        Here are the steps I followed:

        1. Created the .xlsx file in SharePoint

        2. Copied the file path

        3. Built the Power BI report using the Web connection

        4. Published the Power BI file to the workspace

        5. Configured the credentials

        6. Set up the automatic refresh

        7. Manual refresh works, but scheduled refresh does not