Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Sergii24
Super User
Super User

Dataset with DirectQuery is not showing new measures and tables after refresh

Hi all, 

I have 2 workspaces:

  • Workspace "A" with Dataset "01" and report "01"
  • Workspace "B" with Dataset "100" and report "100"

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!

4 REPLIES 4
CharbelArmaleh
Resolver II
Resolver II

Hello,

Can you try to check the lineage 

CharbelArmaleh_0-1692719651527.png

 

just to double check the source of the  Dataset "100"

 

Regards

 

I had to hide some values, but the schema is the same:

Sergii24_0-1692720885962.png

 

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.