Forum Discussion

yogevz's avatar
yogevz
Icon for Helper II rankHelper II
8 years ago

Auto refresh for report with excel and DB

Hi

I have file which has connections to SQL server and several of excels.

when i put the file in the cloud, the refresh fails.

fails because of the excels, and for that reason the DB is not updated.

suggestions?

Need Help

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi yogevz,

     

    How did you connect to the excels? Because you put it in the cloud, the connection could be different. It could be a URL of the excel files. 

     

    Best Regards,

    Dale

    • yogevz's avatar
      yogevz
      Icon for Helper II rankHelper II
      8 years ago

      the excels are local in my laptop.

      i don't want to put them in one drive...

      can i disable source/table in the pbix file?

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi yogevz,

         

        You don't want to put them in the OneDrive. And if you don't put them in the cloud, the refresh should work when you configure proper data gateway. We can't disable the refresh of one query (table) for now. But we can delete it.

         

        Best Regards,

        Dale