Cross-report Drillthrough in Power BI
Patrick leBlanc shows the magic of getting cross-report drillthrough working in Power BI.
2019-05-03
PowerPivot/PowerView/PowerQuery/PowerBI
Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified
In this article, you will learn about one of the most important properties of a relationship called Cardinality.
2019-05-02
Taking Buttons in Power BI Desktop to the Next Level
Amanda Cofsky joins us to show how you can use buttons, in Power BI Desktop, to take your reports to the next level. Blank buttons can really make your...
2019-04-26
Using The “Skip Test Connection” Option For Power BI Data Sources To Avoid Scheduled Refresh Failures
One of the most popular blog posts I have written in recent years is this post on how the RelativePath and Query options for the Web.Contents() M function can...
2019-04-25
Improve Power BI Report performance by using the filter pane
If you are using slicers in your Power BI report, moving them off to the filter pane could improve performance. Patrick shows you what this could look like based...
2019-04-24
Power BI Streaming Datasets for More Than IoT
Power BI real-time streaming is the perfect solution for IoT. Whether processing data through Azure Stream Analytics, the PubNub data stream network, or a custom Internet of Things solution,...
2019-04-24
Power BI Paginated, DAX, Power Query and more… (April 22, 2019)
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup134 2 Minute Tuesday: https://guyinacu.be/databrickserror Patrick's tech video: https://guyinacu.be/modelview Adam's tech video: https://guyinacu.be/powerbigetdata Sources DAX 101: Summing...
2019-04-22
Export data from Power Query to Local Machine or SQL Server using R scripts
There is always a discussion on how to store back the data from Power BI to local computer or SQL Server Databases, in this short blog, I will show...
2019-04-22
Power Query Memory Usage, Dataflow Container Size And Refresh Performance
When Power BI dataflows were officially released a few weeks ago there was a new setting for Premium capacities mentioned briefly in the announcement blog post: Container Size. The...
2019-04-21
The new Power BI App Workspace experience
The new Power BI App Workspace experience GA'd in April of 2019. Adam takes you through what the new Power BI App Workspace is all about and what is...
2019-04-11
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
BCA KCU PANAKKUKANG Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi...
BCA KCU MAKASSAR Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...
BCA KCU AMBON Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers