Create a custom KPI Card in a Power BI report
Do you want a customized KPI Card in Power BI? Patrick looks at how you could get a custom KPI Card in a Power BI report without using custom...
2019-04-10
PowerPivot/PowerView/PowerQuery/PowerBI
Copy workspace, Publish to Multiple workspaces, Download all PBIX files, and much more in Power BI Helper April Edition
In RADACAD we do our best to improve user experience using Power BI every single day, and throughout that experience, we add more and more functions to Power BI...
2019-04-10
Register Power BI Helper in Your Tenant
This article explains the setup instructions to work with the Service tab of Power BI Helper. Download Power BI Helper from here. Power BI Helper is a third party...
2019-04-10
A quick look at the new Power BI Report Builder
Patrick takes a quick look at Power BI Report Builder including how to get it. This report builder is optimized for the Power BI service. Patrick calls out a...
2019-04-09
Table.Buffer() Does Not Buffer Nested Values
Here’s yet another entry in the list of useful things I learned from Ehren von Lehe on the Power Query MSDN forum: Table.Buffer() does not buffer nested table, record...
2019-04-09
Different types of many-to-many relationships in Power BI
The introduction of the weak relationships in Power BI composite models enables new data modeling techniques. However, not all of the many-to-many relationships can be managed by using weak relationship.
2019-04-05
Affordable Power BI Premium for Small Business (Part 2)
The second in Matt Allington's series of articles explaining how to use Microsoft Flow, the Azure APIs, the Power BI APIs and SharePoint Online to help make Power BI Premium more affordable for small to medium sized enterprises.
2019-04-05
Easily get an access token for the Power BI Embedded Playground
You need an Embed Token for the Power BI Embedded Playground, but you don't want to write code. Adam shows you how to easily get an access token.
2019-04-04
Affordable Power BI Premium for Small Business (Part 1)
This is another one of those articles that has been swirling in my head for a very long time, about 2 years actually. I have long been frustrated by the lack of a suitable scalable Power BI pricing model for small to medium sized enterprises...
2019-03-30
Power BI Support, new workspaces, Power BI Desktop update and more… (March 25, 2019)
This week's Power BI news roundup!
2019-03-30
Blogs
“SQL Server Is Slow” Part 4 of 4
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
How to Install DBeaver and Connect to a PostgreSQL Instance
By gbargsley
Whether you’re a seasoned DBA or just exploring database tools, DBeaver offers a powerful,...
DBAs should never run SSMS under their everyday Windows account
DBAs should never run SSMS under their everyday Windows account If you open SSMS under...
Forums
Extract from sql.to multiple sheets
Import-Module ImportExcel # Path to your .sql file $sqlFile = "C:\Data\MyQueries.sql" $excelPath = "C:\Data\SqlExtract_$(Get-Date...
sp_prepare and sp_execute vs sp_executesql
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Question of the Day
Who am I?
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer
@customername varchar(200)
AS
BEGIN
DECLARE @added VARCHAR(100)
SELECT @added = xxx
IF @customername IS NOT NULL
INSERT dbo.Customer
(
CustomerName,
AddedBy
)
VALUES
(@customername, @added)
END See possible answers