In this tutorial, you’ll learn how to use a Power BI port number to connect a data model to SSAS, Excel, or C#. The Power BI desktop runs a local instance of SSAS and then assigns it a random port number. This port number changes every time you close and open a Power BI file.
For today’s tutorial, I’m going to show how you can automate the process of sorting one column by another column inside Power BI and SSAS or SQL server analysis services. You can watch the full video of this tutorial at the bottom of this blog. In this example, we have the Dates table with several
