sbatool's avatar
sbatool
Icon for Helper I rankHelper I
5 years ago
Status:
New

Effect of switching Data source from Development to Production in Composite Models

Hi,

I am using Power BI desktop Version: 2.91.701.0 64-bit (March 2021) and have tried direct query to two remote datasets. For example, dataset A (workspace X) and dataset B (workspace Y). I have noticed that the relationship between the datasets disappear as soon as I switch the data source for dataset A from workspace X to workspace Z.

Please note that dataset A in the workspace X is identical to the dataset A in the workspace Z. The reason we have published it twice in two different workspaces is due to the deployment life cycle process (development to production). So the workspace X is our development workspace and the workspace Z is the production one. 

I tested the relationship between the dataset A and dataset B (both getting data from development workspace dataflows). I then tried to edit data source setting for dataset A to point to the production workspace. All the relationship settings that I had made between the datasets previously were gone.

Below is the relationship settings I had before changing the data source for dataset A marked by red colour.

I then used the Data source setting window to pick the production dataset.

After changing the data source, previous relationships missing as shown below.

I would appreciate if this issue is fixed in the GA of the composite models.

Data Modeling

3 Comments

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    hi

    I have reported this issue internally, ICM: 233537835

    will update here once I get any information.

     

    Regards,

    Lin

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    hi

    PG found the root cause. When we go to sync the schema after the data source change, the updated query doesn't have the original name.

    Fix will be released in the June update of Power BI Desktop.

     

    Regards,

    Lin

  • pieterf's avatar
    pieterf
    Frequent Visitor
    5 years ago

    v-lili6-msft 

    Hi Lin,

    I have exactly the same problem. In response to your answer here I expected this issue to be resolved in the June update. Today I've tried this out; but actually I've got a new issue.

    When I change the connection (from by example develop-source to production-source). The message I receive is "Failed to save modifications to the server. Error returned: 'There are ambiguous paths between... <fact-table> and <dimension-table>".

    It seems that, by changing the connection, a new AAS-model is loaded. Actually, I expect here only a changed connection of the existing AAS-model.

Completed Ideas