Forum Discussion
ALM toolkit - working with files once have over-saved
Hi all,
Just curious about ALM toolkit, I have done a little bit of playing with it, it seems so potentially useful. Then I realised that if you use it once then you cannot download the dataset as a pbix anymore (see previous question here).
How do people continue to develop and maintain the dataset if you can no longer download it as a pbix?
Hi WHH
ALM Toolkit is ideally designed to be used for the dataset.
I typically have a seperate dataset in the PBIX file, to which I deploy with ALM Toolkit.
I then create a PBIX file which connects to this dataset for the report. This way my PBIX reporting file is small and easy to make the required changes.
4 Replies
Hi GilbertQ ,
I tried to search for some relevant information about ALM toolkit and tried whether there is a suitable way to achieve it, but all failed. I wonder if you can help look at this topic and give WHH some suggestions? Thanks for your time and help in advance. Much appreciated!
Best Regards
- GilbertQ
Super User
Hi WHH
ALM Toolkit is ideally designed to be used for the dataset.
I typically have a seperate dataset in the PBIX file, to which I deploy with ALM Toolkit.
I then create a PBIX file which connects to this dataset for the report. This way my PBIX reporting file is small and easy to make the required changes.Thank you very much GilbertQ for this insight 😀
I have just tried this out and it works really well, thank you. I can open a new report in desktop, live connect to the model in the workspace, then I can add tables to this and push the changes to the workspace. This is really helpful!
As the tables from the workspace-dataset don't appear as queries in the Desktop Power Query I wasn't able to amend any of the existing tables, i.e. add or remove a column to/from an entity already in the dataset. Is there a workaround for this?
I'm not at all trying to critisise this tool, just trying to learn how and when I can use it 🙂
- GilbertQ
No worries happy to help!
