So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. It would be nice if when you blend two data sources, you could have the option to show "Only Relevant Values" on filters used from the secondary data source. the blend relationship is defined on driver Code, and working fine when adding both basicSalary (from main data source) and fuel (from secondary) to the sheet. In Tableau Desktop, navigate to Data > Edit Relationships. In blending data source, I try to slove problem but I can't. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. You can create a federated database using linked tables/worksheets. I have the same issue, but Primary Data Source is a Tableau Server Data Source (I do not have direct access to the database), and Secondary Data Source is an excel flat file. I am trying to use the below formula instead of countd function because my data comes from Impala. According to Tableau, this error can also appear when using a LOD expression in a blended view. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. The data are sorted, but each row only shows one month of data with the other five columns blank. In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Instead, publish each data. LOD expressions are used when running complex queries with multiple dimensions at the data source level. Assuming that's what's going on, there's the question of how to work around this. i will try to build some moke up data in excel and reproduce the same but before that could you please explain me in detail what calculation i need to perform in secondary source. Option 2: Join tables that are in the same data source, instead of blending them. I am using tableau 2020. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. I have quick filters from the primary data source and I am trying to represent distinct. Hi Justin, Thanks for your quick reply. Use a parameter with a calculated field to filter the secondary data source at the row level. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. Loading. I have two data sources which I have blended together on two fields: branch and date. I'm trying to blend two data sources on a single field, say 'Program Description'. I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary) BI Cube Data 1 pc. Because the question is related to how the data sources are being related, it would help to see the real data structure. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. When Bugs History is a live connection to Vertica living inside my workbook all is well. FIXED requires that you have row-level access to the rows in the secondary source. Option 1: Include all linking fields in the view, and aggregate secondary fields Data blending will work when the secondary data source uses logical tables, as long as the following conditions are met: All active linking fields from the primary data source must be included in the view on a shelf other than the Filters shelf Link Primary Source and all other secondary source on this Field Created from step 3- 4 using Edit Data blend Relationships 6. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. They cannot be used as secondary data sources. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. Data blending is a method for combining data from multiple sources. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Did some research on this and found plenty of "workarounds" with no success (like replacing COUNTD() with a LoD using AVG(# of Records)) Workaround: Option 1: Instead of using Data Blend, please use Relationship to relate the data sources, and the "Only relevant values" option is available to show only existing values. Pick the secondary data source in of Secondary data source pane. The version I am working with 10. Secondary data source: (excel) master zip file with ~40k rows (all US zips) - each zip is tied to a territory I am looking to add the territories from the master zip to territory file as a filter. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data blending works only as a left join. ×Sorry to interrupt. 1. You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. Excel 1 pc. Limitations of Data Blending in Tableau. If if this is the case, you could try creating a calculation for DAY([Endtimestamp]) in both the primary and secondary data sources, and adding it to the blend. General Information. e. [tier] == 0 then "Low vendors" elseif max [Secondary]. Instead of using relationships, double-click into your table to get to the. e. This didn't work alas, "cannot blend secondary data source because one or more fields use an unsupported aggregation" I am using a filter from a different datasource to filter by region . ” We use three kinds of cookies on our websites: required,. Hello Jim, Thank You for your reply. Cannot blend the secondary data source because one or more fields use an unsupported aggregation Did some research on this and found plenty of "workarounds" with no. Unknown file type Total from Secondary Data Source. How do I blend these data sources by year? - The Tableau Community. ×Sorry to interrupt. And I can't explain why it does that. Expand Post. Blending runs a query on each data source and joins the aggregated results of those queries. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Blending with CountD and LODs. Select Default Properties > Sort. I have three different data source . I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. Reference line -----> in this approach able to show sub-category items measures like sales and quantity totals as reference lines shown in below figure . LOD will not work if it is from the secondary datasource. Data from a secondary source is displayed along with the primary source data. I tried to recreate the data as close as possible. But I cant add filter Month from the Budget Excel file. The attached workbook and the following steps illustrate the process. Upvote Upvoted Remove Upvote Reply. If we are working with one data source that is not relatable or joinable (such as Google Analytics) you are not able to blend a secondary data source with logical tables to it. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. When you blend, you can only have aggregate access to the rows in the secondary source. Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. The. The date values must be in the same format. Moreover, blending is a kind of left join, not exactly a join. For more information, see Use Relationships for Multi-table Data Analysis. I'm able to successfully connect to both data sources and set up the relationship, with the Teradata extract being primary and the Excel sheet being secondary. ODBC is a pretty universal technology for doing this, you can find more by doing a web search on "linked tables" or "linked worksheets" for your specific data sources. Ken Flerlage (Member) 5 years ago. 0 but was disabled (greyed out) in 8. I am already using a Custom SQL query as an additional data source and trying to do blending based on the relationship on BU code field from RPT and AD. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. Summary:. Remove all dimensions from the secondary data source and ensure that the primary data source’s. Build whatever calculated fields from the secondary that need to be used in in the primary. Data. This is the final step and will result in filtering between the blended data sources at your desired level of granularity. 1 because it can cause Tableau to unexpectedly quit. ”. "cannot blend the secondary data source because one or more fields use an unsupported aggregation" Attached is the workbook that could provide more clarity on my question. Then, after data blending, the final graph cannot show the data related to the South and East. Blending your Data in Tableau. During Data Blending in Tableau, if the secondary data source has any LOD (Level of Detail) Expressions, they are taken down after the data blending process is finished. What steps do I need to do to do this?It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". ) A LOD calc is also trying to do stuff at the row level. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. 0 and 7. I've blended on user ID. I have my primary data source with dimensions customer and order no and a secondary data source with customer, postcode and an 'is vat exempt' boolean field. 3. Good morning @Fred Yu (Customer) . 1) When we add fields from secondary data sources to a view Tableau “joins” the data as part of the blend on one or more linking dimensions. Select Default Properties > Sort. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. Change the default sort order of the field using the various options, and then click OK. and tried to plot chart, the chart complains that "Data sources that contain logical tables cannot be used as secondary data sources for data binding". Cannot blend the secondary data source because one or more fields use an unsupported aggregation. It sounds like there might be some complications with a blend? Can’t speak to what’s happening there Are you blending on [Endtimestamp]? By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. I have two data sources and I have blended them together. Make the field(s) used to address the table calculation active linking fields. I am confused, as I am not even trying to blend Data from both Data Sources. Instead, publish each data source separately (to the same server) and then blend the published data sources. Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. I want to do a basic data listing showing customer, order no, postcode & vat exempt. Loading. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. The concept of data blending is, for every match in the primary table there should be exactly one row item in your secondary table, in the view of this concept any aggregation on the secondary table will always be distinct by default. Hello Tableau world!! Am running into the strangest problem when data blending with V8. Does anyone know if there is a way around this or can you only create a blending whit datasources that were created the same way? I appreciate your help. No long-term contract. COUNTD is not possible with Secondary datasource at Tableau (BLENDING) , below is one of the workaround that I would like to share (Maybe there are Many * Many ) I got one query at Tableau forum recently & below is based on the same . It has data from 2003-2012. I am blending 2 data sets by employee id and when i am trying to group a field from the primary database, it is showing me below error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. If I remove the blend, I cannot use/filter the secondary data source, and If I use the blend, it will display only the values for the first data source, but not from the second one, excluding. We use three kinds of cookies on our websites: required, functional, and advertising. I am blending dates in the secondary data source to dates from the primary source and looking to get a distinct count of the customer code from the secondary data source. From what I understand, it's because the link variable must be present in the view, or else it does not work. See Join Your Data for more information. Data from secondary data sources must always be aggregated in calculations. . So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. Hi Data Modeler , I have an idea which I cannot test right away. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). We cannot use ATTR if trying to create an LOD type calculation if blending data sources. Blending requires primary and secondary data sources. The date values must be in the same format. There is a possibility that the values can be restricted from the secondary data. I have 2 published datasource and i think i cannot perform JOIN, LOD and COUNTD. To the Data pane, umschaltung in this [name of secondary data source] data source, real click at lowest one link icon to blend that data sources. "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" I have tried the following calculations but have not been able to figure this out. Think of this layer as the Relationships canvas in the Data Source page. From my primary data source I have a measure in rows, say 'Measure, which is 'distinct count of Pol Number' or 'sum of Premium' depending on a boolean parameter's values (TRUE or FALSE) The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Here is the sample. an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. In the Data pane, select the State data source (secondary). We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. I'm using a data blending method, where: Primary data source: Contains the ID I'm trying to count. Upvote Upvoted Remove Upvote Reply. Another way to approach this is to do a join of the data outside Tableau via a federated data source. Non-additive aggregates are generally not usable when a secondary dimension appears on any Shelf or there’s a linking dimension that is not in the view. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Both fields are linked in worksheet. They must be in the same format. 4. ×Sorry to interrupt. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . Blending takes place in the 6th step of the order of operation after the data table for the individual worksheet is set and the filters applied - data from the secondary source are aggregated at the level of the link and brought to the primary as. Expand Post. Right-click in the Data window and then. After blending, CountD works fine on primary datasource, but when I try to use CountD on secondary datasource tableau gives error: "Cannot blend secondary data source as one or more fields use an unsupported aggregation" Because of this, our overall. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. 1. Each has a joining field with the same name. Hi Andy, Following up on this - Tableau has been promoting the jump to relationships, in place of joins. [tier] == 2 'Top Vendors' else 'Mid Vendors'. ×Sorry to interrupt. The version I am working with 10. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . amount into the view, it gives me the correct sum. e. You cannot change that. I have two data sources and I have blended them together. Hi. However, when the linking dimension is not in the view, non-additive aLoading. Upvote. In a blend, the secondary data source can only contribute aggregated values using the level of detail defined by the linking fields that appear in the view, so when you remove them, the. In this source create a calculated field to pull out the KMs on the date of oil change. One data source has some values, the other one has different values. The secondary data source consists of 1 Fact table (Agg_ActualVsExpected) and 4 Dim tables, one of the Dim tables is Dim_Service, whose primary key is Service_Id, which appears also in the Fact table. This can restrict many values from the secondary data source. Common warnings and errors when blending data sources No relationship to the primary data source. See the attached updated workbook. I have two data sets that are linked across Date and Product Category fields. Thank you . So you don't get in the case of data blending. What does this mean? I want to create a city filter and apply it both to the SAS data source as well as the pivoted CSV file. So, to do Data Blending, the steps that I would suggest would be: - Connect to the data sources that you need to use. 0, but I imagine someone has been able to identify what is causing the issue. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. - Dataset 1, records the amount spent on ads as "Cost". . For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. The blend applies to that worksheet only. You can choose whether functional and advertising cookies apply. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. 3) COUNTD with Secondary DS (Blending) Thanks,. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. 1) Duplicate the field in primary datasource. Tableau Desktop 2018. thanks. Resolution. No. I am trying to . It is important to understand which is the primary source, it can impact your view. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. We would like to show you a description here but the site won’t allow us. Aggregate the date fields at the MY. I'm blending the 2 data sources by Service_Id. This is a new complexity in Tableau v8: In v7 and earlier, to blend we had to have the linked dimensions in the view, i. We use three kinds of cookies on our websites: required, functional, and advertising. SandhyaData from the secondary data source (via a data blend) can never be a dimension. Does the. The data source with the KMs is the primary source. ×Sorry to interrupt. I am trying to create a waffle chart. CSS ErrorBy default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. But seems we cannot blend 2 secondary data source with same field. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. Hello Everyone, I am using one data source which is a LIVE connection and I have duplicated same data source , the reason behind duplication is i want to have total of category which will be constant and it will not. All three options are demonstrated in the attached workbook using the sample data set Superstore. 3 and I have created aggregates AGG for fields from data extract and excel file. Some examples include: cookies used to. How to tackle “Cannot blend the secondary data source because one or more fields use an… How to tackle “Cannot blend the secondary data source because one or more fields use an unsupported aggregation” while blending Multiple data sources. Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable reimagined No DVR space limits. g. My problem happens when I go to the dashboard, I want to filter on FW (fiscal week) and have crosstab. Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. I was now trying to use both calculations you did on a different sheet through data blending. Primary and Secondary sources in data blending. I am trying to use the measures name filter functionality with two data sources. If you want to filter data across secondary data sources, consider the following alternatives: Join tables that are in the same data source, instead of blending them. Alternate names:. Final Words. Tableau Desktop Resolution Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. Fields from the secondary data source used in the view have an orange check mark. I read that this is not possible. I have a Remaining Value calculation, but it is not correct. For example, when I try and pull in Cost per Order (cost coming from one source, and Orders coming from another) I get the "Cannot blend the secondary data source because one or more fields use and unsupported aggregation. In the secondary data source, select Data > Create Calculated Field. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Click oLoading. One of the Dimension which is part of the Relationship between Primary and Secondary Data Source is being used in Filter and the same field cannot be displayed in Report as it changes the Level of grain of the reportIm using two data source to develop the workbook. A Level of Detail (LOD) expression is being taken from the secondary data source. Now, in dashboard D1 : has two worksheets W1 and W2. I'm trying to create a frequency distribution as a percent of total for individual products in a single category on one chart, then dual axis a second chart with the frequency distribution of the category for comparison purposes. FIXED ID, WEEK: CountD (accounts)). In the data window, the blue tick indicates the Primary data source (Sales in the image below). Filter each of the data sources independently on the more granular dimensions. While using blending data source some of the function doesn't perform well in calculation like COUNTD(), LOD{}, MEDIAN() etc. Tableau v8 added a new style of data blending (DB2) where the linking field does not have to be in the view. Why are values from the secondary data source not appearing in a blended data source view? They did not exist in the primary data source. I am just trying to filter every Data source, by choosing a field that every Data source has. Resolution. , it's difficult to determine; however, what you could do is click on each data source and if you see a chain link that is solid and not broken where fields might be related/blended in the tables below, then click the icon to unlink it. Complex as the problem may be, the solution is comfortingly simple. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. In short, Tableau connects to multiple data sources, sends independent queries to those data sources, and then combines (or “blends”) the aggregated results of the independent queries on a single worksheet. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). Click oField cannot breathe used from the [name by secondary data source] data original, because there is no mixed relationship to the primary data original. (It is a field that contains account names (company) in the sample data. Set up the primary and. When blending in Tableau, there is always a primary source and a secondary data source. Last week I’d promised to explain why the solution for identifying whether All items in a Tableau Quick Filter were selected wouldn’t work under certain circumstances in Tableau version 8, here it. Observations : 1. Because data blending is an ad-hoc LEFT join that aggregates data from the secondary data source, Tableau cannot always perform aggregations that require the full domain. The solution. CustomOverall (Primary) 2. In this example, Superstore Sales is the primary data source and Coffee Chain is the secondary data source. 3. I can add to filters from the data extracts. When trying to use COUNTD() it gives this error: cannot blend secondary data source because one or more fields use an unsupported aggregation when hovering over the Measures because it is now red. Using existing secondary data sources can save researchers time and resources by providing access to pre-existing data that has already been collected and organized. The condition is offer status = hired, but offer status can contain my different response types. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. Data blending is a method for combining data from multiple sources. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). To fix this, we had to add the fields being used in the blending relationship onto the view: Aside from a few of these, we didn’t need to combine the data in very complicated ways. In your 2nd and 3rd data sources. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. From my primary data source I have a dimension in columns say 'Customer Segment'. Ambiente. LOD calculation and blended data sources. Just aggregates (like SUM, MIN, MAX. Can anybody please help me with a solution. We are blending two data sources. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The success of BI projects depends on an organization's choice of BI solutions and the vendor’s ability to deliver relatively rapid and successful implementations, along with supportive. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. 2 came the introduction of a brand-new data model. To blend on summary data, you can do the following: Create a. Option 2: Create a calculation for a more dynamic sort. ” Causes and Workarounds for a Blending Limitation Errors 1. if you have blended data sources you can not use lods One of the drawbacks of blended sources . 4, I tried to blend products (secondary) to storefront (primary) based on Sku. like below . In the Data pane, switch to the [name of secondary data source] data source, and click at least one link icon to blend these data. Instead, publish each data source separately (to the same server) and then blend the published data sources. Twb, . I can get all the fields into the view apart from the 'is vat exempt'. Fee". I am trying to blend the same data against the other because I wanted to show Same Period last Year. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. When I create an additional calculated field in the primary data source with: COUNTD(Person ID) + COUNTD(Person ID), I receive the cannot blend the secondary data source because. However, some days will have entries for "Cost" but not for "Proj. Required cookies are necessary for basic website functionality. Here is situation I am facing, I have blended two data sources and created a worksheet. I have two data sources which I have blended together on two fields: branch and date. Input cannot become used from the [name are secondary data source] data source, because there is no blend relationship to the primary data source. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported aggregation listed above in the cube database itself before using in Tableau Desktop. If you want to filter data across secondary data sources, consider the following alternatives: Join tables that are in the same data source, instead of blending them. Hey all, I'm trying to create a filter in my dashboard such as my two spreadsheets are linked with this filter. - Dataset 1, records the amount spent on ads as "Cost" - Dataset 2 records the revenue generated by orders as "Proj. According to Tableau, this error can also appear when using a LOD expression in a blended view. Upvote Upvoted Remove Upvote Reply. Hi All! I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary) BI Cube Data 1 pc. I noticed there was an issue using Data Blend from 3 different source. If you create a quick filter on a field from data source 1 and apply this quick filter to. Expand Post. [% age]>=SUM([Percentage]) . Another sheet:W2 is created with Data source A - taking Role in Row shelf. Instead, the. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. For more information, see Use Relationships for Multi-table Data Analysis. Become a Better Analyst in Just 5 Minutes a Week. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. duplicate the date field. When I calculate the average of a measure and use the filter, it works perfectly fine. Data sources can contain logical tables not be used as secondary data sources for data blending. I would like to visualize number of distinct hardware. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". AUMTable (Secondary) 3. FIXED requires that you have row-level access to the rows in the secondary source. Error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". How ever # no of changes and # of Problems are calculating entire database values. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. order_date = B. Russell Christopher (Member) 10 years ago. To blend on summary data, you can do the following: Create a. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. If multiple logical tables are related in a Tableau data source that source cannot be used as the secondary data source in a Tableau data blend, it can only be used as the primary Therefore one workaround is the Create Primary Group function that you described which "copies" the field from B into A as a group. I am able to achieve the desired results but I am getting a warning ' Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". Now the nightmare starts: when I try to add the data source B and make all the relationships, it gives me the lovely error: "Cannot blend the secondary data source because one or more fields use the ZN function, which cannot be computed locally. In the Data pane, select the Store - North data source. Data blending is a method for combining data from multiple sources. From what I understand, it's because the link variable must be present in the view, or else it does not work. I've attached my workbook that contains 2 data sources that are blended by invoice number. A COUNTD of Order ID should be all I need to show this data but it always results in a "Cannot blend the secondary data source because one or more of the fields use an unsupported aggregation". Loading. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". Open. CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. However, it gives me following error: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation"We have an enterprise data source that is an SSAS Tabular model. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The primary data source will be identified automatically from any metrics you put on the worksheet first.