I recently chronicled my first attempt at using Access’ DataVerse export ‘feature’:

Access - My First Venture Into Dataverse

I had a new client for whom I thought Dataverse might be a perfect solution to their need. So I set out to give it a whirl and see if Dataverse could do the job, see if the hype and demo I had been shown by Microsoft lived up to their ‘promise’. The proverbial ‘kick…

Continue reading →

Access – My First Venture Into Dataverse Part 2

So I’ve been playing around with Dataverse a little more today in a continuation of yesterday’s fiasco!  So if you haven’t already seen my previous post, best start by reviewing: Below are my preliminary observations and my impressions may change with time and experience, but as of today, this was my impression of things.  

After many, many hours of work I got enough functional that I wanted to provide a demo to a client.  The question then became, HOW?  Since it is linked to my Account, how can I share it out to an external user.

How can I share a set of tables, not all the tables, with an external user?

I played around in the DataVerse Table admin pages and found nothing remotely about security and/or permissions.

Then I decided to ask the Access Dev Team directly, as surely they would know, this had to have been planned for!  Sadly, I was informed they didn’t know and it was more an Azure question.

I spent 2 days, looking here and there, trying all sorts of things, turning in circles through the labyrinth that is the admin centers in Microsoft’s WWW (Microsoft, Office, PowerApps, Azure, …), posting in forums, to ultimately never manage to successfully do so.  So I then decided to try using Microsoft support.

After submitting the ticket, an hour or so later I received the following confirmation

Continue reading →