Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query
In September 2014, I wrote a blog post on dynamically passing parameters from PowerPivot to a SQL Server stored procedure…
Archive
Tag: SQL
Quick Tips: Time Dimension with Time Bands at Seconds Granularity in Power BI and SSAS Tabular
I wrote some other posts on this topic in the past, you can find them here and here. In the…
Power BI Ecosystem Report Authoring Tools Demystified
There are a lot of discussions these days around Power BI tools to create reports and for sure many of…
Quick Tips: Time Dimension with Granularity of Seconds in Power BI and Analysis Services Tabular Models
In an article I posted a while back I showed different methods of creating Time dimension in Power BI and…