Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |