<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Muaz Hazali on Medium]]></title>
        <description><![CDATA[Stories by Muaz Hazali on Medium]]></description>
        <link>https://medium.com/@mdmuaz3010?source=rss-0fa8a98a332b------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*vwSwEetV0HnSjuA7</url>
            <title>Stories by Muaz Hazali on Medium</title>
            <link>https://medium.com/@mdmuaz3010?source=rss-0fa8a98a332b------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 14:40:58 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@mdmuaz3010/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[How to Connect Hortonworks Data Platform (HDP) through Zeppelin Notebook Directly to Power BI]]></title>
            <link>https://medium.com/@mdmuaz3010/how-to-connect-hortonworks-data-platform-hdp-through-zeppelin-notebook-directly-to-power-bi-57dce520d926?source=rss-0fa8a98a332b------2</link>
            <guid isPermaLink="false">https://medium.com/p/57dce520d926</guid>
            <category><![CDATA[hadoop]]></category>
            <category><![CDATA[hortonworks]]></category>
            <category><![CDATA[big-data]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Muaz Hazali]]></dc:creator>
            <pubDate>Fri, 21 Jun 2024 00:49:16 GMT</pubDate>
            <atom:updated>2024-06-21T00:49:16.380Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3khDVkAtRr3rBGQTLTts6Q.png" /></figure><h3>Introduction</h3><p>Learn how to seamlessly integrate Hortonworks Data Platform (HDP) with Zeppelin Notebook for effective data visualization in Power BI. Step-by-step guide included.</p><h3>Prerequisites</h3><p>Before we begin, ensure you have the following:</p><ul><li><strong>Hortonworks Data Platform (HDP)</strong> installed and running.</li><li><strong>Power BI Desktop</strong> installed on your machine.</li><li>Necessary access permissions to your HDP cluster and its data.</li><li>In this case, I use Zeppelin Notebook to handle queries.</li></ul><h3>Steps Below:</h3><h4><strong>1. Open Power BI Desktop</strong></h4><ul><li>Launch Power BI Desktop on your computer.</li></ul><h4><strong>2. Get Data:</strong></h4><ul><li>Click on <strong>Get Data</strong> from the Home ribbon.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-wgvqPVnhDNHZ4u0MmGTfw.png" /><figcaption>Click on More… to view more data sources</figcaption></figure><ul><li>Scroll down and select <strong>Hadoop File (HDFS)</strong>.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*FBUk9a0G7Y5AnsZQX8t-ug.png" /><figcaption>Search for “HDFS” in the search bar, then click on “Hadoop File (HDFS)”</figcaption></figure><ul><li>Click <strong>Connect</strong>.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1lbIzZHF3B-bStlR6IsNiQ.png" /><figcaption>Click “Connect”</figcaption></figure><ul><li>Enter the Server sandbox-hdp.hortonworks.com or your own server.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*nsNWyR8nsnWB27T0TtHX2g.png" /><figcaption>Type in your server domain and click “OK”</figcaption></figure><ul><li>If you something like this, you’re good to go.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/875/1*LT2iWhoUtX-GRYFAttvbBQ.png" /><figcaption>If you see this, you’re good to go.</figcaption></figure><ul><li>If there’s any error, please check your domain server, ensure there are no “https://” or “www”.</li><li>Another possible reason of error is your Power BI version. Use Desktop Version instead of Microsoft Store Version. Get it <a href="https://www.microsoft.com/en-us/download/details.aspx?id=58494">here</a>.</li><li>Or maybe you didn’t have the access to the server, firewall setting, network setting.</li></ul><h4>3. Transform Data:</h4><ul><li>Click on “Transform Data”</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-8pdjCU4_6Ld3uFCh-YHTA.png" /><figcaption>Click on “Transform Data”</figcaption></figure><ul><li>You will see this after clicking “Transform Data” (opened Power Query Editor).</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*V2nf7-8oBW1p7KuPXVSHAA.png" /><figcaption>You’ve opened Power Query Editor</figcaption></figure><ul><li>Filter the Extension to display only CSV file (or any desired format).</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*tq6Dv_dU8BestkKXdex6Zg.png" /><figcaption>Clear all selection, then type in “csv”, select “.csv” and press “OK”</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3gOn0JvuWgOltYVGLB86JA.png" /><figcaption>It will display only the filtered format (in this case CSV file)</figcaption></figure><ul><li>Click on “Binary” on the same row as your desired file (in this case reviews_sentiment.csv).</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/559/1*i2e_N7WVSdn-h8I7TW-FQA.png" /></figure><ul><li>After clicking it, it should run some steps in order to properly display your file/data.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jrBU2yjylKjlncWaB4kn5A.png" /><figcaption>Preview of the dataset in Power Query Editor</figcaption></figure><ul><li>If required, you can do more data transformation such as removing columns, replacing values, and etc.</li></ul><p><strong>4. Load Data</strong>:</p><ul><li>Click “Close &amp; Apply” to load the data into Power BI.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*MQlGWAt7F5YOlDl3SXeZ3Q.png" /><figcaption>Click “Close &amp; Apply” after finish transformation</figcaption></figure><ul><li>There you have it, your data and columns successfully loaded into Power BI.</li><li>You can rename the query1 into desired name</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/261/1*PIKhhTsSt_pqXDa3eYEUoA.png" /></figure><h3>TL;DR:</h3><ol><li><strong>Prerequisites</strong>:</li></ol><ul><li>Install and set up <strong>HDP</strong> and <strong>Zeppelin Notebook</strong>.</li><li>Have <strong>Power BI Desktop</strong> installed.</li></ul><p><strong>2. Steps</strong>:</p><ul><li>Open <strong>Power BI Desktop</strong>.</li><li>Get data from <strong>Hadoop File (HDFS)</strong>.</li><li>Enter server address (e.g., sandbox-hdp.hortonworks.com).</li><li>Transform data in Power Query Editor.</li><li>Load and rename queries.</li></ul><p><strong>3. Common Issues</strong>:</p><ul><li>Check server address format.</li><li>Use Power BI Desktop Version.</li><li>Ensure access permissions and network settings are correct</li></ul><h3>Conclusion</h3><p>By following these steps, you can successfully connect your Hortonworks Data Platform through Zeppelin Notebook directly to Power BI, enabling powerful data visualization capabilities. This integration allows you to leverage big data for dynamic and interactive reporting, facilitating better business decisions</p><blockquote>Special thanks to <strong>Austin Ryan</strong> for the initial guide. <a href="https://sqldusty.com/2015/07/29/power-bi-and-big-data/#:~:text=Once%20your%20Hortonworks%20Sandbox%20is,data%20into%20the%20semantic%20model.">Read the original article</a>.</blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=57dce520d926" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>