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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Eric7
Resolver II
Resolver II

Table.Combine() on tables from different services not supported?

Hi,

I have a Dataset "DS" in Power BI Service (Premium). This dataset contains a table "DS TABLE", which is calling M function Table.Combine(A, B)

where

A is a table with datasource = table in a Dataflow in Power BI Service (called "DF PBI")

B is a table with datasource = table in a Dataflow in Power Platform (called "DF PP").

 

When I refresh Dataset "DS" in Power BI Service (Premium), I get this error (every time):

 

Data source error:Information is needed in order to combine data;Information about a data source is required.. The exception was raised by the IDbCommand interface. Table: "DS TABLE".

 

When I refresh the Dataset "DS" in Power BI Desktop, I do not get any error.

 

Is this a bug or a limitation in the Power BI Service?

 

The workaround I use is to have a proxy dataflow "DF PROXY" in the Power BI Service calling Dataflow "DF PP" and let Dataset "DS" call table B from "DF PROXY" in the Table.Combine() instead of the the original one in "DF PP". At least this does not fail, but it sure adds complexity.

 

 

Eirik

 

 

 

1 REPLY 1
GilbertQ
Super User
Super User

Hi @Eric7 

 

Can you make sure that both tables have got their privacy settings set to NONE and try again?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors