Forum Discussion

ritanoori's avatar
ritanoori
Icon for Resolver I rankResolver I
5 years ago

Couldn't load the data for this visual

Hello everyone 

I need help pls. I have a report that is published to prem workspace with RLS. 

all visuals work fine when RLS is not filtered to any (Global), However, some visuals don't load when we have user access. 

I attached the error msg and the model. 

 

I guess the issue is between "Fact TMS reports" and "Bdg_SH_Shipment" cross filter direction set to be both (Not sure) However, it was the only way to do a recon between Fact GL and Fact TMS reports by Shipment number. 

 

Bdg SH_Number is 

Bdg_SH_number = DISTINCT(SUMMARIZE('Fact_TMS_reports','Fact_TMS_reports'[SHIPMENT_NUMBER]))
 
Appreciate your thoughts, solutions and notes. Error

2 Replies