Powerbi
- Home /
- Categories /
- Powerbi
How to fix direct Query authentication delegation issues with Power Bi Report Server with Edge and Chrome
With the end of the IE support for Power Bi (and in general tbh), companies are scrambling finally to move their users from the legacy browser to modern ones; it was about time if you ask me.
Read MoreQuick Tip: How to find the address of the PowerBI local tabular instance
Super quick tip, I’ve seen this done via CMD or DaxStudio, but not via PowerShell (probably because I haven’t searched so much since I’ve done it myself), but here we are:
Read MoreA PowerBI Report for the COVID19 Emergency in Italy
As you may know, I’m from Italy; at the moment we’re experiencing the most difficult medical emergency in our history due to the new coronavirus.
Read MoreCreating a Report and distributed Alerts for PowerBI Scheduled Refreshes in your organization (starring Powershell, PowerBi & Microsoft Flow)
The Issue If you ever tried to manage a PowerBI Tenant, you may have come across this problem:
Read MoreHow to implement a Linear Regression Prediction in a PowerBI report using Python
Machine learning is the buzzword of the moment, so I wanted to talk about that sweet ML here too.
Read MoreA SQL Server Permission Report in PowerBI
What it is and how to get it When working with SQL Instances that have lots of databases, sensitive data and equally lots of users/applications that accesses those, it can get pretty troublesome to keep track of every user, for every database, down to the single column/action.
Read MoreA PowerBI Report for SQL Server Agent Jobs
As my “community service” this month, I’ve worked on this neat (I hope!
Read MoreJob Performance Analysis PowerBi Report coming soon
It will be part of the FirstResponderKit tool, free for all
Read MoreHow to populate a PowerBI Dataset from a REST API, using PowerBI's REST API, without any code (via Microsoft Flow)
I was wondering if PowerBI could be used for reporting on Live data, not coming from my Database using DirectQuery (or the new super neat composite mode ) with with a Streaming Dataset, which I never used before, so, I got to work.
Read MoreTroubleshooting SQL Server by analyzing the deviation from average values of Waitstats and Perfmon counters
Counters and Waitstats are good boys and useful for understanding what’s going on in your SQL instance, but often are pretty useless by themselves if you don’t know what’s a normal value for your server; For example a value of 100 batch requests/Sec is a value to worry about?
Read MoreCreating a Perfmon and Filestats reports in PowerBI [Part 2]
In this previous post I detailed the structure of the objects to be created to create a live report in PowerBI to analyze Perfmon and Filestats data (which in my case was already being gathered but not used by the FirstRespondersKit tool); Let’s get to the PowerBI stuff.
Read MoreCreating a Perfmon and Filestats reports in PowerBI [Part 1]
If you work for a big company, you may have a bunch of instances/databases under your control, you ran whatever monitoring tool has been provided and everybody is happy; But if your’re like me and you’re working for a big number of customers, each one with a different version of SQL and own configuration/security policies, with no monitoring tool directly available, and have to answer the question “what happened to the instance the other night” you may be a little bit overwhelmed.
Read More