Odata and Table.Combine, error on powerbi.com

[rosponda57]

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”

[v-qiuyu-msft]

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 

[rosponda57]

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]

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-...

Best Regards,
Qiuyun Yu