Auto refresh for report with excel and DB

[yogevz]

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?

[v-jiascu-msft]

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]

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]

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