Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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"?
hello @v-diye-msft thanks for the reply
i want to filter my data after importing it to powerbi.
to explain more here is an example of my database in sql server
and here is the dataframe that i recieve from python' scrpit
i want to be able to get the correlation of (Q1,Q2,Q3) of women when i chose women in the slicer or get the correlation of a chosen age
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.
https://powerpivotpro.com/2018/11/hijacking-the-r-visual/
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypat thanks for your reply
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |