Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
ImPalaBI
Helper I
Helper I

On-premises data gateway not showing on only one semantic model

I have several reports in a EC2 Windows server. In that same server, I have SQL database.
So I create my Power Bi reports accessing that database via localhost connection.
I have a personal data gateway installed on this server, so when I publish my reports, in the semantic models I choose that gateway and can schedule refreshes for all my data.

This have been working for years, but for this new report (that I made starting from other report, just adding more tables) the gateway is not listed, and I´m unable to refresh the data. Can someone point why this is happening and how can I fix it? I heed to create new reports, and I’m afraid this could keep happening.

 

This is the gateway options inthe semantic model that is failing:

2024-05-02 11_21_56-Power BI and 28 more pages - Personal - Microsoft​ Edge.png

 

This are the working settings in other semantics models of the same source:
2024-05-02 11_33_12-Power BI and 28 more pages - Personal - Microsoft​ Edge.png

2 REPLIES 2
lbendlin
Super User
Super User

make sure the spelling is the same throughout with no extra spaces etc.

 

Note: Your setup is quite a bit aways from the recommendations.

- Use FQDNs for connection sources

- Don't put a gateway on the same machine as a database

- don't use personal gateways 

- have more than one gateway cluster member


@lbendlin wrote:

make sure the spelling is the same throughout with no extra spaces etc.


Where? I just checked all the contents in the advandec editor, no spelling errors. Is there any other place I should look for?

Thanks for the advice.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors