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!