Forum Discussion
Power Bi semantic model question
The error you’re seeing indicates that the new report cannot establish a connection to the existing semantic model via the service, even though your MySQL gateway connection works for the original report. This usually happens because when connecting to an existing dataset in another workspace, the new report is using a “Live Connection” to that dataset, and the workspace or dataset permissions are not configured to allow this report to access it. In Power BI, even if a gateway works, a report in a different workspace needs explicit access to the shared dataset: the user publishing the new report must have at least Build permission on the dataset in the original workspace. Without this, the service cannot authenticate the connection to the semantic model, leading to errors that appear like connection failures. Essentially, the issue is permissions and dataset access, not the gateway itself. To fix it, ensure the user publishing the report has Build rights on the target dataset and that the dataset is shared across workspaces correctly.
The error you’re seeing indicates that the new report cannot establish a connection to the existing semantic model via the service, even though your MySQL gateway connection works for the original report. This usually happens because when connecting to an existing dataset in another workspace, the new report is using a “Live Connection” to that dataset, and the workspace or dataset permissions are not configured to allow this report to access it. In Power BI, even if a gateway works, a report in a different workspace needs explicit access to the shared dataset: the user publishing the new report must have at least Build permission on the dataset in the original workspace. Without this, the service cannot authenticate the connection to the semantic model, leading to errors that appear like connection failures. Essentially, the issue is permissions and dataset access, not the gateway itself. To fix it, ensure the user publishing the report has Build rights on the target dataset and that the dataset is shared across workspaces correctly.