Andreas Munch, Skill AS on 25 Sep 2015 19:30:03
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.
Administrator on 27 Apr 2016 00:11:58
This has been fixed.
- Comments (50)
RE: Error: Information is needed in order to combine data
Please fix this issue !
RE: Error: Information is needed in order to combine data
Facing the same issue, "Information is needed in order to combine data Table". This is impacting our critical reporting refreshes. Any updates?
RE: Error: Information is needed in order to combine data
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
RE: Error: Information is needed in order to combine data
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
RE: Error: Information is needed in order to combine data
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,
RE: Error: Information is needed in order to combine data
same issue with the PBI gateway
RE: Error: Information is needed in order to combine data
Still unable to refresh reports with merged queries in PBI Gateway. Desktop works fine. Please resolve.
RE: Error: Information is needed in order to combine data
Still experiencing this issue
RE: Error: Information is needed in order to combine data
This error is still active.I'm trying to combine Azure SQLDB and Excel.
RE: Error: Information is needed in order to combine data
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...