Power BI License

There is a new interesting Vide by Guy a cube about Power BI license, in particular about:

  • Different options for Power BI license assignment,
  • from the Office 365 Admin portal to PowerShell.
  • quick overview of the different types of licenses available.

You can see the report here or at this link…

Continua a leggere

Optimize your phone experience

With this update you can specifically tailor a portrait phone view of your existing dashboard as part of the dashboard authoring experience. Once you finish creating your dashboard in the Power BI service, you can use the dashboard settings to optimize how you view it on your phone. Permissions to change the phone view are only available to dashboard owners. Changing the default phone view will not affect the web, tablet, or phone landscape views of that dashboard.


Changes will only be applied to the dashboard when viewing it on the phone in portrait mode.

In the phone view editor, you can unpin tiles, resize and re-order them as you’d like. As you edit the phone-optimized view, your dashboard viewers will immediately get the updated experience on their iPhones, Android, and Windows phones.

Login failed Sql Account sql 2016

After you install Microsoft SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005, or SQL Server 2000 and you try to connect to the server that is running SQL Server, you receive one of the following error messages:

  • Login failed for user ‘%.*ls’. The login is a SQL Server login and cannot be used with Windows Authentication.%.*ls
  • Login failed for user ‘<user_name>’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
  • Login failed for user ‘<user_name>’. (Microsoft SQL Server, Error: 18456)

This problem occurs if the user tries to log in with credentials that cannot be validated. To resolve this issue, configure SQL Server in Mixed Authentication Mode. To do this, follow these steps:

Continua a leggere

Preparing data for analysis using R

Microsoft In these days has reIeased an interesting paper about using R to preparing Data.

In this paper, they’ll demonstrate some of the things that can go wrong with data, and explore ways to address those issues using the R statistical language (https://cran.r-project.org/) before going on to analysis.

For faster numerical libraries, allte the paper is based on the Microsoft R Open distribution (https://mran.microsoft.com/open/).

The idealized goal in mind is using machine learning to build a predictive model.

Continua a leggere

Introducing Power BI Free Book

Introducing Microsoft Power BI is a book that covers the basics of the tool and, at the same time, shows you what the main capabilities of Power BI are. This book is targeted to a variety of readers. There are information workers and people who are totally new to the BI world.

Book Chapter:

  • Introducing Power BI
  • Sharing the dashboard
  • Understanding data refresh
  • Using Power BI Desktop
  • Getting data from services and content packs
  • Building a data model
  • Improving Power BI reports
  • Using Microsoft Power BI in your company

download it from this link