<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[All About Power BI - Medium]]></title>
        <description><![CDATA[Everything you need to know in Power BI - Medium]]></description>
        <link>https://medium.com/all-about-power-bi?source=rss----6a7e9fc7dc98---4</link>
        <image>
            <url>https://cdn-images-1.medium.com/proxy/1*TGH72Nnw24QL3iV9IOm4VA.png</url>
            <title>All About Power BI - Medium</title>
            <link>https://medium.com/all-about-power-bi?source=rss----6a7e9fc7dc98---4</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 00:38:39 GMT</lastBuildDate>
        <atom:link href="https://medium.com/feed/all-about-power-bi" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Power BI — Navigation through relationships using DAX]]></title>
            <link>https://medium.com/all-about-power-bi/power-bi-navigation-through-relationships-using-dax-392c0256abef?source=rss----6a7e9fc7dc98---4</link>
            <guid isPermaLink="false">https://medium.com/p/392c0256abef</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[microsoft]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Nimai Ahluwalia]]></dc:creator>
            <pubDate>Fri, 09 Jun 2023 23:05:13 GMT</pubDate>
            <atom:updated>2022-08-02T01:38:00.876Z</atom:updated>
            <content:encoded><![CDATA[<h3>Power BI — Navigation through relationships using DAX</h3><p>I want this to be very short and effective.</p><p>We are all quite familiar with the Excel function called Lookups; nevertheless, to refresh your memory, watch the video below.</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fy8ygx1Zkcgs%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dy8ygx1Zkcgs&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fy8ygx1Zkcgs%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="640" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/4151b8c04d4fd7aa44f047f7085bb0fb/href">https://medium.com/media/4151b8c04d4fd7aa44f047f7085bb0fb/href</a></iframe><p>When designing a calculated column in Power BI, we can utilize the reference columns from that table to develop the logic. However, there are instances when we need to reference columns from other tables, which is only possible if those tables are related to one another.</p><p>We can use RELATED and RELATEDTABLE DAX functions to achieve the desired goal.</p><h3>RELATED FUNCTION</h3><p>Assume we want to calculate the Cost depending upon the Manufacturer Name in the sales table with the help of Product table as the name resides in it, where the relationship is from Product to Sales as One to Many. Here we will use Related as we want to access the 1-side of the relationship from the Many-side. It can travel to many chain to relationships.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/585/1*5WqTjKe0NX1kbkLijhJvOQ.png" /></figure><blockquote><strong>Adjusted_Cost_By_Manuf = IF (RELATED ( ‘Product’[Manufacturer] ) = “Tailspin Toys”, Sales[Unit Cost] * 0.5, Sales[Unit Cost])</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/403/1*b2VhPLSM4gF4j6gXsLhyYg.png" /></figure><h3>RELATEDTABLE FUNCTION</h3><p>As we saw above, there are ways to move from one to the many sides of a relationship. In the event that we need to move from the many to one side of a relationship, we will utilize relatedtable since it will produce a table with many rows in reference to a single row. The majority of the time, iterators like countx, sumx, etc , use relatedtable function</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/718/1*QkCZmoTHrI0FfE3FAsp4HA.png" /></figure><blockquote><strong>Product Category [NumOfProducts] = COUNTROWS ( RELATEDTABLE ( Product ) )</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/521/1*NDLkI9cSd93Af09YgDJH-Q.png" /></figure><p>At the end of the table, a calculated column that is not dynamic will be formed; nevertheless, we can construct a measure to make it dynamic.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/633/1*c_CX6RtBuiIZu88-6C86CQ.png" /></figure><p>Reference — The Definite Guide to DAX</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=392c0256abef" width="1" height="1" alt=""><hr><p><a href="https://medium.com/all-about-power-bi/power-bi-navigation-through-relationships-using-dax-392c0256abef">Power BI — Navigation through relationships using DAX</a> was originally published in <a href="https://medium.com/all-about-power-bi">All About Power BI</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Transactional Databases Vs Reporting Databases]]></title>
            <link>https://medium.com/all-about-power-bi/transactional-database-vs-reporting-databases-687ec8c25451?source=rss----6a7e9fc7dc98---4</link>
            <guid isPermaLink="false">https://medium.com/p/687ec8c25451</guid>
            <category><![CDATA[reporting]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[microsoft]]></category>
            <category><![CDATA[power-bi]]></category>
            <dc:creator><![CDATA[Nimai Ahluwalia]]></dc:creator>
            <pubDate>Sun, 04 Jun 2023 14:51:32 GMT</pubDate>
            <atom:updated>2023-05-28T10:15:32.101Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/704/1*02R3VDaY6_36V1l8X7ulng.png" /></figure><p>Do you think Transactional and Reporting databases/model are identical?</p><p>If you are working in a field of Data than database and reporting are a most likely word you hear in your day to day life, but have you ever thought the data which you see in your source or a Data warehouse and the database model created for your reporting both needs to be different.</p><p>Now you may be wondering, what is he saying because the Data stored in the form of tables with the existing relationships in the data warehouse will be same used for reporting, but if you see these both are two different systems with each of them having its own efficiency mechanisms.</p><p>Just Imagine if you have a Data warehouse with lots of historical data 📁which needs to be on the reporting layer📊 and to bring that in action you use a reporting tool for example <a href="https://medium.com/u/940e606ec51a">Microsoft</a> Power BI.</p><p>Lets see why these two types of databases needs to be different!!🙌</p><p><strong>Schemas —</strong> Now, the way how data stored in the data warehouse is completely different as it should be on the Power Bi model layer, for example if you have a snowflake architecture in your system which is not advisable to be used in Power BI because it is well suited for a star schema model deign ✔ rather than a snowflake hence when you should change the table structure from the source while you are using it on Power BI.</p><p><strong>Lookup tables — </strong>If you have lot of lookup tables in your transactional database, and which is not efficient to be used in Power BI/reporting database than you can either try merging them into one or less in number or you can get rid of them if they are not important for your reporting needs.</p><p><strong>Unwanted Data —</strong> If you have many columns in the table of your transactional database which is not required in your reporting database than they should not be pulled in as it will let to increase the size of the file and make the report slow.</p><p><strong>Fact Tables —</strong> Mainly the fact tables in the transactional database are long and fat which is obvious because that&#39;s what data warehouse is for, but while comparing with reporting databases it should be long and thin.</p><p>Hence the data in both of the database may be same but they should be designed and used differently as per the use case.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=687ec8c25451" width="1" height="1" alt=""><hr><p><a href="https://medium.com/all-about-power-bi/transactional-database-vs-reporting-databases-687ec8c25451">Transactional Databases Vs Reporting Databases</a> was originally published in <a href="https://medium.com/all-about-power-bi">All About Power BI</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Power BI for beginners!!]]></title>
            <link>https://medium.com/all-about-power-bi/power-bi-for-beginners-6977fbbbe124?source=rss----6a7e9fc7dc98---4</link>
            <guid isPermaLink="false">https://medium.com/p/6977fbbbe124</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[azure]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Nimai Ahluwalia]]></dc:creator>
            <pubDate>Thu, 25 Feb 2021 19:21:31 GMT</pubDate>
            <atom:updated>2021-02-25T19:17:25.129Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/756/1*uPFCojFmXJS69CFLb4FIgw.png" /></figure><p>I generally get a lot of questions regarding the basic and pre-requisites for the Power BI so I thought to list them down.</p><p>The main purpose of writing this to understand the advantages of Power BI and use them the most to improve your report performance and efficiency.</p><ol><li>Use a star schema while making your data model it helps Power BI and all the BI tools in the world for a better understanding and also the most important query performance which makes your report fast.</li><li>Include the data only relevant, I have seen many times people usually load the data which is not required which makes the report size large leading it to perform slower than usual.</li><li>Query folding is a very important and hot topic in today&#39;s era as it helps to query at the source side rather than performing all the operation on the Power BI.</li><li>Use Import mode if your data is not too large and now as composite models are available we can also use that to achieve certain scenarios.</li><li>When working with time intelligence it is always advised to create a separate date table for smooth functioning.</li><li>Try to use measures instead of creating calculated columns.</li><li>If you have to refresh your dataset and you don&#39;t want it to take hours to complete we can always use an incremental refresh as it is now available for pro users.</li><li>The relationship filter should be single direction vs bidirectional.</li><li>To understand better the basic architecture of your Power BI Service always view the workspaces and the report in the lineage view.</li><li>Each table should serve a specific purpose and include data (fact) and lookup (dim) tables.</li></ol><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6977fbbbe124" width="1" height="1" alt=""><hr><p><a href="https://medium.com/all-about-power-bi/power-bi-for-beginners-6977fbbbe124">Power BI for beginners!!</a> was originally published in <a href="https://medium.com/all-about-power-bi">All About Power BI</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Schedule Refresh Power BI dataset with Power Automate!]]></title>
            <link>https://medium.com/all-about-power-bi/schedule-refresh-power-bi-dataset-with-power-automate-b0af60f611f1?source=rss----6a7e9fc7dc98---4</link>
            <guid isPermaLink="false">https://medium.com/p/b0af60f611f1</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[microsoft]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[tricks]]></category>
            <category><![CDATA[power-automate]]></category>
            <dc:creator><![CDATA[Nimai Ahluwalia]]></dc:creator>
            <pubDate>Thu, 26 Nov 2020 20:57:12 GMT</pubDate>
            <atom:updated>2020-07-06T14:47:53.691Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/900/1*r1T-eLrzs4hCRZTuc6sqgg.png" /></figure><p>There are 2 ways from which we can refresh the Power BI dataset in the Power BI Service.</p><ol><li>Manual Refresh —</li></ol><p>Manual refresh is not always a good option when your data source is updated on a regular basis.</p><p>2. Schedule Refresh —</p><p>It overcomes the disadvantage of Manual Refresh where we can refresh the dataset at any given point of time as per our need!</p><p>In the above 2 cases, we require to configure various other things to make it on going like a Data Gateway, Pro Licence etc.</p><p>We can use Power Automate to refresh the dataset just like schedule refresh <strong>without paying</strong> for Pro Licence or Premium!</p><p>If we decide to pay for the Pro Licence we can only schedule refresh for 8 times a day and for Premium 48 times a day.</p><p>With the help of Power Automate, we can refresh the dataset multiple times in a day.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*lOK_GmNE4c7ijHAOqxkBCA.png" /></figure><p>Step 1. Select the Calander and create manual events in it like 50 times a day.</p><p>Step 2. Select the Workspace and the Dataset to be refreshed.</p><p>Step 3. As and when the event occurs in the calendar the dataset will be refreshed.</p><p>I have tested this and works fine for me!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Lb_RwlGyqf1tuyJ6lMt4-A.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b0af60f611f1" width="1" height="1" alt=""><hr><p><a href="https://medium.com/all-about-power-bi/schedule-refresh-power-bi-dataset-with-power-automate-b0af60f611f1">Schedule Refresh Power BI dataset with Power Automate!</a> was originally published in <a href="https://medium.com/all-about-power-bi">All About Power BI</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Setting up Power BI Subscriptions for External Users using Outlook Free.]]></title>
            <link>https://medium.com/all-about-power-bi/setting-up-power-bi-subscriptions-for-external-users-using-outlook-free-5ab5bd7a85d9?source=rss----6a7e9fc7dc98---4</link>
            <guid isPermaLink="false">https://medium.com/p/5ab5bd7a85d9</guid>
            <category><![CDATA[power-automate]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[outlook]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[microsoft]]></category>
            <dc:creator><![CDATA[Nimai Ahluwalia]]></dc:creator>
            <pubDate>Thu, 26 Nov 2020 20:56:41 GMT</pubDate>
            <atom:updated>2020-09-20T16:36:24.909Z</atom:updated>
            <content:encoded><![CDATA[<p>It’s never been easier to stay up-to-date on your most important dashboards and reports. Subscribe to report pages and dashboards that matter most to you, and Power BI will email a snapshot to your inbox. You tell Power BI how often you want to receive the emails: daily, weekly, or when the data refresh. You can even set a specific time for Power BI to send the emails or have it run now. In all, you can set up to 24 different subscriptions per report or dashboard.</p><p>How to subscribe to a Power BI report by <a href="https://medium.com/u/940e606ec51a">Microsoft</a>.</p><p><a href="https://docs.microsoft.com/en-us/power-bi/consumer/end-user-subscribe">Subscribe yourself to reports and dashboards - Power BI</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/653/1*7EVs2HmSCVBWWhxtNQLrVA.png" /></figure><p><strong>With Power Automate</strong></p><p>We can achieve the scenario with the help of Power Automate, but everyone is not familiar with Power Automate and its functionalities.</p><p>Here is the blog post by <a href="https://medium.com/u/d87718d1f210">BI Elite</a> which helps us to perform with the help of Power Automate.</p><p><a href="https://bielite.com/blog/setting-up-power-bi-subscriptions-for-external-users/">Setting up Power BI Subscriptions for External Users | BI Elite</a></p><p><strong>My main aim to create this blog is to overcome the disadvantage that we are facing while using Power Automate in this scenario, which is that we receive a Forwarded Email which eventually not up-to-the-mark as because we get a <em>FW:</em> Mark when we receive the email.</strong></p><p><strong>With Outlook</strong></p><p>Step 1: Create a Power BI Email subscription for yourself.</p><p>Step 2: We have to create a Rule in our outlook Account</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/809/1*0F-u-UVeXGdXfkeiI7SSrg.png" /></figure><p>Step 3: Then Select the below option and add the word from which you will receive an email from the Power BI as a Subject.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/515/1*jLVg_rf36WJ2iV93fPv2iQ.png" /></figure><p>Step 3: Then click on Next and select the below option so that the mail received from the desired subject will be re-directed to the other users as mentioned.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/511/1*-KiPUp1HMZKdT7yTI961YQ.png" /></figure><p><strong>Summary</strong></p><p>As soon as you receive an email from Power BI your rule will be triggered and the mail will be re-directed to the customers outside the organization for <strong>free </strong>which will look like as if Power BI has sent the mail to them.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5ab5bd7a85d9" width="1" height="1" alt=""><hr><p><a href="https://medium.com/all-about-power-bi/setting-up-power-bi-subscriptions-for-external-users-using-outlook-free-5ab5bd7a85d9">Setting up Power BI Subscriptions for External Users using Outlook Free.</a> was originally published in <a href="https://medium.com/all-about-power-bi">All About Power BI</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Unlimited Refresh in Power BI!!]]></title>
            <link>https://medium.com/all-about-power-bi/unlimited-refresh-in-power-bi-5d6f881912bf?source=rss----6a7e9fc7dc98---4</link>
            <guid isPermaLink="false">https://medium.com/p/5d6f881912bf</guid>
            <category><![CDATA[microsoft]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[azure]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[Nimai Ahluwalia]]></dc:creator>
            <pubDate>Thu, 26 Nov 2020 20:54:30 GMT</pubDate>
            <atom:updated>2020-11-26T20:52:30.449Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/160/1*rkAtI6WGbffEqvOYc8UoMg.png" /></figure><p>We all know that Power BI has certain limitations in terms of refreshes, 8 for Pro and 48 for Premium. We do want to get our dataset refreshed more than that right?</p><p>And this cannot be achieved by buying any licence but just using the REFRESH NOW API, only for <a href="https://medium.com/u/940e606ec51a">Microsoft</a> Power BI embedded and Premium. We had this feature in general availability long back ago but very few know about it so I thought to write on it.</p><p>Using the Refresh Now API, the limitation on the number of refreshes you can schedule per day is removed and instead, an unlimited number of refreshes can be triggered for each dataset.</p><p><strong>Note:</strong> The time of existing refresh is not expected to be shorter, so a new refresh of a dataset cannot start before the previous one finishes. Remember that your resource limitations do not change with the introduction of this API, so use these unlimited refreshes with caution and be careful not to overload your resources with unnecessary refreshes</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5d6f881912bf" width="1" height="1" alt=""><hr><p><a href="https://medium.com/all-about-power-bi/unlimited-refresh-in-power-bi-5d6f881912bf">Unlimited Refresh in Power BI!!</a> was originally published in <a href="https://medium.com/all-about-power-bi">All About Power BI</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Table Relationships in Power BI]]></title>
            <link>https://medium.com/all-about-power-bi/table-relationships-in-power-bi-fe1a7f8fae82?source=rss----6a7e9fc7dc98---4</link>
            <guid isPermaLink="false">https://medium.com/p/fe1a7f8fae82</guid>
            <category><![CDATA[cloud-computing]]></category>
            <category><![CDATA[microsoft]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[power-bi]]></category>
            <dc:creator><![CDATA[Nimai Ahluwalia]]></dc:creator>
            <pubDate>Fri, 03 Jul 2020 15:20:44 GMT</pubDate>
            <atom:updated>2020-08-11T08:11:44.583Z</atom:updated>
            <content:encoded><![CDATA[<p>As you all know relationships are important within the tables, without the proper relationships between tables we won’t be able to get meaningful insights or the related information from them.</p><p>Here I have used a normal image for the table relationships, where we can see that in power BI the A marked tab shows us the view of the tables and B mark as the relationships between the tables.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/795/0*JdnWipj0FG5BkM19" /></figure><p>The great thing about Power BI is that it auto-detects the relationships in the database and also allows us to create relationships.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/948/0*NSCUAsZtqzUjyAI3" /></figure><h3>Types of Relationships</h3><p>As we all know that Relationships play an important role in databases it is a medium where the tables are connected with each other.</p><p>One to One:</p><p>A row in table A can have only one matching row in table B, and vice versa.</p><p>This type of relationship is not much implemented and when it is used it is used for some specific purposes like security, it is one of the use-cases which can be implemented.</p><p>One to Many:</p><p>This is the most common relationship type. In this type of relationship, a row in table A can have many matching rows in table B, but a row in table B can have only one matching row in table A.</p><p>Many-to-Many:</p><p>In a many-to-many relationship, a row in table A can have many matching rows in table B, and vice versa.</p><p>A many-to-many relationship could be thought of as two one-to-many relationships, linked by an intermediary table.</p><p>The intermediary table is typically referred to as a “junction table” (also as a “cross-reference table”). This table is used to link the other two tables together.</p><p>One-One:</p><p>In a one-to-one relationship, one record in a table is associated with one and only one record in another table. For example, in a school database, each student has only one student ID, and each student ID is assigned to only one person.</p><h3>Why Relationships?</h3><ul><li>It helps us to maintain our database in an efficient manner.</li><li>We don’t require to assemble all the data in one table.</li><li>We don’t have to perform joins between the tables if there is a relationship made between them in context to Power BI.</li></ul><h3>Let’s talk about the relationships in Power BI!</h3><p>We can make any relationships between tables in Power BI nevertheless if they are functional or illogical.</p><p>Table 1 has no relationship with Tabe 2.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1012/0*qxjZTabm4WTojFmr" /></figure><p><em>Step 1:</em> To create the relationship we have to open the Manage relationships tab.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*WDzt-U0-TcyyWiNS" /></figure><p><em>Step 2: </em>Select two tables for the connection and the column from which we have to make the connection the advantage we get is that we do not require the 2 tables to have the same Column name but it should have the same Data Type.</p><p>We can change the cardinality(relationship) whenever we want.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/874/0*Az8X13gFaTriyJZB" /></figure><p>With bidirectional cross-filtering, report creators and data modellers now have more control over how they can apply filters when working with related tables. Bidirectional cross-filtering enables them to apply filters on <em>both</em> sides of a table relationship.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/882/0*N3SdVHt3MVzLG8Ar" /></figure><p><em>Step 3: </em>Click on the Ok when done and then it will reflect in the relationship tab of the database model.</p><p>The Arrow states that we can filter from both direction Table 1 and Table 2.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/799/0*8-HdCYyuYRlW2aco" /></figure><pre>Tip: Avoid making Many-Many relation it can result in duplicate values.</pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fe1a7f8fae82" width="1" height="1" alt=""><hr><p><a href="https://medium.com/all-about-power-bi/table-relationships-in-power-bi-fe1a7f8fae82">Table Relationships in Power BI</a> was originally published in <a href="https://medium.com/all-about-power-bi">All About Power BI</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>