There is no available gateway - Couldn't load the data for this visual

[asjones]

Anyone else seeing this?
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"

My gateway says it is setup correct untill I addan external data source and publish.

When I dig into the Gateway setting this it says the Gateway can't find my data model OR the extra excel sheet that i added to the model. ... seems odd it says it can't find he data model that is in the Power BI Cloud. The Excel file should be local to the report.

IF I remove the extra Excel sheet from the model and repbublish everything it all works fine. Something seems messed up with the new composet model stuff when adding an extra local data source. It was my understanding that we would not need to add a file to the Gateway process so that a user could combine data from the data model and a seperate Excel file.

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/

[GilbertQ]

Hi @asjones 

Is the Excel file stored on a local drive or on OneDrive/SharePoint

If it is OneDrive/SharePoint then you might have to add it to the Gateway because you have a source going via the gateway too?

[asjones]

The Excel is on a local drive and Power BI says "import" in the process.

[GilbertQ]

Hi @asjones 

You would then need to create a data source connection in the Gateway settings in the Power BI Service to enable it to refresh.

Chris Webb's BI Blog: Configuring Power BI Gateway Data Sources For Files And Folders (crossjoin.co....

[asjones]

@GilbertQ 

I understand what you are saying but that would not make sense in the context for how composite models have been described/advertised. The whole idea was that an end user (non-technical) could “add” their own Excel file to supplement the data model with more information. I have never heard that the new data had to be setup with a Gateway connection if it was just one time import.
It seems like something else is missing.

thanks

Alan

[GilbertQ]

Hi @asjones 

Even though you only imported an Excel file, it has been imported from a folder location. So when you want to refresh the dataset, it will refresh all files that have been imported.

That is why you need to add it to the gateway so that it can refresh this excel file which you got from your local drive.