https://community.fabric.microsoft.com/t5/Report-Server/Shared-Datasets-for-Excel-Consumption/m-p/4371959#M39346 <P>Hello everyone!</P><P>&nbsp;</P><P>Does the PowerBI server have a shared dataset feature that Excel can use to do analytics? I need to rebuild a portion of our old data warehouse and do away with SSAS. Our users are used in excel pivots and I'd like to give them the same interface.</P><P>&nbsp;</P><P>Thanks in advance for any insights!</P> Mon, 20 Jan 2025 13:45:50 GMT josephollero 2025-01-20T13:45:50Z https://community.fabric.microsoft.com/t5/Report-Server/Shared-Datasets-for-Excel-Consumption/m-p/4371959#M39346 <P>Hello everyone!</P><P>&nbsp;</P><P>Does the PowerBI server have a shared dataset feature that Excel can use to do analytics? I need to rebuild a portion of our old data warehouse and do away with SSAS. Our users are used in excel pivots and I'd like to give them the same interface.</P><P>&nbsp;</P><P>Thanks in advance for any insights!</P> Mon, 20 Jan 2025 13:45:50 GMT https://community.fabric.microsoft.com/t5/Report-Server/Shared-Datasets-for-Excel-Consumption/m-p/4371959#M39346 josephollero 2025-01-20T13:45:50Z https://community.fabric.microsoft.com/t5/Report-Server/Shared-Datasets-for-Excel-Consumption/m-p/4372423#M39347 <P>No it does not. If you want to share datasets across multiple reports or connect using Excel or manage datasets with multiple partitions and incremental refresh then you need to keep SSAS in your architecture.&nbsp;</P> Mon, 20 Jan 2025 21:34:12 GMT https://community.fabric.microsoft.com/t5/Report-Server/Shared-Datasets-for-Excel-Consumption/m-p/4372423#M39347 d_gosbell 2025-01-20T21:34:12Z