cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Grob Frequent Visitor
Frequent Visitor

[Unable to combine data] Accessing data sources that have privacy levels which cannot be used togeth

Hello,


After refreshing my data on Power BI Service, I got this message:


[Unable to combine data] Section1/datasource/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination. Table: datasource.


The request behind the report retreives data from OneDrive. There is a combination of two sources : .xlsx and .txt.

When I delete the .txt part, error dissapear; this part is:

Source2 = Csv.Document(Web.Contents("https://my.sharepoint.com/personal/xxx/xxx/Anomalies.txt"),
    [Delimiter=";", Columns=1, Encoding=1252, QuoteStyle=QuoteStyle.None]),

RemoveAnomalies_Source2 = Table.SelectRows(RenameColumn_Source1, each List.Contains(Table.ToList(Source2),
    [ID]) = false)


I have checked the option "Always ignore Privacy Level settings" in the "Privacy" option tab.


Do you know how to handle it?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: [Unable to combine data] Accessing data sources that have privacy levels which cannot be used to

Hi @Grob ,

 

This error is because of the privacy-level restrictions and the types of data sources you're using.

 

You can rebuild this data combination.

 

1.Duplicate the Existing Query, enter Query Editor, delete the other data query code, renamed the new query to "Duplicate query".

 

2.Modify the Existing Query, change the first several lines to the "Source = Duplicate query".

 

For more detail, you can refer to the link:https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/.

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

 

Best Regards,

Amy

 

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

1 REPLY 1
Community Support Team
Community Support Team

Re: [Unable to combine data] Accessing data sources that have privacy levels which cannot be used to

Hi @Grob ,

 

This error is because of the privacy-level restrictions and the types of data sources you're using.

 

You can rebuild this data combination.

 

1.Duplicate the Existing Query, enter Query Editor, delete the other data query code, renamed the new query to "Duplicate query".

 

2.Modify the Existing Query, change the first several lines to the "Source = Duplicate query".

 

For more detail, you can refer to the link:https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/.

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

 

Best Regards,

Amy

 

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 2,599 guests
Please welcome our newest community members: