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
Category: Power Pivot
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…
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…
Creating Custom Table in SSAS Tabular using Table and Row Constructors in DAX
A while ago I was working on a Power BI project which the customer wanted to define a new table…