Forum Discussion
Power BI Service query reference relationship error
In Power BI Desktop, check Bank[SD] and SD[SD] for:
- Nulls → Replace or remove them
- Data type mismatch → Ensure both are the same (e.g., text)
Check if RLS roles are active and unintentionally filtering the SD table.
Republish the report after fixing.
Hi Har**bleep**ha,
Issue was resolved when I replaced blank values with NA but when again the dataset was refreshed issue was there again and in the dataset 1 table is in the directquery mode.
Thanks,
Fatema
In Power BI Desktop, check Bank[SD] and SD[SD] for:
- Nulls → Replace or remove them
- Data type mismatch → Ensure both are the same (e.g., text)
Check if RLS roles are active and unintentionally filtering the SD table.
Republish the report after fixing.
Hi FatemaRangwala ,
I would also take a moment to thank BhavinVyas3003 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please
I would also take a moment to thank @ , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please Accept it as a solution so that other community members can find it easily.
Thank you
Harshitha.
Hi FatemaRangwala,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You.
Harshitha.
Hi FatemaRangwala,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If any of the response has addressed your query, please Accept it as a solution so that other community members can find it easily.
Regards,
Harshitha.
