Unable to connect a workbook to AAS

[SteveD2]

Hi,

I'm trying to create a workbook in the Power BI service using AAS as the source. I'm able to connect AAS and the required perspective in Excel desktop. However, when I try to publish the file to the service, I get these errors.

Despite this, I can find the workbook in the workspace I published to.  When I open the workbook, it opens with Excel Online and displays the pivot table but, when I try to change a field or apply a filter to the pivot table, I get this error.

This process works as expected if the workbook accesses SQL tables in a DW though.

Has anyone, had any success in accessing AAS with a Power BI workbook?

[SteveD2]

In summary, Excel workbooks using an AAS connection are unable to be refreshed in the Power BI service.

[v-yangliu-msft · Accepted solution]

Hi  @SteveD2 ,

This is the related document, you can view this content:

https://community.powerbi.com/t5/Service/Excel-Pivot-connect-to-SSAS-Tabular-doesen-t-work-in-Power-...

https://answers.microsoft.com/en-us/msoffice/forum/all/prevent-error-message-external-data-refresh-f...

https://community.powerbi.com/t5/Service/Can-t-refresh-Power-BI-pivot-table-in-Excel-Online/td-p/166...

https://integent.com/we-were-unable-to-refresh-one-or-more-connections-in-this-workbook-thisworkbook...

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.