Quick Tips: Find Power BI Desktop Local Port Number with Model Explorer
In March 2018, I wrote a blogpost called Four Different Ways to Find Your Power BI Desktop Local Port Number.…
Archive
Tag: SQL Server Management Studio
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…
Incremental Refresh in Power BI, Part 1: Implementation in Power BI Desktop
Incremental refresh, or IR, refers to loading the data incrementally, which has been around in the world of ETL for…
Quick Tips: Export Power BI Desktop and Power BI Service Model Data In One-Shot with DAX Studio
Update 2021 March: You can now export the data direct from Power BI Desktop using my tool, Power BI Exporter.…