Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

 

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 

v-qiuyu-msft
Community Support
Status changed to: Needs Info
 
rosponda57
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, 

 

 

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

 

Best Regards,
Qiuyun Yu