rosponda57's avatar
rosponda57
Frequent Visitor
8 years ago
Status:
Needs Info

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's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity 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 

  • rosponda57's avatar
    rosponda57
    Frequent 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,