In the next days will be presented sql server 2016, for the SSIS component these are the principal news:
A little explanation
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:
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 .
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 .
