Hi everyone!
I've been experimenting with Datamarts and I'm unsure on how the updates that you make to more complex functionalities (like measures and releationships) work when building reports off the datamart, specially using PowerBI desktop.
Here are the basic steps of my test:
At first, I built a datamart with a simple table and a measure.
After that, I created a report directly from the datamart and saved it to my worskpace.
I downloaded the report and opened it in PowerBI desktop and everything showed OK, both table and measure.
After that, I added a new measure to the datamart. That's when I started seen differences. The local report wasn't able to get the new measure, but the one on the server did. I tried refreshing and closing and opening the report, it didn't help.
I tried publishing the local report (with a different name) but on the server the new measure also didn't show up.
This seemed to be the case also for releationships.
My theory is that as long as you build the report on the service, everything change you make to the datamart after it's creation affect the reports built directly on the service, but as soon as you download them as a PBIX file, any changes to releationships and measures made to the datamart won't update anymore.
I've looked around but couln't find an official anser on this, could anyone help me and direct me to any official article with an answer or explination on this?
Thank you all very much!
