funichi-blog1

[funichi-blog1]

Steps to connect to Sql server on Windows Azure Virtual Machine from local machine

Steps to connect to Sql server on Windows Azure Virtual Machine from local machine

[funichi-blog1]

Dynamically Changing A Chart Axis In Power BI Using Bookmarks And Buttons

Dynamically Changing A Chart Axis In Power BI Using Bookmarks And Buttons

[funichi-blog1]

Power Bi group by Index

Power Bi group by Index

It can often be useful to create an index column in power bi. But power Query does not allow you to create a grouped index for a specific product category. Let’s predict this simple example:

As you can see we have two columns, one that contains the group (column 1) and one that contains values ​​(column 2). First of all on power query we have to add the index column starting from 1 and close the…

[funichi-blog1]

Power Bi Map BOX

Try the new Power Bi Custom Visual Map BOX!

While using Twitter I found a new interesting map to use on power bi. It’s called Mapbox and is a service to be activated and used to generate maps in power bi destkop:

  To activate this type of map, you must first go to the https://www.mapbox.com website and register for the site.The service is paid, but under a certain limit of views is completely free. In particular:

Once registered, on your…

[funichi-blog1]

Stop SSRS Rendering on SQl

Sometimes occur that a specific SSRS subcription is in pending or blocked or using too time to create report. if you want to force the stop of subcrption you can do it using this two string of code directly on sql database of report server:

truncate table  [ReportServer].[dbo].[ActiveSubscriptions] truncate table  [ReportServer].[dbo].[Notifications]   Done that your Subscription is stopped but…

[funichi-blog1]

Power BI desktop January News

Happy new year to everyone!

Here’s the complete list of January updates:

Reporting

Show and hide pages: you can now hide any number of pages you want through right clicking the page name and selecting hide.

Control data label background color for Cartesian and maps visuals:  You’ll find the option under the Data labels card in the formatting pane.

Increase area used for axis labels in charts:  Th…

[funichi-blog1]

Determine free space for SQL Server

One of the functions of a DBA is to keep an eye on free space within the database and database files. The auto grow feature is great as a last resort, but proactively managing the database files is a better approach. Also, this information can be used to shrink data files as needed if there is a lot of free space in the files.

One option is to use sp_spaceused. If we run the following command we…

[funichi-blog1]

Check progress of shrink database

Its very simple. Open management studio create a new query on the instance where is the database that you are shrinking and paste this query:

Select percent_complete, status, command , estimated_completion_time from sys.dm_exec_requests

And find dbccfilescompact

[funichi-blog1]

Sql server list table

Its very simple to find all the table or view in a sql db. On management studio select your db and open a new query.

Then past this query

Select * from information_schema.tables

If you want to see only table add

Where table_type =’base table’

[funichi-blog1]

Power BI desktop march Resume

Power BI desktop march Resume

Hi everybody, today we speak about some interesting new features on power bi desktop. This upgrade is very interesting. IN particular this month:

Report view

Report theming preview: When you import a theme, all your charts will automatically update to use the theme colors, and you’ll have access to the theme colors from the color palette.You can upload a theme file using the Import Theme option…

[funichi-blog1]

Connecting from Power BI Mobile to SSRS Last week, Guy in a Cube shows how to configure Active Directory Federated Services (ADFS) and the Web Application Proxy (WAP) role in Windows 2016, so that you can connect from Power BI mobile to SQL Server Reporting Services using OAuth. See the video, it's very interesting.

[funichi-blog1]

Ataira Analytics BI - Collaboration for SharePoint Power BI Groups Support

Ataira Analytics BI – Collaboration for SharePoint Power BI Groups Support

During my browsing online about Power Bi i found an interesting solution to Sharepoint power bi. His Name is Ataira Analytics +BI  and with their solution can view your Power BI items within a convenient SharePoint web part. You can also send notifications to your corporate groups and add follow-up actions for your team to more tightly collaborate on your business intelligence efforts in one…

[funichi-blog1]

Power BI Mobile February 2017 Update

Power BI Mobile February 2017 Update

Here we are with the news about Power Bi Mobile:

Power BI app for Android tablets is now available globally

New dashboard tile actions (All): To access this menu, just tap and hold on a tile in a dashboard, or tap the ellipsis (…). The menu allows you to navigate directly to the underlying report, expand the tile, or even manage an alert for the tile if the type supports it.

SSRS – multi server…

[funichi-blog1]

How to: Power BI Quick Calc and Format

How to: Power BI Quick Calc and Format

Quick Calc and Format of column are two much requested features. In this article I’ll explain how to use this two Features in Power bi. (more…)

[funichi-blog1]

How to: Integrate Power BI reports in SharePoint Online

How to: Integrate Power BI reports in SharePoint Online

In these days Microsoft has announced the introduction of a new web part that enables SharePoint authors to embed Power BI reports directly in SharePoint Online pages with no code required.

This is a easy e short guide to how to integrate power bi report on sharepoint online. We start from requirements:

This solution works only with Sharepoint Online

The web part requires new SharePoint features…

[funichi-blog1]

Power bi February News

Power bi February News

Today Microsoft Team has released a new version of  Power BI Desktop. Here the summary of the news

Report View

Word wrap on matrix row headers: You’ll see a word wrap toggle under the Row headers card. Once you turn word wrap on, the row headers will word wrap to fill the space they have

X- and Y-axis font size control: you’ll now find the text size slider under the X-Axis and Y-Axis cards in the…

[funichi-blog1]

Power BI Service February News

Power BI Service February News

Power BI admin role:  Power BI Admin portal will have access to tenant-wide usage metrics, and be able to control tenant-wide usage of Power BI features.

Power BI audit logs globally available

Public preview: Email subscriptions With Power BI e-mail subscriptions, you can quickly subscribe to emails of the report pages that matter most. Once subscribed, Power BI will regularly send screenshots…