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!
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!