

Be sure you know the pertinent details to setup a connection (server and Know and setup the connection string details without much assistanceįrom a fully automated wizard. Need to be aware that many of these data sources will require you to ODBC - If all else fails, hopefully a data source allows for ODBC based connections.Opens up access to SalesForm CRM data and reports Surprising to me is the availability of Google Analytics as a data source SharePoint Lists - SharePoint lists data can be extracted from a SharePoint siteĪllows for easy retrieval of Hadoop based data structures.Web - Web based html tables can be scraped to get data.Folder- This source allows you to examine the meta data of all the files and sub-folders in a folderĪzure MarketPlace, Azure SQL Database, Azure HDInsights, Azureīlob Storage, Azure Table storage - These sources provide a tight.Others I find to be particularly noteworthy including: Some, like SQL Server, Excel, and Access are "old stand bys", while

You will note some are still in beta mode,

As you can seeįrom the three illustrations below, the data source list is both longĪnd growing each month. Alternately, if youīypass the start screen, you can click on the Get Data button in theīoth options open the data source selection screen. Start the query process via clicking on Get Data. When you open PBID, the start screen, as shown below, allows you to Latest version information on the Microsoft Power BI Support page at. Releasing an updated preview about once per month. With all these changes and updates, Microsoft is currently To production with the fact the tool set may not scale as anticipated Sure it works well from my testing, but features areīeing added and removed every month. I go too far I need to warn you that the tool is still in its early Web, you must have an account setup on the Power BI site. Furthermore to publish the PBID reports to Microsoft has indicated that the tool will continue to be free.
HOW TO USE POWER BI DESKTOP SOFTWARE
The current edition of the software is available free of charge and
HOW TO USE POWER BI DESKTOP DOWNLOAD
The Power BI Desktop is available for download at. The tool and the details in the tip still apply. Power BI Designer to Power BI Desktop (PBID). OfĬourse just as the tip was published, Microsoft renamed the tool from Select the 64-bit version of Power BI and hit next to download. We described in detail the new Power BI Desktop (AKA Power BIĭesigner) that Microsoft has added to the Power BI tool set. On your Chrome browser, navigate to and go to the footer menu to click on the Power BI Desktop button, select the advanced download option, choose English as your preferred language, and hit the Download button. In a previous tip, Getting Started with Power BI Desktop,
