How to work on existing power query using python

0 votes
Hi

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 in Power BI by Biswajith
• 120 points
369 views

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.

Hi

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
1 answer
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
1,452 views
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,200 points
967 views
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,590 points
685 views
0 votes
1 answer

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

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1, 2019 in Power BI by Cherukuri
• 32,460 points
3,183 views
+3 votes
1 answer

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
• 32,460 points
22,707 views
+1 vote
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
• 57,530 points
6,818 views
0 votes
7 answers
+9 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 8, 2018 in Data Analytics by Abhi
• 3,680 points
147 views
0 votes
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
197 views