Power BI Desktop Query Parameters, Part 1, Introduction
One of the coolest features added to the April 2016 release of Power BI Desktop is “Query Parameters”. With Query…
Archive
Category: SQL Server
Querying SSRS Report Definition Using T-SQL
Do you want to have all reports that used a table in their report definition? Are you looking for a…
Batch Index Rebuild without Using Cursor
Today I came across a cube processing performance issue with one of our clients. So I started a step-by-step troubleshooting…
Browsing Cubes Remotely from Excel Trough a VPN Connection without Using Windows Authentication
Technically when you connect to another network through a VPN connection you can see all allowed machines on that network.…