Forum Discussion

abelanger's avatar
abelanger
New Member
2 years ago

Merge queries returning blank value - intermittent after refresh

Hello everyone,   I have an intermittent issue after a model refresh where table A is merged with table B using UserID, table A is showing Blank values under UserLogging while the data is there in ...
Need Help
abelanger's avatar
abelanger
New Member
2 years ago

PijushRoy I'm a little bit concerned as Table A is used to apply RLS and may have been used in merging with other queries. Any ideas why a sheduled refresh would cause this when a manual refresh in the PBI service works fine?

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi abelanger 
    When you are marging, please check Datatype in both table for specific column in PQ
    also check datatype in Power BI desktop for both column

    If A is your dim table, Use RLS on table A which can filter your fact table data means Table B