System dataverse tables cant be linked to via shortcut

[wilson_smyth]

Shortcuts in fabric initially looked to be a massive time saver if the datasource was primarily a dataverse.
We quickly found only some tables are available, in particular system tables are not.
e.g. msdyncrm_marketingemailactivity, although listed as a "standard" table in power apps UI, is a system table and so is not available for shortcut. 

There are many tables like this.

Its another example of a potentially great feature in fabric being released half baked.
Besides normal routes of creating a data pipeline to replicate the data in a lakehouse or warehouse, are there any other simpler options that I am missing here?

[burakkaragoz]

Hi @wilson_smyth ,

Just checking in. Did the previous suggestions help resolve your issue?
✅ If it’s working now, feel free to mark the response as the Accepted Solution. This helps others who face the same issue find the fix faster.
✨ And of course, a little Kudos would be much appreciated!
If you're still running into trouble, let me know what you've tried so far and I’ll help you dig deeper. We’ll get it sorted!

[v-vpabbu]

Hi @wilson_smyth,

Thanks @burakkaragoz  for addressing the issue.

As we haven’t heard back from you, we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[v-vpabbu]

Hi @wilson_smyth,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Vinay Pabbu

[burakkaragoz]

Hi @wilson_smyth ,

You’re definitely not alone in noticing this! Right now, system tables in Dataverse (like the one you mentioned) unfortunately aren’t supported for Fabric shortcuts. It can be pretty frustrating, especially when they show up in the UI but aren’t actually available to use.

As of today, there isn’t really a “shortcut” (pun intended) around this—replicating the data through a pipeline or exporting to a lake/warehouse is still the main route. I know it’s not ideal, but Microsoft hasn’t enabled direct shortcut access for those system tables yet.

If you want to avoid building a full pipeline, some folks have used Power Automate flows or custom connectors to pull limited data on a schedule, but that’s more of a workaround than a real solution.

Hopefully, with enough feedback, Microsoft will expand shortcut support to cover system tables soon. If you haven’t already, it might help to add your vote or comment to relevant ideas on the Fabric/Power Platform feedback pages.

If I hear about any new tricks or updates for this, I’ll reply back here!

Let me know if you want more details on any of the workarounds.