Data Source (SSAS database) into SSAS Tabular project

Question

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,

Answer 1

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 .

Answer 2

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