{"id":24806,"date":"2018-08-23T08:30:33","date_gmt":"2018-08-23T08:30:33","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=24806"},"modified":"2018-09-11T16:37:46","modified_gmt":"2018-09-11T11:07:46","slug":"q-a-in-power-bi-desktop","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/","title":{"rendered":"Q &amp; A in Power BI Desktop for Regular Dialect Inquiries"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1801,&quot;href&quot;:&quot;https:\\\/\\\/docs.microsoft.com\\\/en-us\\\/power-bi\\\/desktop-qna-in-reports#add-missing-relationships&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20190802200131\\\/https:\\\/\\\/docs.microsoft.com\\\/en-us\\\/power-bi\\\/desktop-qna-in-reports&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 02:01:02&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-20 22:39:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-02 16:49:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-06 10:17:52&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-12 16:43:34&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-31 21:18:39&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-19 17:57:28&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-05 09:56:19&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-05 10:43:25&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-19 15:19:43&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-10 09:47:57&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-10 09:47:57&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<h2 class=\"western\">1. Objective<\/h2>\n<p>In our last tutorial, we discussed\u00a0<a href=\"https:\/\/data-flair.training\/blogs\/analytics-pane-in-power-bi\/\"><strong>Analytics Pane in Power BI<\/strong><\/a>. Today, in this Q &amp; A in Power BI Desktop Tutorial, we will learn how to add a missing relationship and rename tables and columns. Moreover, we will study how to fix incorrect data types and choose the data category for each date and geography column. At last, we will cover to normalize your model.<br \/>\nSo, let&#8217;s start Q &amp; A in Power BI Desktop Tutorial.<\/p>\n<div id=\"attachment_26289\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Q-A-in-Power-BI-Desktop-for-Regular-Dialect-Inquiries-01-1.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-26289\" class=\"wp-image-26289 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Q-A-in-Power-BI-Desktop-for-Regular-Dialect-Inquiries-01-1.jpg\" alt=\"Q &amp;amp; A in Power BI Desktop for Regular Dialect Inquiries\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Q-A-in-Power-BI-Desktop-for-Regular-Dialect-Inquiries-01-1.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Q-A-in-Power-BI-Desktop-for-Regular-Dialect-Inquiries-01-1-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Q-A-in-Power-BI-Desktop-for-Regular-Dialect-Inquiries-01-1-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Q-A-in-Power-BI-Desktop-for-Regular-Dialect-Inquiries-01-1-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Q-A-in-Power-BI-Desktop-for-Regular-Dialect-Inquiries-01-1-1024x536.jpg 1024w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-26289\" class=\"wp-caption-text\">Q &amp; A in Power BI Desktop for Regular Dialect Inquiries<\/p><\/div>\n<h2>2. Q &amp; A in Power BI Desktop<\/h2>\n<p>Utilizing regular expressions and common dialect to make inquiries of your data is ground-breaking. Considerably more intense is the point at which your data answers, which is the thing that Q &amp; A in Power BI Desktop gives you a chance to do.<br \/>\nTo empower Q &amp; A in <a href=\"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/\"><strong>Power BI Desktop<\/strong><\/a> to effectively translate the huge gathering of inquiries it&#8217;s equipped for reacting to, Power BI Q&amp;A must make suppositions about the model. In the event that the structure of your model doesn&#8217;t meet at least one of these suppositions, you&#8217;ll have to change your model. Those changes for Q&amp;A are similar best-rehearse enhancements for any model in Power BI, in any case, whether you utilize Q &amp; A in Power BI Desktop.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/\"><strong><em>Do you know How to Create Your Own Measures in Power BI Desktop<\/em><\/strong><\/a><br \/>\n<em><strong>Note &#8211;\u00a0<\/strong>Questions and answers <\/em>are<em> just accessible when working with a model that contains imported data. Live associations with SSAS and DirectQuery models are not bolstered. <\/em><br \/>\n<em><strong>Note &#8211;\u00a0<\/strong>Questions and answers require the accompanying C runtime refresh in case you&#8217;re utilizing a form of Windows before Windows 10. You can take a stab at introducing imperative updates from Windows Update or physically introduce the required part from Microsoft (KB2999226). https:\/\/support.microsoft.com\/en-us\/enable\/2999226\/to refresh for-widespread c-runtime-in-windows <\/em><br \/>\nIn the accompanying areas, we depict how to change your model so it functions admirably with Q &amp; A in Power BI Desktop.<\/p>\n<h2>3. Include Missing Connections<\/h2>\n<p>On the off chance that your model is missing connections between tables, neither Power BI reports nor Q&amp;A can translate how to join those tables on the off chance that you make an inquiry about them. Connections are the foundation of a decent model. For instance, you can&#8217;t request the &#8220;aggregate deals for Seattle clients&#8221;. If the connection between the requests table and the client&#8217;s table is absent. The accompanying pictures indicate you cases of a model that necessities work, and a model that is prepared for Q &amp; A in Power BI Desktop.<br \/>\nNeeds work<\/p>\n<div id=\"attachment_24848\" style=\"width: 798px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/power-bi-flow-email2-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24848\" class=\"wp-image-24848 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/power-bi-flow-email2-1.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"788\" height=\"182\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/power-bi-flow-email2-1.png 788w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/power-bi-flow-email2-1-150x35.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/power-bi-flow-email2-1-300x69.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/power-bi-flow-email2-1-768x177.png 768w\" sizes=\"auto, (max-width: 788px) 100vw, 788px\" \/><\/a><p id=\"caption-attachment-24848\" class=\"wp-caption-text\">Prepare Q &amp; A Power BI Desktop<\/p><\/div>\n<p>Prepared for Q &amp; A Power BI Desktop<\/p>\n<div id=\"attachment_24852\" style=\"width: 798px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/power-bi-flow-email2-2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24852\" class=\"wp-image-24852 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/power-bi-flow-email2-2.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"788\" height=\"182\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/power-bi-flow-email2-2.png 788w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/power-bi-flow-email2-2-150x35.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/power-bi-flow-email2-2-300x69.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/power-bi-flow-email2-2-768x177.png 768w\" sizes=\"auto, (max-width: 788px) 100vw, 788px\" \/><\/a><p id=\"caption-attachment-24852\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<p>Connections fit as a fiddle for Q &amp; A Power BI Desktop<\/p>\n<div id=\"attachment_24850\" style=\"width: 828px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_02.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24850\" class=\"wp-image-24850 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_02.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"818\" height=\"201\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_02.png 818w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_02-150x37.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_02-300x74.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_02-768x189.png 768w\" sizes=\"auto, (max-width: 818px) 100vw, 818px\" \/><\/a><p id=\"caption-attachment-24850\" class=\"wp-caption-text\">Connections fit as a fiddle for Q &amp; A Power BI Desktop<\/p><\/div>\n<p><em><a href=\"https:\/\/data-flair.training\/blogs\/microsoft-flow-and-power-bi\/\"><strong>Have a look at &#8211; Integration of Microsoft Flow and Power BI<\/strong><\/a><\/em><\/p>\n<h2>4. Rename Tables and Segments<\/h2>\n<p>The selection of tables and sections is essential for Q &amp; A in Power BI Desktop. For instance, on the off chance that you have a table named CustomerSummary that contains a rundown of your clients, you would need to make inquiries like &#8220;Rundown the client synopses in Chicago&#8221; instead of &#8220;Rundown the clients in Chicago&#8221;.<br \/>\nWhile Q &amp; A can do some essential word breaking and identification of plurals, Q &amp; A expect that your table and segment names precisely mirror their substance.<br \/>\nThink about another illustration. Envision you have a table named Headcount that contains first and last names and representative numbers, and you have another table named Employees that contains worker numbers, work numbers, and begin dates. While this may comprehend by individuals who know about the model, another person who asks &#8220;check the workers&#8221; will get a tally of the lines from the &#8220;Representatives&#8221; table, which is likely not what they had as a main priority, since that is a tally of each activity every worker has ever had. It would greatly improve to rename those tables to genuinely reflect what they contain.<br \/>\nNeeds work<\/p>\n<div id=\"attachment_24853\" style=\"width: 1009px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_03.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24853\" class=\"wp-image-24853 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_03.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"999\" height=\"209\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_03.png 999w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_03-150x31.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_03-300x63.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_03-768x161.png 768w\" sizes=\"auto, (max-width: 999px) 100vw, 999px\" \/><\/a><p id=\"caption-attachment-24853\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<p>Prepared for Q &amp; A Power BI Desktop<\/p>\n<div id=\"attachment_24855\" style=\"width: 1009px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_04.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24855\" class=\"wp-image-24855 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_04.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"999\" height=\"216\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_04.png 999w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_04-150x32.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_04-300x65.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_04-768x166.png 768w\" sizes=\"auto, (max-width: 999px) 100vw, 999px\" \/><\/a><p id=\"caption-attachment-24855\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<h2>5. Fix Mistaken Data Composes<\/h2>\n<p>Imported data can have off base data writes. Specifically, date and number sections that are foreign made as strings won&#8217;t decipher by Q &amp; A in Power BI Desktop as dates and numbers. You should ensure you select the right data to compose in your Power BI show.<\/p>\n<h2>6. Check year and Identifier Segments as Don&#8217;t Summarize<\/h2>\n<p>Power BI forcefully totals numeric segments of course, so addresses like &#8220;aggregate deals by year&#8221; can now and then outcome in a fabulous aggregate of offers close by a great aggregate of years. In the event that you have particular segments where you don&#8217;t need Power BI to show this conduct, set the Summarize By property on the section to Don&#8217;t Summarize. Be aware of year, month, day, and ID segments, as those sections, are the most incessant issues. Different segments that aren&#8217;t sensitive to a whole.<br \/>\n<em><strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-matrix-visual\/\">Let&#8217;s revise Power BI Matrix Visualization\u00a0in detail<\/a><\/strong><\/em><br \/>\nFor example, age could likewise profit by setting Summarize By to Don&#8217;t Summarize or to average. You&#8217;ll discover this setting in the Modeling tab.<\/p>\n<div id=\"attachment_24856\" style=\"width: 939px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_07.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24856\" class=\"wp-image-24856 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_07.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"929\" height=\"312\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_07.png 929w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_07-150x50.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_07-300x101.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_07-768x258.png 768w\" sizes=\"auto, (max-width: 929px) 100vw, 929px\" \/><\/a><p id=\"caption-attachment-24856\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<p>The Data Category gives extra semantic information about the substance of a segment past its data compose. For instance, a whole number section may be set apart as a Zip Code, a string segment may be set apart as a City, Country, Region, et cetera. This data is utilized by Q &amp; A in Power BI in two critical routes: For perception determination and for dialect predispositions.<br \/>\nIn the first place, Power BI Q &amp; A utilizes the Data Category data to help settle on decisions about what sort of visual show to utilize. For instance, it perceives that segments with a\u00a0date or time Data Categories are commonly a decent decision for the level pivot of a line outline or the play hub of an air pocket diagram. Also, it expects that outcomes containing sections with topographical Data Categories may look great on a guide.<br \/>\nSecond, Power BI Q &amp; A makes some informed conjectures about how clients are probably going to discuss date and geology sections, to enable it to comprehend certain kinds of inquiries. For instance, the &#8220;when&#8221; in &#8220;When was John Smith contracted?&#8221; is relatively sure to guide to a date section, and the &#8220;Dark coloured&#8221; in &#8220;Include clients Brown&#8221; will probably be a city than a hair shading.<\/p>\n<h2>7. Pick a Sort By Column for Important Sections<\/h2>\n<p>The Sort By Column property enables arranging on one section to naturally sort by an alternate segment. For instance, when you ask &#8220;sort clients by shirt estimate&#8221;, you presumably need your Shirt Size section to sort by the basic size number (XS, S, M, L, XL) instead of one after another in order (L, M, S, XL, XS).<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/filters-in-power-bi\/\">Do you know how many types of filters are available in Power BI?<\/a><\/strong><\/p>\n<h2>8. Standardize your Model<\/h2>\n<p>Rest guaranteed that we&#8217;re not recommending you have to reshape your whole model. In any case, there are sure structures that are just so troublesome that Power BI Q &amp; A wouldn&#8217;t deal with them well. In the event that you play out some essential standardization of the structure of your model, the ease of use of Power BI reports will increment fundamentally, as will the precision of Q &amp; A comes about.<br \/>\nThe general govern you ought to take after is this: Each remarkable &#8220;thing&#8221; the client discusses ought to be spoken to by precisely one model protest (table or section). Along these lines, if your clients discuss clients, there ought to be one client protest. Furthermore, if your clients discuss deals, there ought to be one deals protest. Sounds basic, isn&#8217;t that right? Contingent upon the state of the data you&#8217;re beginning with, it can be. There are rich data moulding capacities accessible in Query Editor on the off chance that you require them, while a significant number of the more clear changes can happen essentially utilizing estimations in the Power BI show.<br \/>\nThe accompanying areas contain some normal changes you may need to perform.<\/p>\n<h2>9. Make New Tables for Multi-Segment Elements<\/h2>\n<p>On the off chance that you have various sections that go about as a solitary particular unit inside a bigger table, those segments ought to be part out into their own table. For instance, on the off chance that you have a Contact Name, Contact Title, and Contact Phone section inside your Companies table, a superior outline has a different Contacts table to contain the Name, Title, and Phone and a connection back to the Companies table. That makes it essentially less demanding to make inquiries about contacts freely of inquiries regarding organizations for which they are the contact and enhances show adaptability.<br \/>\nNeeds work<\/p>\n<div id=\"attachment_24857\" style=\"width: 227px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_09.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24857\" class=\"wp-image-24857 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_09.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"217\" height=\"219\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_09.png 217w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_09-150x150.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_09-100x100.png 100w\" sizes=\"auto, (max-width: 217px) 100vw, 217px\" \/><\/a><p id=\"caption-attachment-24857\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<p>Prepared for Q &amp; A in Power BI Desktop.<\/p>\n<div id=\"attachment_24858\" style=\"width: 515px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_10.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24858\" class=\"wp-image-24858 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_10.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"505\" height=\"236\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_10.png 505w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_10-150x70.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_10-300x140.png 300w\" sizes=\"auto, (max-width: 505px) 100vw, 505px\" \/><\/a><p id=\"caption-attachment-24858\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<h3 class=\"western\">a. Turn to dispense with property packs<\/h3>\n<p>In the event that you have property sacks in your model, they ought to be rebuilt to have a solitary section for each property. Property sacks, while advantageous for overseeing huge quantities of properties, experience the ill effects of various characteristic constraints that neither Power BI reports nor Q&amp;A are intended to work around.<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-security\/\">Let&#8217;s discuss What is Dynamic Row-Level Security in Power BI?<\/a><\/strong><br \/>\nFor instance, consider a CustomerDemographics table with CustomerID, Property, and Value sections. Where each column speaks to an alternate property of the client (for cases, age, conjugal status, city, and so forth). By over-burdening the importance of the Value section in view of the substance of the Property segment, it ends up unthinkable for Q&amp;A to translate most questions which reference it. A basic inquiry, for example, &#8220;demonstrate the age of every client&#8221; may happen to work. Since it could translate as &#8220;demonstrate the clients and client socioeconomics where a property is an age&#8221;.<br \/>\nBe that as it may, the structure of the model just doesn&#8217;t bolster somewhat more mind-boggling questions like &#8220;normal time of clients in Chicago.&#8221; While clients who specifically creator Power BI reports can at times find sharp approaches to get the data they are searching for, Q &amp; A Power BI Desktop just works when every section has just a solitary importance.<br \/>\nNeeds work<\/p>\n<div id=\"attachment_24859\" style=\"width: 268px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_11.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24859\" class=\"wp-image-24859 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_11.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"258\" height=\"189\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_11.png 258w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_11-150x110.png 150w\" sizes=\"auto, (max-width: 258px) 100vw, 258px\" \/><\/a><p id=\"caption-attachment-24859\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<p>Prepared for Q &amp; A Power BI Desktop<\/p>\n<div id=\"attachment_24860\" style=\"width: 268px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_11-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24860\" class=\"wp-image-24860 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_11-1.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"258\" height=\"189\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_11-1.png 258w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_11-1-150x110.png 150w\" sizes=\"auto, (max-width: 258px) 100vw, 258px\" \/><\/a><p id=\"caption-attachment-24860\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<h3 class=\"western\">b. Association to dispose of apportioning<\/h3>\n<p>On the off chance that you&#8217;ve apportioned your data over a different table, or have turned qualities over numerous segments, various basic activities will be troublesome or unimaginable for your clients to accomplish. Look at first as a regular table apportioning: a Sales2000-2010 table and a Sales2011-2020 table. On the off chance that the greater part of your vital reports is limited to a particular decade. You could presumably abandon it thusly for Power BI reports. Nonetheless, the adaptability of Q &amp; A Power BI Desktop will lead your clients to anticipate that answers will question like &#8220;aggregate deals by year.&#8221; For this to work, you&#8217;ll have to the association the data into a solitary Power BI show table.<\/p>\n<div id=\"attachment_24861\" style=\"width: 568px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_13.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24861\" class=\"wp-image-24861 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_13.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"558\" height=\"81\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_13.png 558w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_13-150x22.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_13-300x44.png 300w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><\/a><p id=\"caption-attachment-24861\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<div id=\"attachment_24862\" style=\"width: 310px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_14.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24862\" class=\"wp-image-24862 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_14.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"300\" height=\"231\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_14.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_14-150x116.png 150w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-24862\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<p>Thus, consider a common rotated esteem segment: a BookTour table containing Author, Book, City1, City2, and City3 segments. With a structure, this way, even straightforward inquiries like &#8220;check books by city&#8221; can&#8217;t translate effectively. For this to work, you ought to make a different BookTourCities table. Which associations the city esteems into a solitary segment.<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/hyperlink-in-power-bi\/\">Follow this link to know about Hyperlink in Power BI in Dashboard &amp; Excel Power Pivot<\/a><\/strong><\/p>\n<h2>10. Split Arranged Segments<\/h2>\n<p>In the event that the source from which you&#8217;re bringing in your data contains designed segments, Power BI reports (and Q &amp; A Power BI Desktop) won&#8217;t reach inside the segment to parse its substance. So in the event that you have, for instance, a Full Address segment that contains the address, city and nation. You should likewise part it into Address, City and Country sections so your clients can question against them independently.<br \/>\nNeeds work<\/p>\n<div id=\"attachment_24863\" style=\"width: 367px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_15.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24863\" class=\"wp-image-24863 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_15.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"357\" height=\"96\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_15.png 357w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_15-150x40.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_15-300x81.png 300w\" sizes=\"auto, (max-width: 357px) 100vw, 357px\" \/><\/a><p id=\"caption-attachment-24863\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<p>Prepared for Q &amp; A Power BI Desktop<\/p>\n<div id=\"attachment_24866\" style=\"width: 568px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_16.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24866\" class=\"wp-image-24866 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_16.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"558\" height=\"84\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_16.png 558w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_16-150x23.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_16-300x45.png 300w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><\/a><p id=\"caption-attachment-24866\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<p>Essentially, on the off chance that you have any full name sections for a man. You&#8217;ll need to include First Name and Last Name segments, just on the off chance that somebody needs to make inquiries utilizing incomplete names.<\/p>\n<h3 class=\"western\">a. Make new tables for multi-esteem segments<\/h3>\n<p>Likewise, a comparative circumstance, if the source from which you&#8217;re bringing in your data contains multi-esteem segments, Power BI reports (and Q &amp; A Power BI Desktop) won&#8217;t reach inside the section to parse out the substance. Along these lines, on the off chance that you have. For instance, a Composer section that contains the names of various writers for a melody. You should part it into numerous columns in a different Composers table.<br \/>\nNeeds work<\/p>\n<div id=\"attachment_24867\" style=\"width: 334px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_18.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24867\" class=\"wp-image-24867 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_18.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"324\" height=\"319\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_18.png 324w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_18-150x148.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_18-300x295.png 300w\" sizes=\"auto, (max-width: 324px) 100vw, 324px\" \/><\/a><p id=\"caption-attachment-24867\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<h3 class=\"western\">b. Denormalize to wipe out idle connections<\/h3>\n<p>The one special case to the &#8220;standardization is better&#8221; control happens when there is in excess of one way to get starting with one table then onto the next. For instance, in the event that you have a Flights table with both SourceCityID and DestinationCityID sections. Every one of which identifies with the Cities table, one of those connections should set apart as inert. Since Q &amp; A Power BI Desktop can just utilize dynamic connections, you would not able to make inquiries about either source or goal, contingent upon which you picked. On the off chance that you rather denormalize the city name segments into the Flights table. You&#8217;ll have the capacity to make inquiries like: &#8220;list the flights for tomorrow with a source city of Seattle and a goal city of San Francisco.&#8221;<br \/>\nNeeds work<\/p>\n<div id=\"attachment_24869\" style=\"width: 584px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_19.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24869\" class=\"wp-image-24869 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_19.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"574\" height=\"218\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_19.png 574w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_19-150x57.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_19-300x114.png 300w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><\/a><p id=\"caption-attachment-24869\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<p>Prepared for Q &amp; A Power BI Desktop<\/p>\n<div id=\"attachment_24870\" style=\"width: 260px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_20-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24870\" class=\"wp-image-24870 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_20-1.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"250\" height=\"262\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_20-1.png 250w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_20-1-143x150.png 143w\" sizes=\"auto, (max-width: 250px) 100vw, 250px\" \/><\/a><p id=\"caption-attachment-24870\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<h3 class=\"western\">c. Add equivalent words to tables and segments<\/h3>\n<p>This progression applies particularly to Q &amp; A Power BI Desktop (and not to Power BI reports when all is said in done). Clients regularly have an assortment of terms they use to allude to a similar thing. For example, add up to deals, net deals, add up to net deals. Power BI&#8217;s model enables these equivalent words to add to tables and sections inside the model.<br \/>\nThis can be an imperative advance. Indeed, even with direct table and segment names, clients of Q&amp;A make inquiries utilizing the vocabulary that first comes to them, and are not browsing a predefined rundown of segments. The more sensible equivalent words you can include, the better your clients&#8217; experience will with your report. To include Synonyms, in Relationships see, select the Synonyms catch in the lace, has appeared in the accompanying picture.<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-kpi\/\">Read about How to Create Power BI Key Performance Indicator<\/a><\/strong><\/p>\n<div id=\"attachment_24871\" style=\"width: 647px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_21.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24871\" class=\"wp-image-24871 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_21.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"637\" height=\"334\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_21.png 637w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_21-150x79.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_21-300x157.png 300w\" sizes=\"auto, (max-width: 637px) 100vw, 637px\" \/><\/a><p id=\"caption-attachment-24871\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<p>The Synonyms field shows up on the correct side of Power BI Desktop. Where you can include your equivalent words, as appearing in the accompanying picture.<\/p>\n<div id=\"attachment_24872\" style=\"width: 276px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_22.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-24872\" class=\"wp-image-24872 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_22.png\" alt=\"Q &amp; A Power BI Desktop\" width=\"266\" height=\"274\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_22.png 266w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/desktop-qna_22-146x150.png 146w\" sizes=\"auto, (max-width: 266px) 100vw, 266px\" \/><\/a><p id=\"caption-attachment-24872\" class=\"wp-caption-text\">Q &amp; A Power BI Desktop<\/p><\/div>\n<p>Be cautious while including equivalent words, since adding a similar equivalent word to in excess of one section or table will present vagueness. Questions and answers use the setting where conceivable to pick between vague equivalent words. However, not all inquiries have an adequate setting. For instance, when your client asks &#8220;tally the clients&#8221;. On the off chance that you have three things with the equivalent word &#8220;client&#8221; in your model. They probably won&#8217;t find the solution they are searching for. In these cases, ensure the essential equivalent word is exceptional. As that is what utilize as a part of the rehashing. It can alarm the client to the vagueness, implying they should need to ask it in an unexpected way.<br \/>\nSo, this was all about\u00a0Q &amp; A Power BI Desktop Tutorial. Hope you like our explanation.<\/p>\n<h2>11. Conclusion<\/h2>\n<p>Hence, in this tutorial, we learned about Q &amp; A in Power BI Desktop, how to add a missing relationship and rename tables and columns. Moreover, we studied how to fix incorrect data types and choose the data category for each date and geography column. At last, we covered the normalize your model. Still, you have a query regarding Q &amp; A in Power BI Desktop, share with us!<br \/>\nRelated Topic &#8211; <strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-dax-basics\/\">Power BI DAX<\/a><\/strong><br \/>\n<strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/desktop-qna-in-reports#add-missing-relationships\">For reference<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Objective In our last tutorial, we discussed\u00a0Analytics Pane in Power BI. Today, in this Q &amp; A in Power BI Desktop Tutorial, we will learn how to add a missing relationship and rename&#46;&#46;&#46;<\/p>\n","protected":false},"author":5,"featured_media":26289,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[4725,6672,9682,10950,10951,11525,13201,13737],"class_list":["post-24806","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi","tag-fix-mistaken-data-composes","tag-include-missing-connections","tag-power-bi-desktop-q-a","tag-q-a-in-power-bi-desktop","tag-qa-in-power-bi-desktop","tag-rename-tables-and-segments","tag-split-arranged-segments","tag-standardize-your-model"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Q &amp; A in Power BI Desktop for Regular Dialect Inquiries - DataFlair<\/title>\n<meta name=\"description\" content=\"Q &amp; A in Power BI Desktop Tutorial - Add Missing Connections, Rename Tables &amp; Segments, Fix Mistaken Data Composes, Check year &amp; Identifier Segments\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Q &amp; A in Power BI Desktop for Regular Dialect Inquiries - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Q &amp; A in Power BI Desktop Tutorial - Add Missing Connections, Rename Tables &amp; Segments, Fix Mistaken Data Composes, Check year &amp; Identifier Segments\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-23T08:30:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-09-11T11:07:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Q-A-in-Power-BI-Desktop-for-Regular-Dialect-Inquiries-01-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Q &amp; A in Power BI Desktop for Regular Dialect Inquiries - DataFlair","description":"Q & A in Power BI Desktop Tutorial - Add Missing Connections, Rename Tables & Segments, Fix Mistaken Data Composes, Check year & Identifier Segments","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/","og_locale":"en_US","og_type":"article","og_title":"Q &amp; A in Power BI Desktop for Regular Dialect Inquiries - DataFlair","og_description":"Q & A in Power BI Desktop Tutorial - Add Missing Connections, Rename Tables & Segments, Fix Mistaken Data Composes, Check year & Identifier Segments","og_url":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-08-23T08:30:33+00:00","article_modified_time":"2018-09-11T11:07:46+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Q-A-in-Power-BI-Desktop-for-Regular-Dialect-Inquiries-01-1.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Q &amp; A in Power BI Desktop for Regular Dialect Inquiries","datePublished":"2018-08-23T08:30:33+00:00","dateModified":"2018-09-11T11:07:46+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/"},"wordCount":2969,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Q-A-in-Power-BI-Desktop-for-Regular-Dialect-Inquiries-01-1.jpg","keywords":["Fix Mistaken Data Composes","Include Missing Connections","Power BI Desktop Q &amp; A","Q &amp; A in Power BI Desktop","Q&amp;A in Power BI Desktop","Rename Tables and Segments","Split Arranged Segments","Standardize your Model"],"articleSection":["Power BI Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/","url":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/","name":"Q &amp; A in Power BI Desktop for Regular Dialect Inquiries - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Q-A-in-Power-BI-Desktop-for-Regular-Dialect-Inquiries-01-1.jpg","datePublished":"2018-08-23T08:30:33+00:00","dateModified":"2018-09-11T11:07:46+00:00","description":"Q & A in Power BI Desktop Tutorial - Add Missing Connections, Rename Tables & Segments, Fix Mistaken Data Composes, Check year & Identifier Segments","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Q-A-in-Power-BI-Desktop-for-Regular-Dialect-Inquiries-01-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Q-A-in-Power-BI-Desktop-for-Regular-Dialect-Inquiries-01-1.jpg","width":1200,"height":628,"caption":"Q &amp; A in Power BI Desktop for Regular Dialect Inquiries"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/q-a-in-power-bi-desktop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAS Foundation Tools Certifications","item":"https:\/\/data-flair.training\/blogs\/tag\/sas-foundation-tools-certifications\/"},{"@type":"ListItem","position":3,"name":"Q &amp; A in Power BI Desktop for Regular Dialect Inquiries"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/24806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=24806"}],"version-history":[{"count":3,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/24806\/revisions"}],"predecessor-version":[{"id":32212,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/24806\/revisions\/32212"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/26289"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=24806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=24806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=24806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}