How to create a Shortcut to Dataverse
You should be in the Lakehouse lh_FAIAD. Make sure you are in Lakehouse view (not SQL analytics endpoint).
- In Explorer panel, select the ellipsis next to Tables.
- Select New Shortcut.
- New shortcut dialog opens. Under External sources, select Dataverse.Note: In the previous lab, we followed similar steps to create a shortcut to Azure Data Lake Storage Gen2.
- Select Create new connection (1), Connection settings dialog opens. Enter
org6c18814a.crm.dynamics.com(2) as Environment domain. - Leave Authentication kind as Organizational account (3).
- Select Sign in if you are not already logged in.
- From the sign in dialog box, select the user account you have been using for these labs. Note: Your account will be different from the screenshot below.
- Select Next in Connection settings dialog.You will be navigated to a dialog where you can pick the different bucket/directory from Dataverse. Notice there are a lot of different buckets available. We could pick the bucket(s) we need and follow the process like Lab 3 (use Visual query to transform data and create views). We could also use Dataflow Gen2, like we used earlier in this lab to connect to SharePoint. However, we do not have access to these bucket/directories.In our scenario, the IT team has already established a link to Dataverse and applied the necessary data transformations, mirroring those in the Power BI Desktop file. They have ingested this data into the Lakehouse in the Admin workspace and given us access to the table(s). Since our IT team has done all the hard work, we can create a shortcut to this Lakehouse in Admin workspace.
- Select Cancel in the New shortcut dialog to navigate back to the Lakehouse.
