You can see in the Microsoft documentation that the Active Directory connector does not allow to use the direct query mode. We have use the import data mode.<\/p>\n\n\n\n
Furthermore, when linking several data sources of different technologies , it is recommended to avoid the direct query mode, your report will certainly behave with bad performances.<\/p>\n\n\n\n
Also, do not forget to choose the right Power BI Desktop client application depending where you want to publish your report. Power BI Desktop for publishing on Power BI Azure service and Power BI Desktop Report Server (Power BI Desktop RS) for publishing on Power BI Report Server.<\/p>\n\n\n\n
Active Directory data integration<\/h1>\n\n\n\n\n- Open Power BI Desktop <\/li>\n\n\n\n
- Click the Transform data ribbon to open the Power Query Editor<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png\")
<\/figure>\n\n\n\n\n- Create a new parameter\n
\n- Note: I always recommend to use parameter for your data source, it will ease your work, either to make a template or to change the connection in one place when you use the same data source in several queries<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Click the Manage Parameter ribbon and select New Parameter<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_03.png\")
<\/figure>\n\n\n\n\n- Create a new parameter by capturing a name, description, its type and define an initial value and click OK to validate.<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_04.png\")
<\/figure>\n\n\n\n\n- Click the New Source ribbon and select the More option to open the connector list<\/li>\n\n\n\n
- Search for the Active Directory connector and select it and click the connect button<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_02.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_05.png\")
<\/figure>\n\n\n\n\n- In the Active Directory setting window select the domain by selecting the parameter you created previously and click the OK button<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_06.png\")
<\/figure>\n\n\n\nAt this stage you are connected to the Active Directory service. You have to know where to find the data you need. For our example we will use the computer information and specifically the name of the servers and their descriptions.<\/p>\n\n\n\n
\n- Search for the Computer object in the Active Directory data structure, check its checkbox and click the OK button<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_07.png\")
<\/figure>\n\n\n\n\n- You notice that a new query is appearing on the left pane with the original object name<\/li>\n\n\n\n
- You can change the name of the query in the Query Settings pane on the right side of the window<\/li>\n\n\n\n
- You can also notice that in the APPLIED STEP information pane you have already 2 steps. The first for the source selection and the second for the object selection<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_08-1024x288.png\")
<\/figure>\n\n\n\n\n- Now to get the data we need, we select 2 columns. Select the column Computer than while pressing the CTRL key select the Top column.<\/li>\n\n\n\n
- Right click on one of the column you selected and select Remove other columns. This will avoid to have unnecessary information in your report later<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_09-1024x539.png\")
<\/figure>\n\n\n\n\n- Expand the Computer column to get to the data<\/li>\n\n\n\n
- Unselect the (Select All Columns) to only select the information you need<\/li>\n\n\n\n
- Select the checkbox of the cn info and click OK<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_10.png\")
<\/figure>\n\n\n\n\n- Do the same by expanding the Top column and selecting the Description column<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_11.png\")
<\/figure>\n\n\n\n\n- The description information being a list datatype, you need to expand a second time this information to get to the data<\/li>\n\n\n\n
- Expand the top.description column and the select the option Extract Values…<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_12.png\")
<\/figure>\n\n\n\n\n- In the window Extract the value from list I select None in the dropdown list as the description contains only 1 element in our case<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_13.png\")
<\/figure>\n\n\n\nWe have now our Computer information we need<\/p>\n\n\n\n
\n- Notice all the steps in the Apply Steps pane on the right<\/li>\n\n\n\n
- By clicking on the gear icon you can see the details of the action done in the step<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_14.png\")
<\/figure>\n\n\n\nSCCM Server information integration<\/h1>\n\n\n\n
The data source is this time a SQL Server Database. We will apply the same method to get to the data.<\/p>\n\n\n\n
\n- Create first the parameter for the server connection <\/li>\n\n\n\n
- Create a second parameter for the database name<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_15.png\")
<\/figure>\n\n\n\n\n- Defined a new source by selecting SQL Server <\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_16.png\")
<\/figure>\n\n\n\n\n- Choose the parameter your created previously for the server and database name<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_17.png\")
<\/figure>\n\n\n\n\n- Select an initial object to create the query with the SQL Server connector, but we will change it immediately and replace it by a custom query and click OK<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_18.png\")
<\/figure>\n\n\n\n\n- In the query settings change the name<\/li>\n\n\n\n
- Select the source in the steps and click the gear icon<\/li>\n\n\n\n
- In the SQL statement textbox write the query needed for the server selection on the SCCM database<\/li>\n\n\n\n
- Click OK<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_19.png\")
<\/figure>\n\n\n\n\n- You can now remove the Navigation step used for the object selection, it is no ore needed as we used a SQL Statement instead<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_20.png\")
<\/figure>\n\n\n\n\n- We are done with the data source selection and import, so click the Close & Apply ribbon to integrate your data in the Power BI report<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_21-1.png\")
<\/figure>\n\n\n\n\n- The data will be loaded in the report<\/li>\n\n\n\n
- In our case we have some error while loading the AD Computer info, due to the empty description on some servers<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_22.png\")
<\/figure>\n\n\n\nLink the data sources <\/h1>\n\n\n\n
Now that we have the data sources tables ready we can linked them<\/p>\n\n\n\n
\n- Select the Model designer mode on the left of the screen<\/li>\n\n\n\n
- Select the column computer.cn of the table AD_ComputerInfo, drag and drop it on the column Server_Name of the table ServerInfo. Automatically a 1:1 relationship will be determine<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_23.png\")
<\/figure>\n\n\n\nIt is good for the user experience to group the information of the same type at the same location. Thus we can integrate the server description column with the other server information available<\/p>\n\n\n\n
\n- Select the Data designer mode on the left of the screen<\/li>\n\n\n\n
- Select the Column tools in the menu<\/li>\n\n\n\n
- Select the New column ribbon<\/li>\n\n\n\n
- Write the DAX formula to get the related information from the other table and validate with the Enter key<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_24.png\")
<\/figure>\n\n\n\nTo avoid to confuse the report user with uneeded information, your can hide the AD_ComputerInfo table <\/p>\n\n\n\n
\n- go to the Model designer mode<\/li>\n\n\n\n
- Click on the eye icon to have it strikethrough<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_25.png\")
<\/figure>\n\n\n\nDesign your report<\/h1>\n\n\n\n
Now you can create you report and use the data you have integrated<\/p>\n\n\n\n
\n- go to the Report designer mode<\/li>\n\n\n\n
- Select the table visualization object<\/li>\n\n\n\n
- In the Values of the table visualization object drag and drop the Server_Name and Server_Description columns<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_26-1024x584.png\")
<\/figure>\n\n\n\nConclusion<\/h1>\n\n\n\n
This is of course only an introduction of what can be done with the Active Directory data integration into Power BI.<\/p>\n\n\n\n
There are plenty of possibilities to follow your operation and Active Directory data is part of it. <\/p>\n\n\n\n
The integration itself is pretty simple, the complexity you will face is to find the right information in the AD data structure.<\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction This documentation explains how to integrate Active Directory data in a Power BI report. It explains also how to link this data with another data source. To illustrate the method, we will integrate Active Directory Computer data and link it with SCCM Server information. We will only use 2 different data sources in this […]<\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[294,229,149],"tags":[1279,1490],"type_dbi":[],"class_list":["post-17957","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","category-database-administration-monitoring","category-security","tag-active-directory","tag-power-bi"],"acf":[],"yoast_head":"\n
Power BI - Active Directory data integration - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI - Active Directory data integration\" \/>\n<meta property=\"og:description\" content=\"Introduction This documentation explains how to integrate Active Directory data in a Power BI report. It explains also how to link this data with another data source. To illustrate the method, we will integrate Active Directory Computer data and link it with SCCM Server information. We will only use 2 different data sources in this […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-15T16:48:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-28T08:12:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png\" \/>\n<meta name=\"author\" content=\"Christophe Cosme\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christophe Cosme\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\"},\"author\":{\"name\":\"Christophe Cosme\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\"},\"headline\":\"Power BI – Active Directory data integration\",\"datePublished\":\"2022-07-15T16:48:50+00:00\",\"dateModified\":\"2022-11-28T08:12:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\"},\"wordCount\":1130,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png\",\"keywords\":[\"Active Directory\",\"Power BI\"],\"articleSection\":[\"Business Intelligence\",\"Database Administration & Monitoring\",\"Security\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\",\"name\":\"Power BI - Active Directory data integration - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png\",\"datePublished\":\"2022-07-15T16:48:50+00:00\",\"dateModified\":\"2022-11-28T08:12:39+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png\",\"width\":844,\"height\":321},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI – Active Directory data integration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\",\"name\":\"Christophe Cosme\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"caption\":\"Christophe Cosme\"},\"description\":\"Christophe Cosme has more than 22 years of experience in architecture, development and implementation of IT solutions including 17 years in the Business Intelligence area as well as 10 years of experience working with the Microsoft SQL Server Business Intelligence suite. His experience and qualifications cover project management, business analysis, functional and technical requirements. His expertise also includes the implementation of IT solutions in national as well as international organizations. Christophe Cosme is Expert in MS SQL Server DB Engine, SSIS, SSAS, SSRS and PowerBI. Prior to joining dbi services, Christophe Cosme was Solution Lead Business Intelligence Diabetes Care at Hoffmann-La-Roche Ltd in Basel . He also worked as Senior Manager Head of Business Intelligence for Swiss International Airlines Ltd. Christophe Cosme holds a Master's degree in Engineering, Automation from the IT\u2013 ENSISA (F). His branch-related experience covers pharmaceuticals, IT and the airline sector.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/christophe-cosme\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power BI - Active Directory data integration - dbi Blog","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:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/","og_locale":"en_US","og_type":"article","og_title":"Power BI - Active Directory data integration","og_description":"Introduction This documentation explains how to integrate Active Directory data in a Power BI report. It explains also how to link this data with another data source. To illustrate the method, we will integrate Active Directory Computer data and link it with SCCM Server information. We will only use 2 different data sources in this […]","og_url":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/","og_site_name":"dbi Blog","article_published_time":"2022-07-15T16:48:50+00:00","article_modified_time":"2022-11-28T08:12:39+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png","type":"","width":"","height":""}],"author":"Christophe Cosme","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christophe Cosme","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/"},"author":{"name":"Christophe Cosme","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a"},"headline":"Power BI – Active Directory data integration","datePublished":"2022-07-15T16:48:50+00:00","dateModified":"2022-11-28T08:12:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/"},"wordCount":1130,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png","keywords":["Active Directory","Power BI"],"articleSection":["Business Intelligence","Database Administration & Monitoring","Security"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/","url":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/","name":"Power BI - Active Directory data integration - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png","datePublished":"2022-07-15T16:48:50+00:00","dateModified":"2022-11-28T08:12:39+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png","width":844,"height":321},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Power BI – Active Directory data integration"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a","name":"Christophe Cosme","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","caption":"Christophe Cosme"},"description":"Christophe Cosme has more than 22 years of experience in architecture, development and implementation of IT solutions including 17 years in the Business Intelligence area as well as 10 years of experience working with the Microsoft SQL Server Business Intelligence suite. His experience and qualifications cover project management, business analysis, functional and technical requirements. His expertise also includes the implementation of IT solutions in national as well as international organizations. Christophe Cosme is Expert in MS SQL Server DB Engine, SSIS, SSAS, SSRS and PowerBI. Prior to joining dbi services, Christophe Cosme was Solution Lead Business Intelligence Diabetes Care at Hoffmann-La-Roche Ltd in Basel . He also worked as Senior Manager Head of Business Intelligence for Swiss International Airlines Ltd. Christophe Cosme holds a Master's degree in Engineering, Automation from the IT\u2013 ENSISA (F). His branch-related experience covers pharmaceuticals, IT and the airline sector.","url":"https:\/\/www.dbi-services.com\/blog\/author\/christophe-cosme\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=17957"}],"version-history":[{"count":5,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17957\/revisions"}],"predecessor-version":[{"id":20674,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17957\/revisions\/20674"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=17957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=17957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=17957"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=17957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/figure>\n\n\n\n- \n
- Create a new parameter\n
- \n
- Note: I always recommend to use parameter for your data source, it will ease your work, either to make a template or to change the connection in one place when you use the same data source in several queries<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Click the Manage Parameter ribbon and select New Parameter<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- Create a new parameter by capturing a name, description, its type and define an initial value and click OK to validate.<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- Click the New Source ribbon and select the More option to open the connector list<\/li>\n\n\n\n
- Search for the Active Directory connector and select it and click the connect button<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n<\/figure>\n\n\n\n
- \n
- In the Active Directory setting window select the domain by selecting the parameter you created previously and click the OK button<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
At this stage you are connected to the Active Directory service. You have to know where to find the data you need. For our example we will use the computer information and specifically the name of the servers and their descriptions.<\/p>\n\n\n\n
- \n
- Search for the Computer object in the Active Directory data structure, check its checkbox and click the OK button<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- You notice that a new query is appearing on the left pane with the original object name<\/li>\n\n\n\n
- You can change the name of the query in the Query Settings pane on the right side of the window<\/li>\n\n\n\n
- You can also notice that in the APPLIED STEP information pane you have already 2 steps. The first for the source selection and the second for the object selection<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- Now to get the data we need, we select 2 columns. Select the column Computer than while pressing the CTRL key select the Top column.<\/li>\n\n\n\n
- Right click on one of the column you selected and select Remove other columns. This will avoid to have unnecessary information in your report later<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- Expand the Computer column to get to the data<\/li>\n\n\n\n
- Unselect the (Select All Columns) to only select the information you need<\/li>\n\n\n\n
- Select the checkbox of the cn info and click OK<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- Do the same by expanding the Top column and selecting the Description column<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- The description information being a list datatype, you need to expand a second time this information to get to the data<\/li>\n\n\n\n
- Expand the top.description column and the select the option Extract Values…<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- In the window Extract the value from list I select None in the dropdown list as the description contains only 1 element in our case<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
We have now our Computer information we need<\/p>\n\n\n\n
- \n
- Notice all the steps in the Apply Steps pane on the right<\/li>\n\n\n\n
- By clicking on the gear icon you can see the details of the action done in the step<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
SCCM Server information integration<\/h1>\n\n\n\n
The data source is this time a SQL Server Database. We will apply the same method to get to the data.<\/p>\n\n\n\n
- \n
- Create first the parameter for the server connection <\/li>\n\n\n\n
- Create a second parameter for the database name<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- Defined a new source by selecting SQL Server <\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- Choose the parameter your created previously for the server and database name<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- Select an initial object to create the query with the SQL Server connector, but we will change it immediately and replace it by a custom query and click OK<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- In the query settings change the name<\/li>\n\n\n\n
- Select the source in the steps and click the gear icon<\/li>\n\n\n\n
- In the SQL statement textbox write the query needed for the server selection on the SCCM database<\/li>\n\n\n\n
- Click OK<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- You can now remove the Navigation step used for the object selection, it is no ore needed as we used a SQL Statement instead<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- We are done with the data source selection and import, so click the Close & Apply ribbon to integrate your data in the Power BI report<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
- \n
- The data will be loaded in the report<\/li>\n\n\n\n
- In our case we have some error while loading the AD Computer info, due to the empty description on some servers<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
Link the data sources <\/h1>\n\n\n\n
Now that we have the data sources tables ready we can linked them<\/p>\n\n\n\n
- \n
- Select the Model designer mode on the left of the screen<\/li>\n\n\n\n
- Select the column computer.cn of the table AD_ComputerInfo, drag and drop it on the column Server_Name of the table ServerInfo. Automatically a 1:1 relationship will be determine<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
It is good for the user experience to group the information of the same type at the same location. Thus we can integrate the server description column with the other server information available<\/p>\n\n\n\n
- \n
- Select the Data designer mode on the left of the screen<\/li>\n\n\n\n
- Select the Column tools in the menu<\/li>\n\n\n\n
- Select the New column ribbon<\/li>\n\n\n\n
- Write the DAX formula to get the related information from the other table and validate with the Enter key<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
To avoid to confuse the report user with uneeded information, your can hide the AD_ComputerInfo table <\/p>\n\n\n\n
- \n
- go to the Model designer mode<\/li>\n\n\n\n
- Click on the eye icon to have it strikethrough<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
Design your report<\/h1>\n\n\n\n
Now you can create you report and use the data you have integrated<\/p>\n\n\n\n
- \n
- go to the Report designer mode<\/li>\n\n\n\n
- Select the table visualization object<\/li>\n\n\n\n
- In the Values of the table visualization object drag and drop the Server_Name and Server_Description columns<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
Conclusion<\/h1>\n\n\n\n
This is of course only an introduction of what can be done with the Active Directory data integration into Power BI.<\/p>\n\n\n\n
There are plenty of possibilities to follow your operation and Active Directory data is part of it. <\/p>\n\n\n\n
The integration itself is pretty simple, the complexity you will face is to find the right information in the AD data structure.<\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction This documentation explains how to integrate Active Directory data in a Power BI report. It explains also how to link this data with another data source. To illustrate the method, we will integrate Active Directory Computer data and link it with SCCM Server information. We will only use 2 different data sources in this […]<\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[294,229,149],"tags":[1279,1490],"type_dbi":[],"class_list":["post-17957","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","category-database-administration-monitoring","category-security","tag-active-directory","tag-power-bi"],"acf":[],"yoast_head":"\n
Power BI - Active Directory data integration - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI - Active Directory data integration\" \/>\n<meta property=\"og:description\" content=\"Introduction This documentation explains how to integrate Active Directory data in a Power BI report. It explains also how to link this data with another data source. To illustrate the method, we will integrate Active Directory Computer data and link it with SCCM Server information. We will only use 2 different data sources in this […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-15T16:48:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-28T08:12:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png\" \/>\n<meta name=\"author\" content=\"Christophe Cosme\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christophe Cosme\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\"},\"author\":{\"name\":\"Christophe Cosme\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\"},\"headline\":\"Power BI – Active Directory data integration\",\"datePublished\":\"2022-07-15T16:48:50+00:00\",\"dateModified\":\"2022-11-28T08:12:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\"},\"wordCount\":1130,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png\",\"keywords\":[\"Active Directory\",\"Power BI\"],\"articleSection\":[\"Business Intelligence\",\"Database Administration & Monitoring\",\"Security\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\",\"name\":\"Power BI - Active Directory data integration - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png\",\"datePublished\":\"2022-07-15T16:48:50+00:00\",\"dateModified\":\"2022-11-28T08:12:39+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png\",\"width\":844,\"height\":321},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI – Active Directory data integration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\",\"name\":\"Christophe Cosme\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"caption\":\"Christophe Cosme\"},\"description\":\"Christophe Cosme has more than 22 years of experience in architecture, development and implementation of IT solutions including 17 years in the Business Intelligence area as well as 10 years of experience working with the Microsoft SQL Server Business Intelligence suite. His experience and qualifications cover project management, business analysis, functional and technical requirements. His expertise also includes the implementation of IT solutions in national as well as international organizations. Christophe Cosme is Expert in MS SQL Server DB Engine, SSIS, SSAS, SSRS and PowerBI. Prior to joining dbi services, Christophe Cosme was Solution Lead Business Intelligence Diabetes Care at Hoffmann-La-Roche Ltd in Basel . He also worked as Senior Manager Head of Business Intelligence for Swiss International Airlines Ltd. Christophe Cosme holds a Master's degree in Engineering, Automation from the IT\u2013 ENSISA (F). His branch-related experience covers pharmaceuticals, IT and the airline sector.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/christophe-cosme\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power BI - Active Directory data integration - dbi Blog","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:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/","og_locale":"en_US","og_type":"article","og_title":"Power BI - Active Directory data integration","og_description":"Introduction This documentation explains how to integrate Active Directory data in a Power BI report. It explains also how to link this data with another data source. To illustrate the method, we will integrate Active Directory Computer data and link it with SCCM Server information. We will only use 2 different data sources in this […]","og_url":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/","og_site_name":"dbi Blog","article_published_time":"2022-07-15T16:48:50+00:00","article_modified_time":"2022-11-28T08:12:39+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png","type":"","width":"","height":""}],"author":"Christophe Cosme","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christophe Cosme","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/"},"author":{"name":"Christophe Cosme","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a"},"headline":"Power BI – Active Directory data integration","datePublished":"2022-07-15T16:48:50+00:00","dateModified":"2022-11-28T08:12:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/"},"wordCount":1130,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png","keywords":["Active Directory","Power BI"],"articleSection":["Business Intelligence","Database Administration & Monitoring","Security"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/","url":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/","name":"Power BI - Active Directory data integration - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png","datePublished":"2022-07-15T16:48:50+00:00","dateModified":"2022-11-28T08:12:39+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/CHC_Blog_PowerBI_20220715_01.png","width":844,"height":321},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-active-directory-data-integration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Power BI – Active Directory data integration"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a","name":"Christophe Cosme","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","caption":"Christophe Cosme"},"description":"Christophe Cosme has more than 22 years of experience in architecture, development and implementation of IT solutions including 17 years in the Business Intelligence area as well as 10 years of experience working with the Microsoft SQL Server Business Intelligence suite. His experience and qualifications cover project management, business analysis, functional and technical requirements. His expertise also includes the implementation of IT solutions in national as well as international organizations. Christophe Cosme is Expert in MS SQL Server DB Engine, SSIS, SSAS, SSRS and PowerBI. Prior to joining dbi services, Christophe Cosme was Solution Lead Business Intelligence Diabetes Care at Hoffmann-La-Roche Ltd in Basel . He also worked as Senior Manager Head of Business Intelligence for Swiss International Airlines Ltd. Christophe Cosme holds a Master's degree in Engineering, Automation from the IT\u2013 ENSISA (F). His branch-related experience covers pharmaceuticals, IT and the airline sector.","url":"https:\/\/www.dbi-services.com\/blog\/author\/christophe-cosme\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=17957"}],"version-history":[{"count":5,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17957\/revisions"}],"predecessor-version":[{"id":20674,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17957\/revisions\/20674"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=17957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=17957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=17957"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=17957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- We are done with the data source selection and import, so click the Close & Apply ribbon to integrate your data in the Power BI report<\/li>\n<\/ul>\n\n\n\n
- You can now remove the Navigation step used for the object selection, it is no ore needed as we used a SQL Statement instead<\/li>\n<\/ul>\n\n\n\n
- Select an initial object to create the query with the SQL Server connector, but we will change it immediately and replace it by a custom query and click OK<\/li>\n<\/ul>\n\n\n\n
- Choose the parameter your created previously for the server and database name<\/li>\n<\/ul>\n\n\n\n
- Defined a new source by selecting SQL Server <\/li>\n<\/ul>\n\n\n\n
- In the window Extract the value from list I select None in the dropdown list as the description contains only 1 element in our case<\/li>\n<\/ul>\n\n\n\n
- Do the same by expanding the Top column and selecting the Description column<\/li>\n<\/ul>\n\n\n\n
- Search for the Computer object in the Active Directory data structure, check its checkbox and click the OK button<\/li>\n<\/ul>\n\n\n\n
- In the Active Directory setting window select the domain by selecting the parameter you created previously and click the OK button<\/li>\n<\/ul>\n\n\n\n
- Create a new parameter by capturing a name, description, its type and define an initial value and click OK to validate.<\/li>\n<\/ul>\n\n\n\n