Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |