Get data with Power BI Desktop

-

 Introduction        

             Microsoft Power BI is a collection of apps, software services and connectors that come together to turn unrelated data into visually impressive and interactive insights. Power BI can work with simple data sources like Microsoft Excel and complicated ones like cloud-based or on-premises hybrid Data warehouses. Power BI has the capabilities to easily connect to your data sources, visualise and share and publish your findings with anyone and everyone.

        Power BI is simple and fast enough to connect to an Excel workbook or a local database. It can also be robust and enterprise-grade, ready for extensive modeling and real time analytics. This means it can be used in a variety of environments from a personal report and visualisation tool to the analytics and decision engine behind group projects, divisions, or entire corporations.

        As Power BI is a Microsoft product and has built in connections to Excel, there are many functions that will be familiar to an Excel user.

Get data from Excel

You can used Microsoft Excel to create or view reports or to build pie charts or other visuals. Getting your Excel data into Power BI is a straightforward process.





Import from a local drive

Wherever you keep your files, Power BI makes importing them simple. In Power BI, you can go Get Data > Files > Local File to select the Excel file that you want.


After you click Local file, you have two options. You can import excel data into Power BI or you can upload your excel file to Power BI.

Import will connect to the data in your workbook so you can create Power BI reports and dashboards. Upload will bring your excel file into Power BI so you can view and interact with it as you would in Excel Online


After the file has been imported into Power BI, you can begin creating reports.

Your files don't have to be on a local drive. If you save your files on OneDrive or SharePoint Team Site, that's even better.


Comments

Post a Comment

Popular posts from this blog

Configure forms, charts, and dashboards in model driven apps

-
Image
    Model-driven apps           Model-driven app design is a component-focused approach to app development. Model-driven app design doesn’t require code and the apps you make can be simple or very complex. Unlike canvas app development where the designer has complete control over app layout, with model-driven apps much of the layout is determined for you and largely designated by the components you add to the app.   Model-driven apps start with your data model – building up from the shape of your core business data and processes in the Dataverse to model forms, views, and other components. Model-driven apps automatically generate great UI that is responsive across devices.           Model-driven app design doesn’t require code and the apps you make can be simple or very complex.  With model-driven apps, much of the layout is determined for you and largely designated by the components you add to the app. Form...
Read more

create and manage field within an entity in microsoft dataverse

-
Image
  Column types in Microsoft Dataverse              The column type determines the values that can be stored within that column. All columns have one and only one column type. The column types that are available in Microsoft Dataverse include: Text - A text value intended to be displayed in a single-line text box. Text Area - A text value intended to be displayed in a multi-line text box. If you require more than 4,000 characters, use a Multiline Text data type. Email - A text value that is validated as an email address and rendered as a mailto link in the column. URL - A text value that is validated as a URL and rendered as a link to open the URL. Ticker Symbol - A text value for a ticker symbol that will display a link that will open to show a quote for the stock ticker symbol. Phone - A text value that is validated as a phone number rendered as a link to initiate a phone call by using Skype. Whole Number - A number value presented in a text...
Read more

Principles of cloud computing and deployment

-
 Introduction  Dynamics 365’s customer engagement applications are customer focused business applications that are built on the Microsoft Power Platform. They are designed to help organizations more effectively engage their customers. The sales and marketing applications help identify sales prospects and turn them into long lasting relationships. Our service focused applications help your organization service your customers, whether you have a call center, service center, or are providing service in the field. Dynamics 365 customer engagement applications ensure that you have the tools necessary to fully engage your customers across all aspects of your business.Microsoft business applications are intelligent solutions that supply a comprehensive view of an organization’s business. These solutions include the Microsoft Dynamics 365 products that are connected by data and intelligence and are supported by Microsoft Power Platform.   Dynamics 365 revolutionizes CRM and ...
Read more