When Live Service Connection became available as a preview feature in April, it appeared to be exactly the solution our business needed - I could maintain one central dataset and build all my organization's reports from that.
For complicated reasons I am not able to directly access the SQL back-end of our database, so my data model relies on manually refreshing a number of Excel spreadsheets and refreshing the data connections to my main pbix file each day. A number of other reports then connect to that first dataset via the Live Service Connection, which allow me to create different section-specific reports and have them all refreshed when the first pbix file is.
Unfortunately it hasn't worked as expected - while I can personally see all the created reports, the problems occur when sharing with others.
Users are constantly (but unpredictably) faced with dashboard tiles that won't link through to the relevant reports, or warnings that the visualisation is no longer available when live pages are pinned. There's no consistent solution for giving people access, it's a trial-and-error combination of un-sharing and re-sharing dashboards, un-pinning and re-pinning tiles and it's causing massive frustration throughout the company. I've seen (and brought attention to) this situation happening with other users, but there's never really been a satisfactory answer given.
Many users' pro trials are going to expire at the end of July and unless this solution can be fixed, I can't see that the board is going to approve paid licences if this situation stays the same, so I'd really like to know if there's a planned date when this function will be fully supported, as it is really is a deal-breaker for us. Alternatively if someone can suggest another workaround where I don't have to replicate the same database and refresh 30+ pbix files on a daily basis, that would also be welcome!
