Forum Discussion
Post ProdigyRelation between report in Power BI Desktop
I am curious to know following. When I create the query which pulls the data in my Power BI Desktop and generate say one chart I save this PBIX file on my desktop. After I publish this report to Power BI Service I see exactly same file as it is saved on my desktop but if i edit this in Power BI Service those changes dont reflect the file on my desktop. Can someone explain how this work or point me somewhere where this is explained. During this process when does the dataset gets created?
This depends on what you mean by updating a data set.
Basically, if you are creating a report for your own use only, you can leave it on the desktop.
A Service allows you to share reports with others.If you mean a change that you want to initiate (a measure, column, table for data has been expanded, permanent visual changes, etc...) then a PBIX file is acceptable.
When you have made changes to your desktop PBIX file, you need to reshare your PBIX file to Service.
The term "update" refers to refreshing the data as a result of a change in the source of the data.
You have added orders to an order table, for example.
Depending on the type of data source, this is a refresh operation that needs to be defined in the service.Visit the following link for more information:
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
If my answer was helpful please give me a Kudos and accept as a Solution.Yes.
Plese see an attached picture .The following is taken from the Microsoft document at the following link:
https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboard-tiles
If my answer was helpful please give me a Kudos and accept as a Solution.
8 Replies
- Ritaf1983
Super User
Hi stribor45 .
Once the PBIX file is published, there is no connection between it and the service report or data set.
It is best practice to edit your PBIX file and republish it once you have made the changes.
Everything related to development is done on the desktop, and Service is a platform for sharing and reading
If you still want to add changes to the report through the service, you can download it as a PBIX file (See the attached image below). Save it as a file that will be associated with the report from the moment it is executed.Here is more information about best practices:
https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-best-practices.
If my answer was helpful please give me a Kudos and accept as a Solution.
stribor45When you say Service is a platform for sharing and viewing it how come I can edit it? At what point in this process dataset get created?
- Ritaf1983
This depends on what you mean by updating a data set.
Basically, if you are creating a report for your own use only, you can leave it on the desktop.
A Service allows you to share reports with others.If you mean a change that you want to initiate (a measure, column, table for data has been expanded, permanent visual changes, etc...) then a PBIX file is acceptable.
When you have made changes to your desktop PBIX file, you need to reshare your PBIX file to Service.
The term "update" refers to refreshing the data as a result of a change in the source of the data.
You have added orders to an order table, for example.
Depending on the type of data source, this is a refresh operation that needs to be defined in the service.Visit the following link for more information:
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
If my answer was helpful please give me a Kudos and accept as a Solution.
