Chris Webb BI

SEPTEMBER 15, 2024

If you’re performance tuning a DirectQuery mode semantic model in Power BI, one of the first things you’ll want to do is look at the SQL that Power BI is generating. That’s easy if you have permissions to monitor your source database but if you don’t, it can be quite difficult to do so from Power BI. I explained the options for getting the SQL generated in DirectQuery mode and why it’s so complicated in a presentation here , but I’ve recently found a new way o

Profiling 327

Profiling IT 327

CIO

SEPTEMBER 15, 2024

The finalists for the Team of the Year categories in this year’s CIO50 Australia have been announced. Part of Foundry’s global CIO awards program, the awards recognise IT teams that exemplify excellence in specific areas. These categories include the Culture award, acknowledging teams that foster a positive and innovative work culture; the Customer Value award, commending teams that prioritise delivering value to customers; and the Talent award, recognising teams that excel in attracting, develo

Entertainment 167

Entertainment Banking Win Innovation 167

BI Insight

SEPTEMBER 15, 2024

A while back, I published a blogpost explaining how to use Azure LogicApps to automate scaling Microsoft Fabric F capacities under the PAYG (Pay-As-You-Go) licensing option. Some of my followers reported an issue with their Capacity Admin settings when running the LogicApp solution. The issue was that their capacity admins disappeared after they had run … Continue reading Microsoft Fabric: Resolving Capacity Admin Permission Issues in Automate Capacity Scaling with Azure LogicApps The post

Business Intelligence 74

Business Intelligence Management Business Intelligence 74