ALM toolkit - working with files once have over-saved

[WHH]

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? 

[GilbertQ]

No worries happy to help!

[GilbertQ · Accepted solution]

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.

[WHH]

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 🙂

[v-yiruan-msft]

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