Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SSAS data source not matched (dumb problem)

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...
Need Help
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    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?

v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

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.