Odata and Table.Combine, error on powerbi.com
I’m trying to Combine two (or more) tables that are loaded from an odata source (with OData.Feed).
It works fine on PowerBI Desktop, but report published on "Powerbi.com" doesn't refresh.
Error on PowerBI.com is:
“Message Information is needed in order to combine data Table: Dziennik.”
Sources are:
Source named Dziennik00:
“let
Źródło = OData.Feed("https://odata.test.io/source0", null, [Implementation="2.0"]),
Dziennik_table = Źródło{[Name="Dziennik",Signature="table"]}[Data],
Data = Table.SelectColumns(Dziennik_table,{"IDDziennik"})
in
Data
”
Source named Dziennik01:
“let
Źródło = OData.Feed("https://odata. test.io/source1", null, [Implementation="2.0"]),
Dziennik_table = Źródło{[Name="Dziennik",Signature="table"]}[Data],
Daata = Table.SelectColumns(Dziennik_table,{"IDDziennik"})
in
Daata
“
Combined data source:
“let
Combine = Table.Combine({Dziennik00, Dziennik01})
in
Combine”
4 Comments
- v-qiuyu-msft
Community Support
Hi rosponda57,
I'm not able to reproduce the issue with the similar Power Query as yours. In your scenario, please refresh the same report in Power BI desktop to see if it can be refreshed successfully. Please check you have set Privacy Level for these two data sources, in my test, it's Organizational.
On Power BI service, as the dataset refresh is failed, please go to Refresh History, find this record, click Show button to see detail information, please share them with us.
Best Regards,
Qiuyun Yu - v-qiuyu-msft
Community Support
Status changed:NewtoNeeds Info - rosponda57Frequent Visitor
Thanks’ for interest,
Here’s the test:
Privilage settings on PowerBI Desktop:
After refresh on PowerBI Desktop:
After publish and refresh on PowerBI.com
Best Regards,
Robert Golik, - v-qiuyu-msft
Community Support
Hi rosponda57,
Do you configure the dataset on Power BI service use on-premise data gateway (personal mode)?
If it is, please enable fast combine for gateway personal mode then test again: https://docs.microsoft.com/en-us/power-bi/service-gateway-personal-mode#using-fast-combine-with-the-personal-gateway
Best Regards,
Qiuyun Yu