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’…
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…
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 co…
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 …