Option 1: Join the data sources with a cross-database join instead of blending. While using blending data source some of the function doesn't perform well in calculation like COUNTD(), LOD{}, MEDIAN() etc. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. Also, data blending is useful for combining data from published. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. Instead, publish each data source separately (to the same server) and then blend the published data sources. To solve your issue you should ->go to Connections 2 , keep only facADP and remove all other relationships ->go to its physical layer (double click facADP)Two Data Sources A and B, one work sheet:W1 has used both this A and B to represent View. Note: If the geographic role does not exist in the primary data source, then it will be necessary to create the view with the data source that contains the geographic role as the primary data source. Even if I don't join the 2 data sources and just blend them by "Region" and "Store Name", I still get "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on dragging Total Utilized Money field into the view. But when I am trying to do that I am getting an errorThe issue comes when I try and add a metric that is an aggregate of the two different sources. ×Sorry to interrupt. please check the attached workbook. When blending in Tableau, there is always a primary source and a secondary data source. blending [cannot blend Measure Values from a secondary data source] -----> this approach failed . Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). 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. Before I check Date filters, I got this results. 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. The data are sorted, but each row only shows one month of data with the other five columns blank. 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. If you make sheet 1 as the primary data source and do the data blending with sheet 2. The data is blended on customer. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. I'm trying to show a distinct count of claims by branch. Resolution. 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. Upvote Upvoted Remove Upvote Reply. See Join your Data for instructions. Data blending works only as a left join. Expand Post Using TableauThe secondary data source is indicated with an orange check mark on the data source and an orange bar down the side of the Data pane. In data blending, there is a primary data source and a secondary data source. Even if I don't join the 2 data sources and just blend them by "Region" and "Store Name", I still get "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on dragging Total Utilized Money field into the view. Expand Post. 4. with blends, we are only able to support aggregates (like SUM, MIN, MAX. when I use A as primary data source and drag A. General Information. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. 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. 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. As we know the link cant be established unless we use this common dimension (Region Filter) in the view, we can mimic the view by adding the Region Filter Dimension to rows/Columns shelf and uncheck the show header. ”. One small workaround which you can do is: 1) Create a calculation as {Max([Date])} 2) Create a parameter as follows: 3) Create a calculation as . Think of this layer as the Relationships canvas in the Data Source page. You can read details here: Logical Tables in Secondary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Resolution. Dominic Laird(Member) 5 years ago. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. CustomOverall (Primary) 2. Loading. you are blending the 2 excel data sources - blending takes place after the structure for data table for the worksheet has been established - and that is done as you bring dimensions to the rows and columns and apply filters to those dimensions - you will not be able to filter across data sources except at the link after that point💡 Ability to switch primary and secondary data sources. THEN add this total to the SUM of the projected_users from today's date through month X. I've read through the various posts on here, plus the general troubleshooting posts on the Tableau page on blending data, but can't find a solution. Now when I drag and drop the transaction data, everything works just fine, but if I try to use the "Add all Subtotals" option to get the AVG Transactions value for each Market then I am getting the dreaded "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on my worksheet when I change the "Total. In the past, I've just changed my primary table to the one with the calculation. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. This is the final step and will result in filtering between the blended data sources at your desired level of granularity. In the secondary data source, select Data > Create Calculated Field. How ever # no of changes and # of Problems are calculating entire database values. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . Not able to share for time being. From what I can tell, joining on Tableau Server Data Sources has been a requested feature for 6 years (Idea: Ability to join Tableau Server data sources). It has data from 2003-2012. Any help would be appreciated!Also a data blend is only a LEFT join. Case 2: If you are done with the dashboard development then create a empty extract and publish it on server and run the refresh so that data gets loaded. Fixed, countd functions won't work with the secondary datasources. Data of any sort coming from a secondary source must come as an aggregate of some sort. Data from a secondary source is displayed along with the primary source data. You cannot filter data across secondary data sources. This functionality was available in versions 8. unsupported aggregation. Final Words. 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". I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. 2 came the introduction of a brand-new data model. Instead, publish each data source separately (to the same server) and then blend the published data sources. Now try to recreate the sheet and link the 2nd and 3rd data. As you can see I have 2 different data sources using a blend on the blood type. you will get 5/22 date. "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. Primary Data Source: Contains a list of all employees and their role. While on a view, right click a data source, click replace data source. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. I've tried using COUNTD() ID First Last 1 Jim Carrey 1 Jim Carrey 2 Liam Neeson 3 Wynona Ryder COUNT([ID]) = 4 COUNTD([ID]) results in error I can add to filters from the data extracts. Overall LOD will show correct result in Primary datasource. I am trying to use the below formula instead of countd function because my data comes from Impala. Relationships: Join: Combines columns: Yes: Cross database joins will not work with all data sources: Joins: Blend: Combines columns: No: Fields from the secondary data source cannot be brought in to the view unless there is a match on. 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'm noticing you are using the Date field from the secondary data source you are working with. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. You can choose whether functional and advertising cookies apply. COUNTD is tough to work on while you. LOD will not work if it is from the secondary datasource. The data source with the KMs is the primary source. Fee" I want to plot Gross Profit (i. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. This means a data blend can’t be published as a data source for others to use. 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. the branch field I'm using from the primary data source. This is the response I received from Tableau Support:Cause. Data blending is a method for combining data from multiple sources. In this case the cross database join will effectively act like the. Mihai Constantinescu (Member) 6 years ago. 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. In the data window, the blue tick indicates the Primary data source (Sales in the image below). Instead of using relationships, double-click into your table to get to the. It's a technical limitation. AUMTable (Secondary) 3. Good morning . I've created the first chart with no problem, but I. When you data changes, you need to redo the. e. Unsupported aggregations in data blending Hello, I have a distributor dataset with product ships and returns (one report covering six months), and a retailer dataset with product retail sales and stock (covering the same six months but composed of. - Dataset 1, records the amount spent on ads as "Cost". Loading. Which version of Desktop are you using? See attached the superstore workbook (. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". Loading. I have two data sets: the first data set is a shp file from data. Cube (multidimensional) data sources have certain characteristics that make them unique in Tableau. But I cant add filter Month from the Budget Excel file. 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. Better collaboration. Pick the secondary data source in of Secondary data source pane. The date values you want to blend on must exist in both data sources. [OIL DATE]) THEN MIN ( [KMs]) END. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. Moreover, blending is a kind of left join, not exactly a join. Twb, . Does anyone have any Ideas how I can apply a universal filter to 5 different unrelated data sources? Applies to: Tableau Cloud, Tableau Desktop, Tableau Server. I am trying to blend the same data against the other because I wanted to show Same Period last Year. the branch field I'm using from the primary data source. A datetime field may be converted to a date field using a calculation to remove the time portion. . ” Causes and Workarounds for a Blending Limitation Errors. This feature would be really useful to ensure we can. ) So the issue is really the introduction of the group on the sheet. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. This happens only when the data sources are impala. I use the Opp ID to relate them. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I want to do a basic data listing showing customer, order no, postcode & vat exempt. Option 2: Create a calculation for a more dynamic sort. Hey all, I'm trying to create a filter in my dashboard such as my two spreadsheets are linked with this filter. This feature would be really useful to ensure we can. Regards. This would be a great time saver, with all of the calculations and linking changing as well. LOD calculation and blended data sources. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. I've attached my workbook that contains 2 data sources that are blended by invoice number. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. on Rows, Columns, Pages, or the Marks Card. ×Sorry to interrupt. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. I have 2 duplicate data sources that I am blending together (they are duplicate because I want to filter the same data source 2 different ways but show it in. 1. LOD will not work if it is from the secondary datasource. 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. Data blending is a method for combining data from multiple sources. I am creating a couple of formulas to display the total booking from the second data source to the first data source. thanks. Show moreA workbook or mock data would be a sure thing to comment and try upon it. As it turns out, I didn't actually end up using an LOD, but thought I might have to, hence the reason for JOINING the data together as shown in. I'm trying to show a distinct count of claims by branch. Marked as. 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 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. Does anyone have any Ideas how I can apply a universal filter. The order in which fields are used determines which data source is the primary versus the secondary data source. 3) COUNTD with Secondary DS (Blending) Thanks,. 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. Change the default sort order of the field using the various options, and then click OK. And I use Join data source, after divide measures / row duplicate. E make table 2 the primary. The version I am working with 10. 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. 2)Count Distinct from Secondary workaround. This can help researchers identify. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. If the user select May 2018. When you blend, you can only have aggregate access to the rows in the secondary source. The default view that you first see in the Data Source page canvas is the logical layer of the data source. Loading. month([date])=month(Parameter. . Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. I get a blank sheet on the dashboard using the secondary data source because it looks for CASE SENSITIVE ABC . One small workaround which you can do is: 1) Create a calculation as {Max([Date])} 2) Create a parameter as follows: 3) Create a calculation as . There's no way to "swap. Hi everyone, my first attempt to blend 2 data sets was not successful (Sheet called 1st attempt - attached), because its appears the following message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. "Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. Name: Distinct Count. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. I noticed there was an issue using Data Blend from 3 different source. So yes, in [Actual Hrs] you can only use the value from the secondary as an aggregate, and that's why you see: SUM([Networkdays (Test blend data calculation)]. I have two data sources and doing a data blend. This is indicated by the following icon: The view you are trying to build will function if you use the date from the primary data source (Shipped): Let us know if this is clear, or if more explanation is required! Cheers, TimothyCube data sources are used as primary data sources to blend data in Tableau and cannot be used as secondary data sources. " Expand Post. Change the default sort order of the field using the various options, and then click OK. I think I need to define the relationship between the data sources. Trying to do a COUNTD() from a secondary data source and got this dreaded error: 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 success, because apparently blending sucks and I shouldn't be using it. . Twbx and also the . 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. [% age]>=SUM([Percentage]) . Cannot blend the secondary data source because one or more fields use an unsupported aggregation. But I cant add filter Month from the Budget Excel file. AUMTable (Secondary) 3. Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. In the calculation dialog box, do the following: In the name text box, enter Sales for Store - South. I am trying to . The version I am working with 10. While on a view, right click a data source, click replace data source. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Now we have to use W2 as Filter - to filter out the data. 2. 3 and I have created aggregates AGG for fields from data extract and excel file. 1) Duplicate the field in primary datasource. Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. But I cannot for the life of me comprehend why the data blending would behave differently based solely on the chart type that was selected. This means that it forces the view to display only relevant data in the secondary data source. There is a possibility that the values can be restricted from the secondary data. Data. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. 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 data in the primary data source is the main data on which Tableau defines graphs and charts. In this source create a calculated field to pull out the KMs on the date of oil change. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. Input cannot become used from the [name are secondary data source] data source, because there is no blend relationship to the primary data source. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. 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. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. So the only way, it was possible was to connect one of the data sources with a calendar table joined with previous year and then blend it against the same data to get the Current Year and Same Period Last Year. 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. Primary and Secondary sources in data blending. You can create a federated database using linked tables/worksheets. FIXED requires that you have row-level access to the rows in the secondary source. In the secondary data source, select Data > Create Calculated Field. The default view that you first see in the Data Source page canvas is the logical layer of the data source. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). Make sure that you are blending on dimensions present in the view or on all of the. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . In your workbook sheet2 does not contain 5/22 date. IF min([Current Period ]) = true then [Display Sum Media Cost] end / sum(IF [Current Period ] = true then. 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. 3 and I have created aggregates AGG for fields from data extract and excel file. You will need a common column between the two tables in order to blend. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. An orange tick indicates a secondary data source (Promotions). This field works but when I want to add in my Fianl Dashboard I have this message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" Moreover my first and secondart data sources are linked by the "Sales ID", but this field is not displayed in the final Dashboard. 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. In this case the cross. I'm trying to blend two data sources on a single field, say 'Program Description'. 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. The. From what I understand, it's because the link variable must be present in the view, or else it does not work. 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. " I have seen a few posts on it and found an issue logged about it as far back as version 8. Secondary data source has Order Date represented as separate Year and Month fields. "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. The date values must be in the same format. LOD expressions are used when running complex queries with multiple dimensions at the data source level. Data blend is like a Left outer join. Alternate names:. Some examples include: cookies used to. 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. 2, users would define joins and unions between physical tables in which Tableau would create a singular, flat table for analysis. Community Manager update. 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. Then, after data blending, the final graph cannot show the data related to the South and East. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. 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. And I want to add one of the field from secondary dataset to be in the filter. Please check the attached workbook for details. In the Data window, right-click the relevant field. Functional cookies enhance functions, performance, and services on the website. Required cookies are necessary for basic website functionality. Hi, I have a scenario where I have to use Data Blending option to get certain metric values from Secondary Data Source. You have a nice example to use for filing a support case, and I recommend that you do that. I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. I can add to filters from the data extracts. order_date. Step 1: Create the Parameter. Hi Justin, Thanks for your quick reply. Instead, we need to publish the two data sources separately on the same server and then. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. You can create a federated database using linked tables/worksheets. Upvote Upvoted Remove Upvote Reply. 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. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). Solution in the image 📌 Non-additive aggregates from the primary data source 📌 Non-additive aggregates from the secondary data source 📌 Non-additive aggregates from a multi-connection. Here is the sample. You cannot change that. Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. I can add to filters from the data extracts. 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. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. drag the secondary measures to measure values section . However when I use B as primary data source, drag [A]. My problem happens when I go to the dashboard, I want to filter on FW (fiscal week) and have crosstab. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. Reference line -----> in this approach able to show sub-category items measures like sales and quantity totals as reference lines shown in below figure . When on the dashboard, click on the ‘Dashboard’ drop-down and select ‘Actions’. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. You combine data in the logical layer using relationships (or noodles). Status, Stage, etc). 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. The attached workbook and the following steps illustrate the process. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. Data blending is a method for combining data from multiple sources. 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. Also, after I get the total per PO Number, I want to get a remaining value that subtracts the Total Cost (from the secondary data source) from the Total per PO Number. Build whatever calculated fields from the secondary that need to be used in in the primary. Currently, I have to rebuild the worksheet and bring in the secondary source first. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. e. This is a dynamic way to make data in sets stand out and gain greater real-world context for users. [OIL DATE]) THEN MIN ( [KMs]) END. "Budget" is only contained in an Excel file data source. In the attached file, table shows the sum of sales and first order date correctly from both the. This is interesting. Expand Post. Advantages: Very easy to write and implement. However, when the linking dimension is not in the view, non-additive aLoading. while data blending is a great feature for exploratory analytics and data validation and incredibly useful to have as an extra tool when nothing else will meet the requirements I find that there's a tradeoff with added. Complex as the problem may be, the solution is comfortingly simple. Data & Connectivity. amount into the view, it gives me the correct sum. In the Data pane, switch until the [name of subsidiary datas source] data root, and click at least one link icon to blend these datas sourcing. So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. Unknown file type Total from Secondary Data Source. "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. 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 . That's probably your problem. Next, drag Category from the Orders data source onto the view, then select the Orders data source and click the chain icon to blend on Order ID. We don't get row-level data from secondary sources on a blend. Another way to approach this is to do a join of the data outside Tableau via a federated data source. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. ×Sorry to interrupt. If there is another. I. 1 Connected to Tableau Server as Main DS and Live Connection to an excel file as secundary DSStep 2: Bring summary data from the secondary data source into the primary data source. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. Calculates the number of distinct values of a field within a partition. Chicken + Choice of Drink1 pc. In the Data pane, select the Store - North data source. "Cannot blend aggregated data from the secondary data source with the data on this sheet because there are no linking fields used in the view. Become a Better Analyst in Just 5 Minutes a Week. I have two data sets that are linked across Date and Product Category fields. And I can't explain why it does that.