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

[Anonymous]

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.

here is my Manage Relationships:

[v-stephen-msft · Accepted solution]

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:

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]

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 🙂

[Anonymous]

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

[TheoC]

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