In Tabular Cube, can repoint an existing table to use a different data source connection type

Question

Hi,

Is it possible to repoint existing tables to a new data source type, without recreating them from scratch?
My Analysis services cube was upgraded from compatibility version 1200 to version 1400, which has a newer connection type called "Structure Data Source" supporting power query.

I currently have some tables using the traditional "ProviderDataSource" connection type (Marked 1) - Support only native query language
I would like to point them to "StructuredDataSource" connection type (Marked 2) - Supports Power Query

Answer 1

I figured out a solution, and here it is:

Objective: You want to repoint Table A to the new TDS connection type

Step 1: Import the same table ("TableA" in this case) using the new connection type and call it "TempA")

Step 2: Open the Model.bim in xml

Step 3: Withing the XML file, goto the partition tag of table TempA and copy it.

Step 4: Replace the partition tag in TableA with code copied from TempA