Refresh with Redshift (gateway) + excel/csv (no refresh)

[alefielm]

Hi, I have a pbix published with 5 sources.

4 excel/csv with no refresh configured

1 redshift with gateway configured

If I upload the report with only the redshift source (deleting the other sources) I can assign it to the gateway and schedule it.

If I upload it with all sources I cannot assign the gateway

The excel/csv sources doesn't need to be refreshed, there is no data relation between Redshift source and the other sources.

How can I upload the report so I can schedule the redshift source and ignore the others?

Thank you!

[v-joesh-msft · Accepted solution]

Hi @alefielm ,

I'm afraid that we cannot set the different schedule refresh for one dataset,  you need to configure the On-Premise gateway and add a connection for each data source.

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[alefielm]

Thank you, sadly this solution is not suitable for me, the excels are just lookup tables or fixed data, Uploading all to redshift will be messy in some time, hope in a future have an option to choose wich source to update

Thank you

[TomMartens]

Hey @alefielm ,

if you onedrive for business or sharepoint online available, you can consider to move the Excel files to this cloud storage. Then it will no longer be necessary to add these sources to the gateway.

Regards,

Tom