But first, let me walk you through the process. I elaborate on this at the bottom of this post. Don’t rely on the ability to download from the Power BI Service. The moral of this story: Always create all content in Power BI Desktop if you possibly can. I understand the product team wants everything to work seamlessly for busy users - however, I'd much prefer if it behaved seamlessly with a Power BI Dataset Live Connection for the downloaded file. Then, if you turn around and re-upload the PBIX to the Power BI Service - you end up with a duplicate report and (even worse) a duplicate dataset. Unfortunately it does not download as the equivalent of a Power BI Dataset Live Connection.
Here’s the issue: when you download a web-created report (i.e., created in the Power BI Service), the dataset actually comes with it in the downloaded PBIX file. Conceptually this is a great thing, but in reality the hub-and-spoke model (with the dataset being the hub and the various reports being the spokes) only works well if you generate all reports from Power BI Desktop. If you create a report directly in the Power BI Service *theoretically* this is like using the Power BI Dataset Live Connection, right? Because we are prompted to choose a dataset, this means we are reusing an existing dataset for our new report. These are very valid concerns, but I’ve discovered one additional problem that could easily confuse some people: the side effects experienced if you download then re-upload a web-created report. Reducing the risk of someone overwriting someone else’s work because two different report editing/publishing options are in use. We’d like to have version history available (not available with the web but can be if you store the PBIX file on OneDrive for Business, SharePoint, or a source control repository). Which version is the latest version (if both Desktop and the web are being used by one or more people)? I always recommend to Power BI authors that report creation & editing should happen in Power BI Desktop and to just ignore the edit capability in the Power BI Service. If you agree with me on this one, please vote for this idea here on the Power BI Ideas site. This post is to make you aware that there are some serious downsides when you choose to create reports in the Power BI Service rather than Power BI Desktop.
0 kommentar(er)
