Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Power BI Community!
I am working on a new project for my organization and with new projects come new challenges. I am not sure if I am asking the right questions, but I would appreciate any advice/insights!!
I am working on a Power BI report that pulls data from multiple Excel files. These files will be routinely updated with additional data as quarters close and the data becomes available. Since I do not know if I will always be the report owner or how the files may change hands in the future, I am wondering where and how I should store my PowerBI and source files so that the report is usable in the future. I am concerned that if the source files are no longer accessable for update (or worse, become corrupted), someone will have to set up the entire report again.
Has anyone delt with this issue in their project before? Does anyone have advice?
Thank you!
hi, @CarmelRabin
First, when you complete a Power BI report, you could publish it to power bi service, now it will be stored power bi service.
https://docs.microsoft.com/en-us/power-bi/desktop-upload-desktop-files
You could publish it to a App workspace, then share it with others.
https://docs.microsoft.com/en-us/power-bi/service-create-workspaces
And then you need to set refresh plan for it, see more detail see this post:
https://community.powerbi.com/t5/Service/autorefresh-under-app-powerbi-com/m-p/723300#M70735
And for source files, It's hard to say, that depends on your situation.
You could store it in local or cloud, Then get data from it.
If the data source changed, just download the pbix file from power bi service and open it in power bi desktop to change the data source as below:
https://community.powerbi.com/t5/Desktop/How-to-replace-Data-Source-for-existing-report/td-p/58947
Then republish it and add a new data source in gateway too.
By the way: This requires the source files have the same data structure(same column name and table name)
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |