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
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/
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?
Community Support Team _ Ailsa Tao