I have searched the forum, and the internet, without finding an answer to my 4 questions below.
Working with a program called Accelo, an ERP, it creates its own PBI app and dataset in the PBI service. The software has basic reporting built into PBI and allows us to connect with PBI Desktop for custom reporting.
When connecting from PBI Desktop the only option is a live connection to the dataset. Once established I can create custom reports however I have found a number of limitations around this.
As such is there a better way to do this? What do you recommend? My main points of concern are the following;
I can not add new tables (no measure grouping, no date table, no supporting tables). The options are grayed out.
What happens if the application changes, renames, or restructures the dataset? I would lose all my design work and measures?
What happens if the dataset is deleted? By the program, or by accident. Is there a way to back this up?
Without being able to add a date table, how can we do advanced time intelligence?
Thank you in advance for any recommendations!