Forum Discussion
Table visual with data from 2 different data table only showing common data
i created a table visual getting data from 2 different data tables but it only shows data which is common in both table. Anybody have some idea why and how to resolve? table A is a main table wit...
this seems created another problem...
it cannot be refreshed with an error like this "We cannot refresh this dataset because the dataset contains calculated tables or calculated columns based on data from a Single Sign-on (SSO)-enabled Direct Query data source. Please configure the dataset to use an explicit connection with granular access control to access this data source and then try again."
any other option?
See the article below for more details.
Are you able to access the underlying data source of 'Table A'[Case ID]? If so, you could import it into your model and union it with 'Table B'[Case ID], forming a master Case ID table.