Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
When a report that uses a live connection to a published dataset is saved in PBIP format in the same folder as the dataset (github repo for example), it sometimes gets connected using a "byPath" connection which then makes Power BI Desktop that it has its own dataset (which is not true) and will apply changes to the dataset's ".SemanticModel" folder even though we haven't made any changes to the dataset.
Here you can see that a report named "EAM-Backlog-Report" have only a ".Report" folder and no ".SemanticModel" folder and that's because it was designed to be connected live to a dataset named "EAM-Backlog Dataset".
But in the "definition.pbir" file, the connection points to a relative path and if I try to open the report, it will not show this message in the status bar:
And you will be able to modify power query scripts, relationships and columns, just as if you openned the actual dataset object instead of the report.
I understand that's how deployment pipelines are able to connect to report to the dataset that is in the same workspace.
But that causes some headaches when using Git repos and the reports are making unwanted changes to dataset.
My request is for reports that have a live connection could use a byPath connection but do not allow modification of the dataset.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.