Expression Columns dont work in multi datasource

I created different data source from one dashboard, meaning userA log on he can see the information from databaseA when userB log on see data from databaseB usgin the Same Dashboard, its working fine with te datasource direct data but when userB open a Dashboard with expression columns the widget appears with error "Data retrival Error" but the userA can see it OK (the base dashboard was created with databaseA).

How can i fix it? Or i cannot use expression columns with multiple datasources even when we duplicate the first.

Thank Yoiu

Hi Juan, 

 

Thanks for contacting Syncfusion support. 

 

Could you please confirm that you faced the issue “Data retrieval error in widgets” while assigning datasource by using “Update Datasource” in Dashboard Server and log on to view it based on User specific like in the below image? 

 

 

 

If you get the reported issue in different case, please let us know. 

 

Regards, 

Renuka N. 

i create datasource for each user (and database), everything its ok but expression columns, 

How can i fix it?

Thank You

Hi Juan,  

Thanks for your confirmation.  

The reported issue “Update Data source is not working for Expression column” is known issue at our end. We have already fixed this issue and the fix will be available in our upcoming Dashboard platform version 4.1 release which is expected to be rolled out by the end of this month. 

Regards, 

Renuka N. 

I notice that a new version of the Dashboard has been released, i want to know if this problem was also fixed in this new version, and by then way i found that the pivot grid fails in the same scenario, when change the datasource by user group and use a pivot grid when you try to drill down information the grid fails, some times nothings appears (no detail information) other times show the wrong datasource.

Thank You

Juan Chau

Hi Juan, 

 

Please find the response for the below query. 

 

Thanks, 

C Jenitta Rachel