Not able to apply changes to scheduled data refresh

[Anonymous]

I have a report with some gsheet (export to csv trick) data sets. When I enable checkbox allow cloud data sources on the gateway, it get's green and I can turn "use data gateway" on, but no luck when clicking on "Apply" so far, it keeps telling me "something went wrong"... All other data sources / reports / dashbords are working smoothly with the very same gateway.

This doesn't make it even a bit clear, but maybe, someone can go and check it.

Something went wrong
Failed to use the selected gateway. Please make sure the gateway is up and running and try again.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: b050ca96-f8ea-4cf9-8d44-01ec1f752cf0
Request ID: 5d2dc308-7b07-e606-578d-bc92fd21de90
Correlation ID: 743bacdc-c934-17b5-0d8a-45e840f34178
Status code: 400
Time: Mon Dec 03 2018 14:14:40 GMT+0100 (Central European Standard Time)
Version: 13.0.7382.168
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net

[v-yuezhe-msft]

@Anonymous,

It seems that you combine online data source and on-premises data source in a single dataset, right?

If so,  make sure that you enter the same connection strings of on-premises data source in Power BI Desktop and Power BI gateway. In Power BI Desktop, please go to File -> Options and settings ->Data source settings to check all the data sources of the dataset, you can post screenshot about data sources in Power BI Desktop and gateway here.

Regards,
Lydia

[Anonymous]

Yes,

there are three web data sources and one on-prem (import) data source. Everything is the same in the gateway and the pbix file.

pbix:

ssas: ssashostname; ssasmodelname

web:

• configured: https://docs.google.com/spreadsheets/d/sheets-guid-1/export?format=csv&id=sheets-guid-1&gid=0
• showing: https://docs.google.com/spreadsheets/d/sheets-guid-1/export

web: 

• configured: https://docs.google.com/spreadsheets/d/sheets-guid-2/export?format=csv&id=sheets-guid-2&gid=0
• showing: https://docs.google.com/spreadsheets/d/sheets-guid-2/export

web:

• configured: https://docs.google.com/spreadsheets/d/sheets-guid-3/export?format=csv&id=sheets-guid-3&gid=0
• showing: https://docs.google.com/spreadsheets/d/sheets-guid-3/export

GW:

ssas: ssashostname; ssasmodelname

https://docs.google.com/spreadsheets/u/0/d/sheets-guid-1/export?format=csv&id=sheets-guid-1&gid=0

https://docs.google.com/spreadsheets/u/0/d/sheets-guid-2/export?format=csv&id=sheets-guid-2&gid=0

https://docs.google.com/spreadsheets/u/0/d/sheets-guid-3/export?format=csv&id=sheets-guid-3&gid=0

(also tried it the other way with no luck:

https://docs.google.com/spreadsheets/u/0/d/sheets-guid-1/export

https://docs.google.com/spreadsheets/u/0/d/sheets-guid-2/export

https://docs.google.com/spreadsheets/u/0/d/sheets-guid-3/export)

[v-yuezhe-msft]

@Anonymous,

You don't need to add web data sources within gateway after you select "allow cloud data sources on the gateway " option. Also please check if you can use dame hostname and database name in Power BI Desktop and Power BI gateway for SSAS data source.

Regards,
Lydia