I have a problem where I have a Power BI semantic model in 2 different workspaces, one for Test and one for Prod.
A user is accessing the dataset via a PivotTable in Excel connecting with “From Power BI”
My idea is that the user can take a copy of his Excel file and then adjust the connection string to connect to the semantic model in the Test workspace for testing new functionality and regression testing.
However, when comparing the connection string between Prod and Test they are exactly the same, so I do not know how to distinguish between them.
Anyone having any idea about this? Is there any other config, except the connection string, that hold info about what workspace is used?
Thanks!
//Patrick
I would expect some difference in the connection string so that is points to either of the workspaces.
Patrick Baumann is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.