New functionality SSIS 2016

In the next days will be presented sql server  2016, for the  SSIS component these are the principal news:

  1. Deployment Incremental
  2. Supporto per Always On Availability Group
  3. Always Encripted
  4. Debugging
  5. Control Flow Template
  6. AutoAdjustBufferSize:
  7. Upgrade package:
  8. Support for HDFS, Excel 2013 e 2016, OData versioni V3 per ATOM e JSON e V4 per JSON
  9. ConnectorSAP BW with SQL Server 2016 Feature Pack
  10. Azure Feature Pack
  11. Productivity and update

A little explanation

Continua a leggere

Excel publish on power bi

Often users ask if you can integrate existing objects sull’excel ( special graphics for example ) within power bi online .

Directly from this link trovetere a very interesting program called ” Power BI Publisher for excel ” . This simple tool allows you to upload to power bi:

  • A range of cells or PivotTable
  • Pivot charts
  • Images
  • Text

is not possible to load any 3D object ( like maps ) or views in power view .

After you have downloaded and installed the component you must activate sull’excel . We find it under the COM components along with PowerPivot component. At this point we will ask for credentials to use for power bi where we will publish our objects . If you run all the correttamenti steps will add a new TAB at Excel , where if we go and change our profile :



At this point, just select any object that interests us , a pivot table or chart and click subsequently on PIN :



At this point are published in the dashboard selected or a new one, you can always upgrade via the excel and its application or delete .


Time intelligent PowerPivot functions with fiscal year

In many situations besides the normal calendar we are faced with the fiscal calendar , which as we know the year start date does not match with that of the classical calendar.

Use the measurements in PowerPivot with the fiscal calendar becomes complex , as they are based on the classical calendar. Fortunately, there are a series of time intelligence functions that take this particularity of this .


Continua a leggere

Import Multiple json File in Power Query

When using Power BI often you want to be able to aggregate more information or more data sources in a single query .

Take for example the json file , but this procedure is also valid for other data formats , it often happens that the information is spread across multiple files , and no single document , or is spread over several sites .

What can traditionally do is create a number of queries ( one for each file ) and then merge them together later . Or we can use a simple string of code that allows us to unify them all into a single query that automatically calls the various pages and aggregates .

Let’s start from the beginning .

Continua a leggere

Power BI Gateway Update

With the month of February has also renewed the power bi gateway . The main updates are as follows :

  • Live and direct connection to Oracle and Teradata
  • Supported automatic updating of all the data sources previously imported apart from analysis services and queries from zero ( Blank Query ) . This support includes : SQL Server , Teradata , Oracle , DB2 , MySQL , Sybase , SAP HANA , OData , Web , Files and Folders on-premises , and SharePoint lists on-premises

has been also referred to the date of expiry of the support to the old analysis services gateway , it will be March 31, 2016 .


Continua a leggere

How to find json link

When we navigate a website sometimes we come across web pages that contain a set of KPI and very interesting numerical indicators that we would like to exploit.

For example if we connect the of the 2014 World Cup statistics page we find a number of very interesting information that maybe we’d like to use . This type of information , however, can not be used directly as a table as well as on PowerPivot because its format is not a table:


Continua a leggere

PowerPivot import Web/Json page

Often you happen to find online a range of data and information that we are interested to import directly into our PowerPivot models .

Of course, the simplest solution would be to write everything by hand , but of course would require much time and effort .

But we can get help from power queries to overcome this problem . at this point , however, we distinguish two types of data :

  • Table directly exposed on a website , we think , for example, a table of wikipedia
  • Table instead exposes a result deriving makes a json file

We face two types separately


Continua a leggere