Changing measures, table names with dataset and report separated

[afbraga66]

Hello,

So I have two .pbix files. One file is the report the other is the dataset. The report is connected to the dataset via datahub. The issue I keep facing is that when I have to rename an existing measure or table, these changes do reflect on the model view in the report file, but not in the report view. This ends up in my having to recreate a new table, redo relationships, copy measures from on side to another (when it works). Why this happens? It is normal or am I doing something wrong? A task that should take like 5 minutes ends up taking 5 hours.

Thank you.

Best regards,

André

[afbraga66]

@Mikelyticsis there any expected change in this behaviour by Microsoft in the future?

Additionally, what is the real difference between datahub and direct query to dataset in the power bi service?

[Mikelytics]

Hi @afbraga66 

Regarding the plans of Microsoft I do not know.

Regarding the difference between datahub and dataset. From my understanding the data hub is only a place where you see the datasets where you have access to so that you can connect to them. So its no difference if you connect to a dataste via workspace or datahub from connection perspective.

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

[Mikelytics]

Hi @afbraga66 

While it can be good practice to split report and dataset in many cases the challenge you describe is the big disadvantage. So when the measure comes from the dataset then my knowledge you will need to do what you already described above. This is why you should only split report and dataset on stable datasets where measure and field names change very rarely.

BUT what you can do is to build measures on the report level which you then use in your report. but in this cases the measures on report level are not available for other reports using the same dataset.

I hope this helps.

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.