The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello
In Excel, is it possible to specify that when I refresh a specific Data Connection, the data is loaded to a specifically named sheet or if this sheet does not exist, a new sheet with the exact name is created and the data is loaded in that?
Thanks!
Once you set load the table initially the sheet will be created. Every time you refresh the data will refresh on that same sheet.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.