cancel
Showing results for 
Search instead for 
Did you mean: 

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

 

 

Status: Needs Info
Comments
Moderator

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. 

 

q3.PNG

 

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 

Moderator
Status changed to: Needs Info
 
Frequent Visitor

Thanks’ for interest,

 

Here’s the test:

Privilage settings on PowerBI Desktop:

 

powerbi_problem.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

After refresh on PowerBI Desktop:

powerbi_problem2.png

 

 

 

 

 

 

 

 

After publish and refresh on PowerBI.com
powerbi_problem3.png

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,
Robert Golik, 

 

 

Moderator

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