Today i try to resume what is it power bi gateway and how use it to connect on premise database to Power BI Online.

This schme can resume how works and what is power bi enterprise gateway:

Continua a leggere →

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 →

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.

Since its release last march, it’s possible to analyze Power BI from excel. Now Microsoft had added a new feature that brought new meaning to the term better together that Power BI and Excel are working hard to achieve.

How change the Use of Excel on power bi?

Continua a leggere →

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 →

Microsoft has introduced just some days ago a new feature about Qrcode on power bi app.You can create a matrix code in the Power BI service for the panes in a dashboard that you can change. then enter the matrix code in a key path. You could, for example, paste it into an e-mail message, or print it out and paste it in a specific location.

now see how to create a power bi Qrcode…

Continua a leggere →

we have three new power bi custom visual:

• Strippets Browser,
• Cluster Map
• Facet Key

Continua a leggere →

The new Feature of Power BI R visual have three type of limitation:

• Power BI version
• Type of R script
• R use Limitation

I ‘ll try to resume this limitations to give you more information to use correclty R visual on Power bI

Continua a leggere →

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