Start a new report directly from the new home screen.

Advancing Forum Analytics at China Data
Post Reply
[email protected]
Posts: 96
Joined: Sun Dec 15, 2024 5:30 am

Start a new report directly from the new home screen.

Post by [email protected] »

Access reports of recommendations that we have selected.
Locate your most recent reports through quick access lists.
Deduplication rules for composite models in Power BI and Analysis Services datasets
To avoid confusion, it’s important to keep tables and measures in your model named differently. If you combine models from different sources in Power BI, you may find that you have duplicate table or measure names. Previously, when this happened, one of the tables or measures was renamed with a number. For example, if you had two sources with a table called “Customers,” one of them was called “Customer 2” in the resulting model. This could be problematic because you didn’t know which france telegram data source the “Customer 2” table belonged to. The same was true for measures: if you had two sources with a measure called “Total Sales,” one of them was called “Total Sales 2” in the final model.

But now, with the latest Power BI updates for October, you have more control over this. You can choose a rule to differentiate table or measure names from one source when they conflict with another source. You can prefix or suffix the names of tables, measures, or both with text. You can also decide whether you want to use that text only when there are duplicates or always. For example, if one of your sources is a marketing source and the other is a sales source, you can set a rule so that the “Customer” table in the marketing source is named “Customer (marketing).”

You will find this option in Settings when you connect the model to a Power BI dataset or an Analysis Services model: After making the connections and setting the rule, you will see in the list of fields the names “Customer” and “Customer (marketing)” according to the rule you have set.

Deduplication
Post Reply