I have some data about projects I would like to transform in a way that makes it easier to analyse with PowerBi. The data looks like this: Project Number Project Name Planned Start Date SM1 SM2 SM3 10000 A Apr-21 10 20 30 10001 B Jun-21 40 50 60 10002 C Sep-22 70 80 90 The so called ‘SavingMonths’ are
Tag: powerbi
how to write a conditional for loop in DAX?
I’m using PowerBI to create a dashboard that summarizes data from a train movements simulation. (I’m a psychologist with some basic understanding of python and currently learning DAX.) Here is some background: I use [index] to maintain the order of the rows [Notification] is a column that contains text [Train Nr] is a column that contains the ID of the
Connect to Power BI XMLA endpoint with Python
Since the announcement about XMLA endpoints, I’ve been trying to figure out how to connect to a URL of the form powerbi://api.powerbi.com/v1.0/myorg/[workspace name] as an SSAS OLAP cube via Python, but I haven’t gotten anything to work. I have a workspace in a premium capacity and I am able to connect to it using DAX Studio as well as SSMS
Scraping Data from a website which uses Power BI – retrieving data from Power BI on a website
I want to scrape data from this page (and pages similar to it): https://cereals.ahdb.org.uk/market-data-centre/historical-data/feed-ingredients.aspx This page uses Power BI. Unfortunately, finding a way to scrape Power BI is hard, because everyone wants to scrape using/into Power BI, not from it. The closest answer was this question. Yet unrelated. Firstly, I used Apache tika, and soon I realized the table data