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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
FatemaRangwala
Regular Visitor

Power BI Service query reference relationship error

Hi PowerBI Community,

 

I am facing some weird error in powerbi service which is not shown up in powerbi desktop.

 

While selecting the value from the district slicer in power bi service it throws the below error which is not visible in powerbi desktop:

 

Error fetching data for this visual:

The query referenced a relationship between '<oii>Bank</oii>'[<oii>SD</oii>] and '<oii>SD</oii>'[<oii>SD</oii>], which depends on a column that is not in a valid state.

Can anyone please help?

Thanks in advance!

2 ACCEPTED SOLUTIONS
BhavinVyas3003
Super User
Super User

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.


Thanks,
Bhavin
Problem solved? Hit “Accept as Solution” and high-five me with a Kudos! Others will thank you later!

View solution in original post

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

View solution in original post

7 REPLIES 7
BhavinVyas3003
Super User
Super User

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.


Thanks,
Bhavin
Problem solved? Hit “Accept as Solution” and high-five me with a Kudos! Others will thank you later!

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.

Hi @FatemaRangwala,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Harshitha.

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

Hi @FatemaRangwala,
Thank you for follow up

Sometimes older versions can cause unexpected issues. You can download the latest version from the   Microsoft Power Bi Desktop or The Microsoft Store 

Open Power BI Desktop, go to File > Options and settings > Options, then under Global > Data Load, click on Clear Cache.

If you had connected to the data earlier with different or expired credentials, it may cause problems. Go to File > Options and settings > Data source settings, then click on Clear Permissions.
Please find the attached official Document  for your reference.
 Troubleshoot Power BI Desktop publishing - Power BI | Microsoft Learn

Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Best Regards,
Harshitha.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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