Hi,

I use Power Query to do ETL work then load data into PowerPivot model. Then later I imported PowerPivot to SSAS cube.


I successfully imported the model into SSAS cube. Silly question really but I supposed I couldn't refresh my data from now on?


I actually couldn't deploy the cube without it throwing an error Microsoft.Mashup.OLE error.


Alternatively, I can put my model on a SharePoint site and connect my SSAS cube but I'm just exploring if there's another solution without Sharepoint.


So I guess but questions are:


Once import PowerPivot - is there a way to refresh data being that it connects to power query queries?

Any alternatives to load PowerPivot to SSAS cube apart frSharepointint?

Any Idea? would be appreciated!