Tag: SQL Server Analysis Services

Power BI Port Number: Connecting Power BI To SSAS, Excel, And C#

Power BI Port Number Connecting Power BI To SSAS, Excel, And C# - Enterprise DNA

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.

Continue reading

How To Create A Composite Model In DAX Studio

How To Create A Composite Model In DAX Studio - Enterprise DNA

In this tutorial, you’ll learn how to create a composite model and use DirectQuery on a Power BI dataset or in Azure Analysis Services. The previous tutorials have discussed the MEASURE, COLUMN, and TABLE keywords. In some specific cases, the DAX engine automatically writes these keywords even if you didn’t explicitly use them. You’ll learn

Continue reading