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 (47)
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...
RE: Error: Information is needed in order to combine data
This error is still active!
RE: Error: Information is needed in order to combine data
we need this issue resolved now.
RE: Error: Information is needed in order to combine data
This does not seem to be resolved - still experiencing the same issue.