Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there
July Update is kinda cool! In Run R Script feature, what if I want to reference another tables in PowerBi model, how can I do that?
Say I have 2 tables
Table1 - during my data wrangling process in Table1 I might want to merge to table2. dataset is table 1 so within this script window what would table2 is known as in this R script window?
Hope you can advice.
Pedzilla
Solved! Go to Solution.
@Anonymous Run R Script feature applies to selected query within query editor. So when you click on Run R Script button it actually creates 'dataset' data frame for the selected query. It doesn't create data frames for all the queries within query editor but only for selected query that you click button.
So if you really want to merge queries using R (power bi query editor has merge queries option already), then you should go to New Data Source -> Other -> R Script -> connect to both your data sources, merge and then load in power bi desktop. But unfortunately I think Run R Script button only references selected query and not all the queries.
@Anonymous Run R Script feature applies to selected query within query editor. So when you click on Run R Script button it actually creates 'dataset' data frame for the selected query. It doesn't create data frames for all the queries within query editor but only for selected query that you click button.
So if you really want to merge queries using R (power bi query editor has merge queries option already), then you should go to New Data Source -> Other -> R Script -> connect to both your data sources, merge and then load in power bi desktop. But unfortunately I think Run R Script button only references selected query and not all the queries.
User | Count |
---|---|
88 | |
73 | |
69 | |
64 | |
56 |
User | Count |
---|---|
98 | |
92 | |
84 | |
74 | |
66 |