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
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