cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShubhamK Regular Visitor
Regular Visitor

Combine 2 excels data into 1 using Power BI visual

Hi,

 

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.

 

 

1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: Combine 2 excels data into 1 using Power BI visual

hi, @ShubhamK 

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.

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.