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.
I've been using PowerBi now for a month and increasing my skills rapidly.
We have large excel models and I am making one sheet in these a "datasheet to PowerBI" output page.
The data model is accepted by PowerBU and I have made nice dashboards and visualisations.
BUT, when I update from a new version of the excel file (all columns are identical , no change to structure)
- the visualisations all crash and I have to drag and drop and format again.
Is it supposed to be like this, should I do it another way?
PowerBi accepts the new data sheet, I have access to all the data, but the visualisations just crash
My question is essentially : if all columns are identical, and I am careful -
will I be able to update data from another file and keep the existing visualisations / diagrams?
I have tried to google and not managed to get help on this.
Solved! Go to Solution.
Hi @Anonymous ,
My question is essentially : if all columns are identical, and I am careful -
will I be able to update data from another file and keep the existing visualisations / diagrams?
For your question, the answer is "Yes". You can change your data source like so:
And you can also refer to this document: Using templates in Power BI Desktop.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
My question is essentially : if all columns are identical, and I am careful -
will I be able to update data from another file and keep the existing visualisations / diagrams?
For your question, the answer is "Yes". You can change your data source like so:
And you can also refer to this document: Using templates in Power BI Desktop.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |