Refresh excel power pivot linked to SSAS on premise

[vilenm]

Hi

We have a published excel file in service workspace with powerpivot datasource linked to on premise tabular model.

I tried to create power bi desktop and import excel power pivot query and publish it so that it would "act as the data source for excel file"

However for a gateway, what would be the name of the model or data query ? and will this option work?

[Anonymous · Accepted solution]

Hi  @vilenm ,

You can try placing Excel on Onedrive.

Connect to onedrive excel file from power bi desktop

For refresh, you can check the following documentation:

You can connect excel stored in onedrive through power bi desktop, publish to power bi service, and configure gateway for Onedrive refrsh.

Unlike a dataset refresh during which Power BI imports data from a data source into a dataset, OneDrive refresh synchronizes datasets and reports with their source files. By default, Power BI checks about every hour if a dataset connected to a file on OneDrive or SharePoint Online requires synchronization.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#onedrive-refresh

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive

https://community.powerbi.com/t5/Service/OneDrive-Excel-workbook-automatic-refresh-how-can-I-get-it-...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi  @vilenm ,

It is recommended that you try to select File as the data source in the Power BI Gateway interface, and put the Excel file path, and use local Windows to verify

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources

https://community.powerbi.com/t5/Power-Query/Scheduled-refresh-for-excel-file-with-on-premise-gatewa...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vilenm]

Thank for this I will refer.

Another question is we getting push back from our IT that they not allowing gateways for excel linked to on premise. Is there any other solution I can look at automating the refresh whilst having latest excel file updated in service?