Share via

Missing "From Dataverse" option in menu

Anonymous
2022-11-29T02:47:09+00:00

Dear support team

May I know why I cannot see my dataverse table in MS Access?

I have some dataverse tables. Because the limitation of cross-tables query in PowerApps, I would like to use MS Access as my front end and make some query. According to Microsoft documentation (link ), I should be able to add dataverse table into my MS Access application as data source by choose Menu -> External Data > New Data Source > From Online Services > From Dataverse. But I cannot find such a menu item.

Best regards

Ding

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2022-11-29T15:50:43+00:00

Hi,

Your build number means that you have the semi-annual update channel. For this channel, the Dataverse connector will only be available in January 2023.

See this beautiful page, section "How do I get the Dataverse connector in Access?" at the bottom left. I fear you'll look more like the guy in the third picture there.

Servus

Karl

Was this answer helpful?

1 person found this answer helpful.
0 comments

Answer accepted by question author

George Hepworth 22,855 Reputation points Volunteer Moderator
2022-11-29T14:49:30+00:00

Try updating your version of Office then. I see that you are on Version 2202. I have version 2210, which does offer Dataverse as an option.

Was this answer helpful?

1 person found this answer helpful.
0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. George Hepworth 22,855 Reputation points Volunteer Moderator
    2022-11-29T16:21:50+00:00

    I keep forgetting about the impact of the different update channels. :(

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-11-29T03:32:48+00:00

    Thank you for your reply.

    My version is "Microsoft® Access® for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20764) 64-bit". I also attach the version info screenshot below.

    Was this answer helpful?

    0 comments
  3. George Hepworth 22,855 Reputation points Volunteer Moderator
    2022-11-29T02:50:13+00:00

    What version of Access do you have? I believe Dataverse connections are supported in MS 365 and MS Office 2010 Professional. I don't believe earlier versions support connections to Dataverse tables.

    Was this answer helpful?

    0 comments