Today, November 7, 2022, I saw that Microsoft has finally launched Direct Query, which allows users to connect to an existing PowerBI dataset. I've been waiting for this feature since I started using PowerBI and PowerQuery in 2018.
It does appear to be in Beta, and so I did have to enable the ability to Preview this feature, but I got prompted as soon as I selected the option to connect to PowerBI Datasets, and the directions were easy to follow.
Since it's brand new, I'm obviously still playing around with it, but was glad to see that my favorite datasets were easy to connect to once the option was selected. I'm really hoping this functionality improves some refresh times. Instead of reconnecting to a source and performing the necessary transformations, I'm optimistic that I'll be able connect directly to the transformed dataset going forward.
Instructions
Ready to get started? Here's a link to Microsoft's instructions for Connecting PowerBI reports to existing PowerBI datasets.
Here's the link to Microsoft's instructions for Connecting Excel to existing PowerBI datasets.
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-power-bi-datasets-excel
Have you tried Direct Query? Please leave comments on your experience below.
Prior post: Combine All Files in a Folder
Next post: Convert PDF using PowerBI
No comments:
Post a Comment