hello evryone i wish i can find a solution here so my problem is that i have data in sql server with these columns (respondant,sexe, age,region,Q1,Q2,Q3,Q4) i want to analyse it so i chose python script or R script in powerbi/getdata and when i analysed my data i got two dataframes one is a correlation between (Q1,Q2) and one of clustring. But when i whant to filter by (age, sexe,...) i can't get those columns in my dataframes PS: The data and analysis are just exmaples so my database is actually a lot bigger and i have to do a lot of analysis that powerbi can't provide so i chose python or R.
For " But when i whant to filter by (age, sexe,...) i can't get those columns in my dataframes" , do you mean you'd like to filter the source data before imported into Power bi desktop? You can take a shoot of the advanced options
For "The data and analysis are just exmaples so my database is actually a lot bigger and i have to do a lot of analysis that powerbi can't provide" , could you plz share more concerns about " Power bi can't provide"?
Community Support Team _ Dina Ye If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
FYI too that you may be able to do your R or Python analyses at the visual level, instead of in the query (for more flexibility, use of slicers, etc.). Please see this post I wrote a while ago that may give you some ideas.
I did one time use python visual but for unknown reasons it gave me the wrong data and my second reason is that i'm using visuals like infographic designer which i cannot find in python visual, plus the easy usage of powerbi visuals considering i got 42 visuals