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
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers