Error While Deploying the SSAS Tabular Model 2019 "We don't support the option 'Implementation'"

[Suhel_Ansari]

Hi All,

I have created SSAS Tabular cube\model solution using the SharePoint Excel as data source I am able to table within the visual studio it works absolutely fine moreover I can refresh and pull the new data within the SSAS solution however when I try to deploy the solution to SSAS Instance 2019 it get the below error and I am unable to deploy it, please assist me with this issue. Thanks
SSAS Server Instance: SQL Server 2019 with “1500 Compatibility”
SSAS Cube\Model: SSAS 2019 with “1500 Compatibility Level”

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

Regards
Suhel

[v-kelly-msft]

Hi @Suhel_Ansari ,

I doubt you should post here.

I find a related thread,hope it could help:

https://docs.microsoft.com/en-us/answers/questions/82234/data-source-ssas-database-into-ssas-tabular...

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[Suhel_Ansari]

@v-kelly-msft , do we have another Forum for Power Query where we can post our Qustion, I did try the above solution without any success.

Regards

Suhel

[v-kelly-msft · Accepted solution]

Hi  @Suhel_Ansari ,

Seems a SSAS related issue,check below link:

https://www.sqlteam.com/forumshttps://www.sqlteam.com/forums

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[Suhel_Ansari]

@v-kelly-msft  , Thanks I have logged a case with Microsoft Tech Team. 

Thanks