SSAS data source not matched (dumb problem)

[Anonymous]

Hi all

We are working in an environment like this...

Our report in Powerbi Desktop consumes SSAS data source from our server sql02\sql2019 (named instance), but when i upload it to Powerbi "Service" dataset says it cannot match any datasource from our on-premise gateway. 

Documentation about it says that the database name and server name must match, but of course, the SSAS Prod engine is not the same name as Dev engine so it is obvious that it will not match !!!!!!!!!! even more, Dev SSAS engine is a named instance while prod not ...

So what to do in these situations? 

It is a very weird and stupid problem that is easily solved by an alias (like in SQL server you can do) but SSAS does not admit such thing. SSAS is a complicated guy.

I'm the first person to face it? (I dont think so)

[v-cazheng-msft]

Hi, @Anonymous 

After publishing report to Service, you need add data source in Manage Gateways for the dataset of the report(Connection mode is Live Connection). The Server name used to connect the data source in Desktop must match the server name in data source settings in Service. The database name used to connect the data source in Desktop must match the database name in Data Source Settings in Service. And the username and password used to connect SSAS in Data Source Settings need be the administrator of the Analyze Server. When the data source used by the report has been added, you need to Maps the dataset to the data source.

1 Connect to SSAS in Desktop:

2 Add data source in Data Source Settings:

3 Maps the dataset to related data source:

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ · Accepted solution]

Hi @Anonymous 

What I would do is before uploading the PBIX file I would get someone with the right permissions to open the PBIX connect to the PROD instance (By changing the connection settings), save the file and then upload to the PBIX Service.

That will then allow it to connect via the Gateway and the configured datasource?

[Anonymous]

Hello Gilbert

Thanks for the suggestion.

We tried to change the server name in the datasource as you suggested, (previous to upload) but then the program tries to connect to this server and it is not reachable, so after that, a windows is shown with three buttons: Retry, Edit and Cancel.
So you cannot save the changes unless the server is reachable 😞

[GilbertQ]

Hi @Anonymous 

As mentioned previously you would need a user with the permissions and access to the server to make the change.

I am not sure but you could try and use the parameters in the PBIX file and edit them once uploaded?

You could try this: Using the Power BI Service Parameters to change connection strings (To possibly change between Dev, Test & Prod) - Reporting/Analytics Made easy with FourMoo and Power BI