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 update...
Need Help
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