Error: Information is needed in order to combine data

[andreas_munch]

I'm trying to combine two simple oData-feed from two different CRM-organisations with the "Table.Combine". It works with datasets from a single source, it works from two sources in Power BI Desktop, but i fails on app.powerbi.com. The error I get is "Information is needed in order to combine data". This is really essential for us if we can use Power BI.

[aaarmstee671]

we need this issue resolved now.

[dieter_decaluw2]

This is still an issue today, mind boggling, refresh works fine from pbi desktop but fails through gateway: Microsoft.Data.Mashup.MashupSecurityException.ReasonPrivacySetting Information is needed in order to combine data This is ridiculous as privacy is set to be ignored in all settings...

[d_filipyev]

This error is still active.I'm trying to combine Azure SQLDB and Excel.

[wruth1]

Still unable to refresh reports with merged queries in PBI Gateway. Desktop works fine. Please resolve.

[adonovan1]

Still experiencing this issue

[mimoune_djoual1]

same issue with the PBI gateway

[thomas_kreklin1]

Part 2: ***** Power BI Code **** Source = Table.FromRows(..) _bufferedSource = Table.Buffer(..), _bufferedRiskSnitt = Table.Buffer(..), _bufferedForsinkedeMilepæler = Table.Buffer(...), #"Added Risiko_Budsjett_Status" = Table.AddColumn( Source, "Risiko_Budsjett_Status", each "0"), #"Added Risiko_Fremdrift_Status" = Table.AddColumn(#"Added Risiko_Budsjett_Status", "Risiko_Fremdrift_Status", each "0"), #"Added Risiko_Kvalitet_Status" = Table.AddColumn(#"Added Risiko_Fremdrift_Status", "Risiko_Kvalitet_Status", each "0"), #"Added Risiko_Interesenter_Status" = Table.AddColumn(#"Added Risiko_Kvalitet_Status", "Risiko_Interessenter_Status", each "0"), #"Added Risiko_Omfang_Status" = Table.AddColumn(#"Added Risiko_Interesenter_Status", "Risiko_Omfang_Status", each "0"), #"Added Risiko_Annet_Status" = Table.AddColumn(#"Added Risiko_Omfang_Status", "Risiko_Annet_Status", each "0"), #"Added Fremdrift_Status" = Table.AddColumn(#"Added Risiko_Annet_Status", "Fremdrift_Status", each 0), #"Added AntallForsinkedeMilepæler" = Table.AddColumn(#"Added Fremdrift_Status", "ForsinkedeMilepæler", each 0), oppdater_kolonner = Table.FromRecords( Table.TransformRows(#"Added AntallForsinkedeMilepæler", (r) => Record.TransformFields( r, { {"Budsjett 2018", each List.Sum(Table.SelectRows(_bufferedSource, each r[Leveranse] = [Leveranse] and [Periode] = 201812)[Budsjettert])}, .. {"Risiko_Budsjett_Status", each Table.First(Table.SelectRows(_bufferedRiskSnitt , each [ProsjektId] = r[Leveranse] and [Kategori] = "Budsjett/Kost"))[RisikoScore]}, ... {"Fremdrift_Status", each Table.First(Table.SelectRows(Oppgaveliste, each [ProsjektId] = r[Leveranse] and Text.StartsWith([Tittel], "LEV-" & [ProsjektId])))[ForventetSlutt]}, .. {"ForsinkedeMilepæler", each Table.SelectRows(_bufferedForsinkedeMilepæler, each [ProsjektId] = r[Leveranse]){0}[AntallForsinkede]} }))), **** I have tried to fix the error m

[thomas_kreklin1]

Hi, I have been in touch with support about this error. For the sake of possible learning, I will add my latest comment to Microsoft support here. It is a detailed description of my case. Because of the length I have to split it in two parts. I try to include the code in **** PowerBi Code *** *********** tags, dont know how readable it will be. Her goes: Hi, I don’t feel that my incident is closed to my satisfaction. I will try to go through the problem in greater details from my point of view. I had a report running for a years time, on scheduled refresh in power bi service. The figure below shows the part of this report, where I also do a Record.TransformFields to update some column values. *Power BI Code* let Source = SharePoint.Tables("my url/", [ApiVersion = 15]), .....)]}[Items], ...some reordering, renaming of columns ec.. #"Added Risiko_Fremdrift_Status" = Table.AddColumn(#"Added Risiko_Budsjett_Status", "Risiko_Fremdrift_Status", each "0"), #"Added Risiko_Kvalitet_Status" = Table.AddColumn(#"Added Risiko_Fremdrift_Status", "Risiko_Kvalitet_Status", each "0"), #"Added Risiko_Interesenter_Status" = Table.AddColumn(#"Added Risiko_Kvalitet_Status", "Risiko_Interessenter_Status", each "0"), #"Added Risiko_Omfang_Status" = Table.AddColumn(#"Added Risiko_Interesenter_Status", "Risiko_Omfang_Status", each "0"), #"Added Risiko_Ukjent_Status" = Table.AddColumn(#"Added Risiko_Omfang_Status", "Risiko_Ukjent_Status", each "0"), #"Added Risiko_Annet_Status" = Table.AddColumn(#"Added Risiko_Ukjent_Status", "Risiko_Annet_Status", each "0"), #"Added Fremdrift_Status" = Table.AddColumn(#"Added Risiko_Annet_Status", "Fremdrift_Status", each 0), updating_status_fields = Table.FromRecords( Table.TransformRows(#"Added Fremdrift_Status", (r) => Record.TransformFields( r,

[mahimas]

Facing the same issue, "Information is needed in order to combine data Table". This is impacting our critical reporting refreshes. Any updates?

[matei_muntiu]

This is not fixed, and I have the June version of Desktop installed. Hide On demand ‎13‎/‎06‎/‎2019‎ ‎12‎:‎05‎:‎36 ‎13‎/‎06‎/‎2019‎ ‎12‎:‎05‎:‎41 Failed Unable to connect to the data source undefined. Underlying error code: -2147467259 Table: MyTable. Underlying error message: Information is needed in order to combine data DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SQL","path":";"},{"kind":"SQL","path":";"}] Microsoft.Data.Mashup.MashupSecurityException.Reason: PrivacySetting Cluster URI: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net Activity ID: b1919951-8977-4855-9366-140a09b64963 Request ID: 0911c8ba-f6b1-880e-0fa7-a2b68c6e58c5 Time: 2019-06-13 11:05:41Z