Share via

Data Source (SSAS database) into SSAS Tabular project

Nayron Araújo 96 Reputation points
2020-08-31T17:18:17.697+00:00

Hello, I am trying to make an aggregated table in my tabular project where the source of this table will also be a table of a tabular model.
In summary, what I did was as follows: I created a MS Analysis Services database Data Source with a DAX query that will be the source for my new table.
When I'm on VS my solution works perfectly. I can see the data and work to leave this table in the standards of my model.
However, the problem arises only when I am going to deploy my solution.
It returns the error below:

Failed to save modifications to the server. Error returned: 'COM error: Microsoft.Data.Mashup; We cannot generate a query for the given data source reference. Failure reason: We don't support the 'Implementation' option.
Parameter name: Implementation ..
'.

Does anyone have any idea what this is about?
I'm using VS2017 and the SSAS extensions is updated. The compatibility mode I'm using is 1400. It is important to say, without this new data source, I can publish my solution successfully.

Best regards,

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,253 questions
0 comments
Accepted answer
  1. Nayron Araújo 96 Reputation points
    2020-09-09T14:31:18.767+00:00

    In my case I had to erase the entire line "Implementation" within connection string to Analysis Services Database in Model.bim.

    For more details look to the comments in interaction with LukasYu-msft .

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-09-01T06:15:53.437+00:00

    Hi,
    I tried to replicate the issue, that I import table from a Tabular Database to a new created 1400 Tabular Project. I have successfully processed and deployed the new created project and havenot meet the error as your mentioned above.

    This is an error that not very often occurs. Did you have column or parameter that is named as Implementation? Not quite clear what this refers to.
    I suggest you could try create a new 1400 test project and import the tabular datasource see if you could process and deploy with the new 1400 project. It could show us if this is a general issue with your environment or just within that particular project.

    Regards,
    Lukas