Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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:
This are the working settings in other semantics models of the same source:
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.