Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Developer mode & git for reports with live connection

Hello! I currently have two reports that share the same dataset published, hence are connected to that dataset via live connection   I want to start using version control for this reports and that...
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello

 

I started working with it during the last few days.

But I encountered a very odd behavior:

  1. I create a report and connect it to a Power BI semantic model
  2. I save it as a project
  3. Commit to my Git Repo
  4. Update the workspace connected with my Git Repo

Immediately after the workspace update, Power BI told me that something had been updated.

In fact, Git integration tells me that the report uploaded to the workspace from Git has been changed.

 

I commit the change to Git.

Then, I pull the new version to my local folder and open the report.

 

Now, all tables are converted to Import mode.

The information on the status line at the bottom of the Power BI desktop window has disappeared.

When I open Power Query, I see the M-Code for all tables, which should not be possible with a live connection.

 

The only way to circumvent this is to manually publish my reports to the workspace instead of relying on Git.

 

I hope that this will be changed in the Git integration on the Power BI service.

 

Regards

Salvatore

 

RuiRomanoMS's avatar
RuiRomanoMS
Microsoft Employee
2 years ago

Thanks for the feedback. This behavior is by design, when report and semantic model share the same workspace they get exported to Git with a relative connection: byPath. Learn more here: https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-report#definitionpbir

If you still wish to open the report in live connect, you can temporarily replace the definition.pbir with a by a byConnection connection. But after publishing to service, it will be swapped by a byPath.