topic Re: ALM toolkit - working with files once have over-saved in Developer

ALM toolkit - working with files once have over-saved

WHH — Tue, 08 Jun 2021 15:04:40 GMT

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?

Re: ALM toolkit - working with files once have over-saved

Anonymous — Thu, 10 Jun 2021 08:01:09 GMT

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

Re: ALM toolkit - working with files once have over-saved

GilbertQ — Fri, 11 Jun 2021 02:35:30 GMT

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.

Re: ALM toolkit - working with files once have over-saved

WHH — Fri, 11 Jun 2021 07:31:53 GMT

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 🙂

Re: ALM toolkit - working with files once have over-saved

GilbertQ — Mon, 14 Jun 2021 02:43:48 GMT

No worries happy to help!