I have a R visual using which i am exporting table data into 2 excels but i need to have only 1 excel. I can not use edit queries option because i am using live connection. Is there any way i can create a visual so that this 2 excels will get merged into 1 without going into edit queries.
For live connection, all the modeling process are done in the data source,
there is no sense in which a new model is being created; in other words, it's not possible to define new calculated columns, hierarchies, relationships, and so on.
So I'm afraid it couldn't achieve in Power BI for now. You'd better do it in the data source.