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