2014년 7월 1일 화요일

Power BI 세팅 방법

Power BI enables self-service business intelligence for all your data. With Power BI, you get complete self-service BI for your on-premises and cloud-based data by using the new data discovery and analysis features in Excel with the collaboration capabilities in the new Power BI cloud service.
To administer Power BI, you use the Power BI Admin Center. Before you can start using the Admin Center, you need to setup Power BI for Office 365.
To setup a Power BI site, you need a Power BI for Office 365 account. To create a Power BI account, go tohttp://www.powerbi.com.

How to setup Microsoft Power BI for Office 365

After you sign up for a Power BI site at http://www.powerbi.com, you setup Power BI with just a few steps.
  1. From your Office 365 site, click Sites in the upper right corner of the dashboard page.
 NOTE    If you see the We’re almost ready page, your Office 365 site is provisioned but not yet setup. You might need to wait 10 to 15 minutes for site setup to complete.
  1. In the new site page, click the Team Site tile.
Power BI - Provisioning Guide
  1. In the left navigation pane, click Site Contents.
Power BI - Provisioning Guide
  1. In the Site Contents page, click the Power BI tile.
Power BI - Provisioning Guide
  1. In the Power BI page, you can click Add samples to add sample data to learn about the rich visualizations and insights you can create with Power BI or you can click Use my own data.
Your Power BI app is setup.
Power BI - Provisioning Guide

Next Steps

Now that you have Power BI provisioned and installed, you can learn more about Power BI:
  • Getting Started Guide – A step-by-step getting started guide. The Getting Started guide is designed to walk you through the collection of self-service business intelligence (BI) features included in Power BI.
  • Power BI for Office 365 Admin Center Help –Guidance about how to use the Power BI Admin Center to control security and access to certain on-premises data sources, and to register these on-premises data sources to expose them as data feeds.
  • Data Management Portal Help –Guidance about the Data Management experience in Power BI to securely share data within the enterprise from within the familiar environment of Excel using Power Query.
  • Power Query for Excel Help - Guidance about how to use Power Query for data discovery, data transformation and enrichment for the desktop to the cloud.

내가 만든 Power BI 사이트

Power BI Admin Center의 GateWay 설정



Power BI Admin Center 의 Data Source 설정



Connection Info에서 set credentials 클릭 시 팝업 창





















이렇게 설정이 완료되면 Excel Power Query에서 OData 연결을 통해 해당 Data 즉, 세팅된 Table이나 View 선택해서 확인할 수 있다.

댓글 없음:

댓글 쓰기