Forum Discussion
SSAS data source not matched (dumb problem)
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?
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?
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 😞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