cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GerryFlanagan
Microsoft
Microsoft

Replacing a SSAS connector with the Enterprise Gateway

Hi,

 

 

My situation is this; I have a POC server that has two tabular models on it and I want to replace the SSAS connector with the enterprise gateway so that I can connect to tabular models and on prem SQL servers. The goal here being to enable schedualed refresh without the dependancy on some local macheine being on. What I dont know is how the current reports from the two tabular models will be affected by the change.

One of the models has a report built in P.BI descktop and published to the web service. I assume that if the SSAS connector to that model is replaced with the enterprise gateway then the report will need to be republished and it should auto reconnect using the enterprise gateway.

My question here is, would the pbix file have to sit on the server in order for the published dashboard to use the enterprise connector?

The second model connects to a report done in power view in a sharepoint site, using a semantic model connection. How would this be affected by installing the enterprise gateway on the server?

 

Many Thanks,

Gerry

1 ACCEPTED SOLUTION
PowerBIGuy
Responsive Resident
Responsive Resident

@GerryFlanagan Have you seen the following link?

Business Intelligence Architect / Consultant

View solution in original post

1 REPLY 1
PowerBIGuy
Responsive Resident
Responsive Resident

@GerryFlanagan Have you seen the following link?

Business Intelligence Architect / Consultant

View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors