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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

ERROR: his is not allowed for columns on the one side of a many-to-one relationship or for columns..

my BI is working fine as far as the desktop version goes.

 

but I cant seem to refresh it from the website or schedule an auto-refresh without getting this error.

 

mfa_0-1633993019276.png

here is my Manage Relationships:

 

mfa_1-1633993069053.pngmfa_2-1633993084317.pngmfa_3-1633993107002.png

 

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @Anonymous ,

 

Power BI sometimes automatically creates relationships between the queries used to drive the data in a report. When I have encountered this error or similar errors in the past, I.

1.Go to Manage Relationships
2.Verify that a relationship is listed
3.Evaluate the from and to relationships that are listed as active
4.Remove any invalid "from" and "to" relationships between independent data sets

 

The most common issue I have had in the past is that I will have two very different queries pulling data from different sources with similar column names and Power BI will create an invalid relationship between them. After removing that relationship, it always solved my problem.

 

If you want to avoid this issue next time, uncheck below settings in the option:

11.png

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

View solution in original post

4 REPLIES 4
v-stephen-msft
Community Support
Community Support

Hi @Anonymous ,

 

Power BI sometimes automatically creates relationships between the queries used to drive the data in a report. When I have encountered this error or similar errors in the past, I.

1.Go to Manage Relationships
2.Verify that a relationship is listed
3.Evaluate the from and to relationships that are listed as active
4.Remove any invalid "from" and "to" relationships between independent data sets

 

The most common issue I have had in the past is that I will have two very different queries pulling data from different sources with similar column names and Power BI will create an invalid relationship between them. After removing that relationship, it always solved my problem.

 

If you want to avoid this issue next time, uncheck below settings in the option:

11.png

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

TheoC
Super User
Super User

Hi @Anonymous, 

 

The error is saying that the JobTitleDimTbl has a Job Title column that contains the same value more than once.  Given that the Job Title column is a "primary key" and that a primary key should only have unique values (i.e. values that appear only once), it is returning a Data Source Error.

 

If you require the Job Title column to have the same value appear more than once, I would recommend changing the duplicate to include a 1 or 2 at the end of the Job Title.  For example, if your duplicate is Job Title = "Chief Executive Officer" and you need two specific roles with this title, you can change these to Chief Executive Officer 1 and Chief Executive Officer 2.  

 

Alternatively, if the Job Titles are unique and only one value for each Job Title should exist, then you can:

  1. Go to Power Query
  2. Click on the column Job Title in the JobTitleDimTbl query.
  3. Right click, and click on "Remove Duplicates"

Hope this helps 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Anonymous
Not applicable

this is my Job Table

 

Job Title

Driver
Mechanical Assistant
Mechanic
Fleet Coordinator
The representative of bank transactions
Maintenance & Warehouse Supervisor
Accountant
Government Relations Supervisor
Key Accounts Manager
Billing Supervisor
Billing Coordinator
Government Relations Representative
Help-Desk Coordinator
Yard Controller
Security Guard
Electrician
Chief Accountant
Personnel Manager
-
Fleet Controller
Maintenance Purchasing Agent
Cleaner
HR Supervisor
Security & Safety Supervisor
Compound Coordinator
Insurance Controller
Warehouse Coordinator
Vehicle Washer
Maintenance Coordinator
Maintenance Controller
Car Electrician
Benchery
Treasurer
Account Sales Manager
Purchases Representative
Acting Fleet Supervisor
HR Manager
Internal Audit Manager
Procurement Supervisor
Administrative Services Specialist
Public Relations
HR Specialist
Accountant Assistant
CEO
Business development Manager
Shared Services Director
Marketing & Sales Manager
Facilities Coordinator
Learning & Development Manager
Collector
Finance Manager
COO
Smith
Project & Operational Excellence Manager
Acting Finance Manager
Quality Specialist
Yard Coordinator
Official Archive
Business Application Development Supervisor
Acting SHEQ & Driver Relations Manager
Managing Director
Finance Director
Head Of Quality ,Health, Safety & Environment,
Operations Director
IT Manager
Commercial Director
Transformation Director
Sales administrative
Finance Analyst
Maintenance Manager
Control Tower Supervisor
Talent Acquisition & Employee Engagement Specialist
Customer Services Representative
Operational Excellence Specialist
Outsource Operator
Transportation Operator
AR & AP Manager
HR Admin
Planning Engineer
Store Keeper Helper
Purchasing Manager
Facilities Manager
HR Director
Mechanic Helper
Electrician Helper

 

it has no duplicates

Hi @Anonymous,

 

The error that you presented implied "Yard Controller" was listed twice.  If it's not there, it may have to do with the "-" which is in the list. Is there a reason you have or need that in the list?

 

Thanks,

Theo

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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