How to work on existing power query using python

0 votes

I have an existing power query created in power BI. Now I want to do some dynamic transformations on this power query result using python. How I can work on the existing power query using python. Do python have the eligibility to upload a fresh dataset and work on power BI ?

Could anyone help for this?
Feb 7, 2020 in Power BI by Biswajith
• 120 points

Hi Biswajith,

Can you please elaborate what kind of progress you have done in your query editor? According to that will he able to help you out how you can use python in your result. 

Yes Python is a powerful language, and can be used in Query Editor to prepare your data model and create reports. The integration of Python into Query Editor lets you perform data cleansing using Python, and perform advanced data shaping and analytics in datasets, including completion of missing data, predictions, and clustering, just to name a few.


I have extracted data from different data sources and using power query I succeeded in creating a query result as per requirement. Now the generated matrix is good for visualisation. Now for another requirement i want to transpose the fields from above power query and need to do some data manipulations. How i need to get this power query dataset created by my power bi using python. Once i search in google python integration comes only by getting fresh dataset from different data sources like databases, csv etc. There is help document code related to get data from existing  Power query result from power bi. Don’t know my explanation is upto the point.

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Power BI

0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,520 points
0 votes
3 answers

How do I get token using javascript API while trying to embed graphs using Power BI

Use ADAL.js that will give you an ...READ MORE

answered Jun 22, 2019 in Power BI by anonymous
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
0 votes
3 answers

How to create final table based on Joins of two tables in power BI?

To do so, follow these steps: From the ...READ MORE

answered Dec 16, 2020 in Power BI by Gitika
• 65,910 points
+2 votes
3 answers

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 33,030 points
+2 votes
3 answers

Problem with installation of Wordcloud in anaconda

Using Anaconda Python 3.6 version For Windows ...READ MORE

answered Aug 7, 2018 in Data Analytics by Priyaj
• 58,090 points
0 votes
7 answers
+10 votes
3 answers

Which is a better initiative to learn data science: Python or R?

Well it truly depends on your requirement, If ...READ MORE

answered Aug 9, 2018 in Data Analytics by Abhi
• 3,720 points
+1 vote
4 answers

Python vs. R for data science

I would say both Python and R ...READ MORE

answered Aug 1, 2019 in Data Analytics by briny
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP