10/28/2013

Up and Running #Microsoft #PowerBI #MSBI

Here's a great tutorial on how to get started with Microsoft #PowerBI:

After requesting access to PowerBI, a few days later, I was granted permissions.

So I logged onto their site and began the registration processs:

Provisioning:
 

Service Center:

Quick Start:

Licenses:


Mail:

Service Health:


 
Reports:

Support:
 
Trial:
 
Message Center:


 Tools:



 Setup Licenses:
 Subscription Details:
 
Subscription Details2:
 Installation Complete:





 SharePoint in the Cloud:
 


Exchange Admin Center:
 
And finally, PowerBI in the Cloud!!!


Gateway:
From here, you can create a Gateway to establish a link between your PowerBI in the Cloud to your On-Premise data source:

 
Next, Install & Register:

 

Choose the download you want:

 
Thank you for downloading...
 
 Installing...
 
Finished Installing...
 
Register Gateway...
 
Enter Unique Code so they know it's you...
Specify Endpoint...
 
 
Congrats, it's installed...
Welcome, let's get started... 
 
 New Gateway (your connection to the host computer)...
Data Source Usage...
 Create your "data source"...
 
Run the wizard...
 
Test Connection was Successful...
Add Users/Groups who can access this new data...
 
View new Data Source...
 
 
Bug:
 
Solution:
 
Found here:  Use this link to download Power Query:
 
 Expose the tables in SQL-Server...
 
 Be sure you have the correct version of PowerQuery (there's 2 versions of Power Query)...
 
Now sign in using lower case OnMicrosoft account...
 


 Enter OData Feed... can find this on the Admin...Data Source...Edit...O Data Feed URL...
 Now sign in using Online Microsoft ID...
 
 Power Query found the tables from SQL Server located on my Hard Drive on the Laptop at my house...
 
Load Table/Data into Excel...

Goto Insert --> Power View -->

Quite impressive!

No comments:

Post a Comment

Babalon