Power BI refresh failure after changing the parameter in gateway

[KrystalChan]

Hi Guys,

 We set a parameter to switch the data source between SQL Server Database and SSAS, all the connections are successfully in the gateway.  When we change the source to SSAS in the gateway, can't refresh the Power BI report automatically and be noticed as the following errors. Could you help to check with it?

Data source error:	The 'KeyDB' column does not exist in the rowset. Table: Master Channel with Order.
Cluster URI:	WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:	f965f593-8aa6-4ef4-9357-aecb548580bb
Request ID:	154615c2-ebc8-572c-79b3-721cb3857b7f
Time:	2020-03-05 03:35:24Z

Data source error:	The 'KeyDB' column does not exist in the rowset. Table: Master Counter.
Cluster URI:	WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:	d0eae51b-050d-4226-9783-200a322e6f40
Request ID:	a816da08-f805-44e7-8dd2-862207a8a9c0
Time:	2020-03-05 03:31:57Z

[v-qiuyu-msft]

Hi @KrystalChan, 

Please download the report, change datasource parameter value then apply the change, check if there is any error with tables "Master Channel with Order" and "Master Counter". 

Best Regards,
Qiuyun Yu

[KrystalChan]

There's no error notice from my local site when I switch to loading data from SSAS. Everything seems ok. Please help, thank you.

[v-qiuyu-msft]

Hi @KrystalChan, 

I would suggest you create a support ticket to let engineers look into the issue on your side.

Best Regards,
Qiuyun Yu