Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Power BI publisher for Excel does not maintain relationships between tables

Dear BI mates,


When we connect to the data from power BI in the power BI publisher for Excel, we obtain a connection containing all the tables and measures that we created in the power BI dataset but all the relationships between tables are deleted.

Therefore it is very difficult to create proper tables or visualizations in excel with that data. Is there any way of creating those relationships after the connections has been made? Hence by uploading that connection to the excel data model or so.


Thank you very much for your help in advance

Regular Visitor

I have the same problem and there is no information about it online..

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors