Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

 

 

General Comment
Need Help
Tips and Tricks

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    hi, Anonymous 

    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