Tabular model & Python

Sometimes you need to retrieve data from SSAS service but you dont want to use application like Excel or Power BI. You can do it with Python.

We will connect to local SSAS instance.

Result:

You can also connect to Power BI Desktop Tabular Model.

You need to find port and database name and change it in CONNECTION_STRING variable.

CONNECTION_STRING = r”Provider=MSOLAP;Data Source=localhost:60184;Catalog=67a2ca6f-74ea-414a-9857–1766e347f616;”

You will get the same result as in the first case.

--

--

--

Data | BI Engineer (Microsoft Stack)

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Embed iorad tutorial(s) into Google Sites

Implementing a lightweight transcription microservice with gRPC

Git — Introduction

2022년 3월 WITH News Letter

Issues I fixed after upgrading to macOS Big Sur version 11.1

CS371p Spring 2021: Michael Liu

Best Way To Hire A PHP Developer

Enabling and using C# 9 features on older and “unsupported” runtimes

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Michal Molka

Michal Molka

Data | BI Engineer (Microsoft Stack)

More from Medium

The Role of Pandas in Data Analysis

Power BI: Live Dashboard With Python

How to make data frames from different CSV files in Python

Data Types for Data Science in Python: Dictionaries — the root of Python