Forum Discussion

WHH's avatar
WHH
Frequent Visitor
5 years ago
Solved

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...
Need Help
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    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.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

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's avatar
WHH
Frequent Visitor
5 years ago

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 🙂