topic Converting Python Script to Power BI in Developer https://community.fabric.microsoft.com/t5/Developer/Converting-Python-Script-to-Power-BI/m-p/1136467#M23981 <P>Hi All,</P><P>&nbsp;</P><P>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).&nbsp;</P><P>&nbsp;</P><P>In essence what I am trying to do is as follows:</P><P>&nbsp;</P><P>Input table (sharepoint):</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>&nbsp;</TD><TD>Effort</TD></TR><TR><TD>Prefix</TD><TD>2020 Q1</TD><TD>2020 Q2</TD><TD>2020 Q3</TD><TD>2020 Q4</TD></TR><TR><TD>proj1</TD><TD>10</TD><TD>14</TD><TD>13</TD><TD>12</TD></TR><TR><TD>proj2</TD><TD>2</TD><TD>6</TD><TD>10</TD><TD><P>12</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Should expand to:</P><TABLE><TBODY><TR><TD>Date</TD><TD>Prefix</TD><TD>Effort</TD></TR><TR><TD>01/01/2020</TD><TD>proj1</TD><TD>10</TD></TR><TR><TD>01/01/2020</TD><TD>proj2</TD><TD>2</TD></TR><TR><TD>02/01/2020</TD><TD>proj1</TD><TD>10</TD></TR><TR><TD>02/01/2020</TD><TD>proj2</TD><TD>2</TD></TR><TR><TD>..</TD><TD>..</TD><TD>..</TD></TR><TR><TD>..</TD><TD>..</TD><TD>..</TD></TR><TR><TD>31/12/2020</TD><TD>proj1</TD><TD>12</TD></TR><TR><TD>31/12/2020</TD><TD>proj2</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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!</P><P>&nbsp;</P><P>Your expert advise would be appreciated!</P><P>&nbsp;</P><P>Olly</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 02 Jun 2020 15:45:49 GMT owallis 2020-06-02T15:45:49Z Converting Python Script to Power BI https://community.fabric.microsoft.com/t5/Developer/Converting-Python-Script-to-Power-BI/m-p/1136467#M23981 <P>Hi All,</P><P>&nbsp;</P><P>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).&nbsp;</P><P>&nbsp;</P><P>In essence what I am trying to do is as follows:</P><P>&nbsp;</P><P>Input table (sharepoint):</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>&nbsp;</TD><TD>Effort</TD></TR><TR><TD>Prefix</TD><TD>2020 Q1</TD><TD>2020 Q2</TD><TD>2020 Q3</TD><TD>2020 Q4</TD></TR><TR><TD>proj1</TD><TD>10</TD><TD>14</TD><TD>13</TD><TD>12</TD></TR><TR><TD>proj2</TD><TD>2</TD><TD>6</TD><TD>10</TD><TD><P>12</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Should expand to:</P><TABLE><TBODY><TR><TD>Date</TD><TD>Prefix</TD><TD>Effort</TD></TR><TR><TD>01/01/2020</TD><TD>proj1</TD><TD>10</TD></TR><TR><TD>01/01/2020</TD><TD>proj2</TD><TD>2</TD></TR><TR><TD>02/01/2020</TD><TD>proj1</TD><TD>10</TD></TR><TR><TD>02/01/2020</TD><TD>proj2</TD><TD>2</TD></TR><TR><TD>..</TD><TD>..</TD><TD>..</TD></TR><TR><TD>..</TD><TD>..</TD><TD>..</TD></TR><TR><TD>31/12/2020</TD><TD>proj1</TD><TD>12</TD></TR><TR><TD>31/12/2020</TD><TD>proj2</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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!</P><P>&nbsp;</P><P>Your expert advise would be appreciated!</P><P>&nbsp;</P><P>Olly</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 02 Jun 2020 15:45:49 GMT https://community.fabric.microsoft.com/t5/Developer/Converting-Python-Script-to-Power-BI/m-p/1136467#M23981 owallis 2020-06-02T15:45:49Z Re: Converting Python Script to Power BI https://community.fabric.microsoft.com/t5/Developer/Converting-Python-Script-to-Power-BI/m-p/1138969#M23991 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="218004" data-lia-user-login="owallis" class="lia-mention lia-mention-user">owallis</a> , Can Transpose help: <A href="https://yodalearning.com/tutorials/power-query-helps-transposing-data/" target="_blank">https://yodalearning.com/tutorials/power-query-helps-transposing-data/</A></P> <P>&nbsp;</P> <P><A href="https://radacad.com/pivot-and-unpivot-with-power-bi" target="_blank">https://radacad.com/pivot-and-unpivot-with-power-bi</A></P> Wed, 03 Jun 2020 13:23:46 GMT https://community.fabric.microsoft.com/t5/Developer/Converting-Python-Script-to-Power-BI/m-p/1138969#M23991 amitchandak 2020-06-03T13:23:46Z