question

AbhaySudhakaran-7972 avatar image
1 Vote"
AbhaySudhakaran-7972 asked HimanshuSinha-MSFT commented

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

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.

89549-ds-cube.png

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


power-query-not-supportedazure-analysis-services
ds-cube.png (7.1 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @AbhaySudhakaran-7972 ,
Thanks for the ask and using the Microsoft Q&A platform .
At this time, we are reaching out to the internal team to get some help on this . We will update you once we hear back from them.
Thanks
Himanshu

2 Votes 2 ·

1 Answer

AbhaySudhakaran-7972 avatar image
0 Votes"
AbhaySudhakaran-7972 answered HimanshuSinha-MSFT commented

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
90823-image.png

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
90842-image.png








image.png (17.2 KiB)
image.png (23.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @AbhaySudhakaran-7972 ,
It was great to know that you were able to get to a resolution . We expect you to keep using this forum and also motivate others to do that same . You can always help other community members by answering to their queries .
Thanks
Himanshu

0 Votes 0 ·