Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a report that all it does is export it's data to excel via power automate using some R code.
"write_xlsx(dataset,"file_path.xlsx")"
However, I need to manipulate it further and it needs to be in a tabular format to do so. Yet, when I try "write.table" I get the error that my connection to OneDrive is not open. So I can export an Excel sheet with the data, but not the same data as a Table.
Any ideas?
Hi @Anonymous
Perhaps "write.table" doesn't support XLSX files. I didn't find examples that use "write.table" to export data to XLSX files. They export data to TXT, CSV or other formats. For XLSXs, they use "write_xlsx" or "write.xlsx". Maybe you can try "write.xlsx".
Reference:
https://r-coder.com/export-data-r/
https://www.dataanalytics.org.uk/the-3-rs-writing/
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thank you for replying. I've tried write_xlsx. The issue is writting it as a table. I can export it as a spreadsheet no problem.
Hi @Anonymous
I'm a little confused. When you want to write it as a table, which type of file are you writing it to? Can you show the current "write.table" code (removing sensitive info)?
Regards,
Jing
I can't write it as a table. I can export the data to excel as a .xlsx file, but it's not in table format. But when I try
library("writexl")
write.table(dataset,"C:\\file location.xlsx")
I am unable to do so.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
11 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |