This article describes how to correctly use column references when manipulating tables assigned to DAX variables, avoiding syntax errors and making the code easier to read and maintain. Using...
2019-05-11
The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate, filtering it is not so straightforward. In this article, Dennes Torres explains how to add a slicer that does the job.
2019-05-09
A BI project should return value to the company quickly, not only after months or even years of work. In this article by Gogula Aryalingam, Ruthie, the intern, determines which items from her manager's requirements she can complete before the big meeting. She continues working on her semantic model by including a Date table, the star schema, measures, formatting, and more.
2019-05-06
The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate, filtering it is not so straightforward. In this article,...
2019-04-15
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup133 2 Minute Tuesday: https://guyinacu.be/pbireportbuilder Patrick's tech video: https://guyinacu.be/kpicard Adam's tech video: https://guyinacu.be/newworkspace Sources MICROSOFT’S POWER PLATFORM...
2019-04-15
Aggregations have been introduced in 2018 in Power BI, as an optimization technique to manage large tables. By providing pre-aggregated tables, you can highly improve the performance of a...
2019-04-15
Reza Rad announces an update to Power BI Helper: Previously you could use Power BI Helper to connect to a model in Power BI Desktop and analyze that model,...
2019-04-15
Previously, I have written about using Power Query transformations and functions to create an Exception report for Power BI. However, the method I mentioned there, was only doing the...
2019-04-14
The news about XMLA endpoint connectivity to Power BI datasets is now all around the internet after the public preview announcement of that last week. However, I realized that...
2019-04-08
Learn how to use Power BI to retrieve data from an Azure SQL Database.
2019-03-15
2,461 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers