How to automate transferring descriptions in a Power BI dataset??

[PowerRon]

Hi all

Within a month we will publish our first Power BI dataset.

We have multiple dimension tables we use over and over again in multiple Power BI datasets, such as ‘payment agreement’, ‘currency’, ‘institution’.

Two questions:

1. How do we prevent that we have to type the descriptions (that you see when hover over) for these dimensions in every dataset?
2. Is there a quick way to create the descriptions in the dataset? For instance by writing all the attributes and their descriptions in an Excel, upload that Excel to Power BI and then some script automatically adds the descriptions to the attributes.

I am very eager to know

regards

Ron

[Anonymous]

Hi @PowerRon ,

Currently Power BI don't support this function(add the description for dataset automatically). There is one similar idea shared on Power BI Ideas , you can vote it up and add your comments there to improve Power BI on this feature.

On the other hand, please watch the following video and check whether that can be used as workaround.

Showing DAX Expressions When Using Power BI Datasets (Live)

Best Regards

[PowerRon]

Thnx @Anonymous 

will have a look at the video

regards

Rob

[PowerRon]

Thnx @amitchandak I am aware of that option. But if I am using dimensions in multiple datasets I have to do it over and over again. Isn't there a faster way?

regards
Ron

[amitchandak]

@PowerRon , As of now the way I am aware of in data model view. You have access to properties. You can select one column or measure and write the description