Forum Discussion
Power Bi semantic model question
- 11 months ago
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.
Are you connecting to your MySQL database using Directquery or import mode? If it is Directquery you have to then connect via the gateway to your Mysql source and cannot go through via another semantic model.