Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I have 2 workspaces:
My dataset "100" in workspace "B" is using dataset "01" from Workspace "A" as the only data source. The connection type between them is DirectQuery (I've verified it).
I added a new measure to Dataset "01" in PowerBI Desktop and replaced it on PBI Service (in workspace "A"):
Test = "Hello World!"
After that I went to the workspace "B" and refreshed dataset "100" (which is in a DirectQuery mode with Dataset "01"). I expected to find the new measure in dataset "100" but it's not there.
I did the same in PowerBI Desktop and it worked as expected: I see "Test" measure available immediatelly after refresh.
Instead of a measure I tried to add a calculated table but the result is the same: it works perfectly in desktop but not in PBI Service.
Am I doing something wrong? Is there any DirectQuery limitation I'm not aware of?
Thank you!
Hello,
Can you try to check the lineage
just to double check the source of the Dataset "100"
Regards
I had to hide some values, but the schema is the same:
one more thing to check, if you activated the composite mode on the Dataset "100" you will need to add the calculated table i think
try to click on get data --> Power BI dataset and select the table where the measure is
Regards
From PowerBI Desktop there is even no need to do so. Right after I refresh the report, all changes are immediately visible (new measure, new table, column etc.).
The issue I have is with the dataset "100" refresh in PowerBI Service: changes of the dataset "01" are not visible after refresh online.