Webinar (on-demand): OutSystems and Analytics Integration: A New Strategy to Reduce Costs

Discover everything you need to know about Hubway Connect

Try the product online without any installation or purchase commitment
Hubway Connect

Innovative ways to leverage your data for business outcomes

Find out how Hubway Connect can help you get more value from your OutSystems platform
Hubway Connect

Learn and expand your Hubway Connect knowledge

Deep dive in articles, videos and technical information to maximise its use
Hubway Connect

Start free and expand without surprises

Choose the Hubway Connect offer that best meets your needs and suits your budget
Hubway Connect

We are here to help. Let’s talk.

Connect with us via your preferred channel and we will be happy to answer your questions
Hubway Connect
  1. Home
  2. Knowledge Base
  3. FAQs
  4. Data Analysis
  5. Power BI establishes incorrect relationships between Entities. What do I do?

Power BI establishes incorrect relationships between Entities. What do I do?

When you consume the OData service in PowerBI, we have noticed that Power BI may automatically assume relationships between different tables by default, which often is incorrect. We do not want Power BI to establish incorrect relationships between our Entities.

To disable this option, on Power BI Desktop, go to “File Options & Settings  Options”. From the dialogue box that appears, uncheck the option “Autodetect new relationships after data is loaded” option.

To define Entity relationships manually, click the “Manage Relationships” option from the top menu.

Click the “New” button from the above window to create a new relationship. In this window, select the first table from the dropdown list at the top and then click on the column name on which you want to implement the relationship. Similarly, from the second dropdown list, select the table and column name to implement a relationship between the two tables.

Finally, you need to specify the type of relationship via the cardinality dropdown list.

For more information, refer to this external link: Power BI Data Model Working with Relationships

Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support