Power BI Performance Analysis
How can you find the cause of slow performance issues in Power BI? This post demonstrates some of the advanced tools you can you to test slowing performing queries...
2019-05-11
Power BI
Table and column references using DAX variables
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
Power BI and The Matrix: A Challenge
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
The BI Journey: The Expert’s Advice – Part 2
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
Power BI and The Matrix: A Challenge
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
Power Platform, Power BI Paginated, new Power BI Desktop and more… (April 15, 2019)
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 in Power BI
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
Power BI Helper April 2019 Edition
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
Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 1
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
What Is the XMLA Endpoint for Power BI and Why Should I Care?
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
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCU BANYUWANGI Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Jenderal Ahmad Yani No.24-26, Panderejo, Kec. Banyuwangi, Kabupaten Banyuwangi, Jawa Timur 68416
BCA KCU BLITAR Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
BCA KCU DIPONEGORO Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers