PowerBI to access Sharepoint list data

February 5, 2017

As I showed in a previous post SharePoint is different Interfaces you can use to access as a data source.

https://audministrator.wordpress.com/2015/01/26/sharepoint-interfaces/

So I we know it can expose it’s List data using the  REST or oData protocol.

Open PowerBI and go to GET DATA menu.

Choose OData Feed to connect to your SharePoint data source

 

image

Once logged you can choose from your lists

 

image

And play around to make your data visible using all the features from PowerBI Smile

image

Once Finished you can publish your result

 

image

Once published you can reach out on the mobile apps.

 

image


PowerBI and Google Analytics Data

February 5, 2017

Using PowerBI there are several out of the box  Web Services available to connect to. One of them is Google Analytics.

This is how it goes :

Open PowerBI Online version.

image

Next in the left menu bar click Get Data.

image

Next select Services

image

Select Google Analytics  and Get it NOW.

image

Select the authentication and fill in your credentials.

image

On the left menu bar you can see the Datasets, Reports and Dashboard, and reports that are available out of the box

 

image

image

image

 

Next you can Schedule a reload time … the Free edition you can only choose between daily or weekly.

image

 

This shows which are the nice capabilities of MS PowerBI platform  Smile

As you could see I also connected out of the box to SalesForce.com

image