Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi
I have two tables in my report. In query editor I have merged them and then I want to save the result to a text file.
I have tried to add this script to the query Itemlist:
require(gdata)
write.table(trim(dataset), file="C:/Users/KLJ/Documents/Power BI/Test10.txt", sep = "\t", row.names = FALSE, append = TRUE)
plot(dataset);
but I get this message:
(Sorry for the bad picture)
Is there a R script that can save this query to a text file?
R scrips is very new to me.
Here is a link to a copy of the pbix file
Thanks in advance.
Best regards
Kim
Solved! Go to Solution.
Ok, looks like the merge is the issue not the r
@KenPulshas blogged about the "Rebuild This Data Combination" Error.
https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
Also discussed here
I've used R to export data a few times from both ther editor and the visuals
This R script works for me.
# 'dataset' holds the input data for this script write.table(dataset, file="C:\\temp\\Test.txt", sep = "\t", row.names = FALSE, append = TRUE) output <- dataset
The M for my test looks like this.
Source = Table.NestedJoin(Table2,{"Column1"},Table2,{"Column1"},"Table2",JoinKind.LeftOuter), #"Expanded Table2" = Table.ExpandTableColumn(Source, "Table2", {"Column2", "Column3"}, {"Table2.Column2", "Table2.Column3"}), #"Run R Script" = R.Execute("# 'dataset' holds the input data for this script#(lf)#(lf)write.table(dataset, file=""C:\\temp\\Test.txt"", sep = ""\t"", row.names = FALSE, append = TRUE)#(lf)#(lf)output <- dataset",[dataset=#"Expanded Table2"]), #"""output""" = #"Run R Script"{[Name="output"]}[Value] in #"""output"""
Trim in r doesn't work on a dataframe. So if you need to trim either do it before you export in M or use sapply functions in r.
M is easiest, but the R option might be quicker with very large datasets.
Hi stretcharm
I've tried your proposal but I still get the same error message.
Ok, looks like the merge is the issue not the r
@KenPulshas blogged about the "Rebuild This Data Combination" Error.
https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
Also discussed here
I rebuild the query according to @KenPuls blog but still got the error.
Then I changed the the Privacy for the file to Ignore the privacy levels and it worked.
I not sure that is the right way to do this but ontil there is another solution this most do it for now.
Thank for your help @stretcharm
So turning off Privacy does a couple of things:
The issue is that it no longer checks to make sure the data sources are safe to combine without leaking data. If all my data is in the organization, I usually turn this setting off, but you do want to be careful of just doing that as a blanket answer.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
153 | |
125 | |
114 | |
111 | |
95 |