Converting Python Script to Power BI

[owallis]

Hi All,

I am importing data from a sharepoint excel and running a python script to expand and maniplate the table into the required format. This works excellently but I have found out that python only supports personal gateway. It is a requirement that we can refresh this report with cloud gateway. Therefore I believe my only option is to recreate what my python script was doing in power bi (which I am less familiar with). 

In essence what I am trying to do is as follows:

Input table (sharepoint):

	Effort
Prefix	2020 Q1	2020 Q2	2020 Q3	2020 Q4
proj1	10	14	13	12
proj2	2	6	10	12

Should expand to:

Date	Prefix	Effort
01/01/2020	proj1	10
01/01/2020	proj2	2
02/01/2020	proj1	10
02/01/2020	proj2	2
..	..	..
..	..	..
31/12/2020	proj1	12
31/12/2020	proj2	12

I want to take a simple table with effort per project for each quarter and expand it out to each day of the year and for each prefix.

What would be the 'power bi way' to approach this problem? My guess is that I am going to have to learn some M and tackle this in the advanced editor. Any material or examples is welcome!

Your expert advise would be appreciated!

Olly

[amitchandak]

@owallis , Can Transpose help: https://yodalearning.com/tutorials/power-query-helps-transposing-data/

https://radacad.com/pivot-and-unpivot-with-power-bi