Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I havea composet model developed by Power BI Desktop connecting to a data model then adding on 2 Excel files to the data model. So DirectQuerey via SQL Server Analysis Services. Everything worked fine a week or twp ago.
Then today i published from the desktop and my App did not work anymore. I received the error "There is no avaialbe gateway".
I checked an the gateway is sill active.
I then tried to build a new visual on the web instead of desktop. Those visuals no matter what data set i tired gave the error. "Couldn't load the data for this visual"
There may be a simular issue here
https://community.powerbi.com/t5/Service/Analysis-Services-Authentication-Authentication-Type-Not/m-...
See below for the full error message below
Couldn't load the data for this visual
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: d2cad957-b5c5-4e53-92df-b4f8dfe3e951
Request ID: a11493d5-03cb-fdea-ec33-84c48f2fc038
Correlation ID: e87a3523-8be6-64b8-5ff1-f54ad1c90159
Time: Tue Mar 28 2023 19:26:20 GMT-0500 (Central Daylight Time)
Service version: 13.0.20342.55
Client version: 2303.3.12949-train
Cluster URI: https://wabi-us-north-central-h-primary-redirect.analysis.windows.net/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @asjones
So when you remove excel from the model, everything is back to normal. It seems that the problem is in the gateway configuration of excel. Did you re-add the excel gateway inside Manage gateways?
Best Regards,
Community Support Team _ Ailsa Tao