Today, I had to get a single dataset ID from a report I had deployed to the Power BI Service. I quickly realized I had no idea where or how to get it! Turns out, it’s super easy to find – if you know where to look :)
Since I had to click around for a bit, do some searches, and get sidetracked in the REST APIs and PowerShell Cmdlets before I finally realized the ID was staring me right in the face all along, I figured I’d share this quick tip. That way, the next time I search for it, I might find my own blog post :D And who knows, maybe it can help one or two others?
The Dataset ID is part of its URL!
The heading above says it all, really, but we like pictures! :)
First, navigate to your datasets. Then, click the ellipsis next to the dataset and click Settings:
If you are anything like me, you may be looking around the dataset settings page. Maybe you click all the little options to expand them. You are so close! The dataset ID is actually part of its URL:
A-HA! It didn’t occur to me to look at the URL at first. But once you see it, it’s completely obvious, right? :)
This same approach also works for getting IDs for other things like workspaces, dashboards, and reports. It’s a quick and easy way of getting one or a few IDs.
What if I need to find all IDs?
However, if you need to work with many objects or find many IDs, you definitely don’t want to click around in your browser for hours! Use the REST APIs or PowerShell Cmdlets instead. Adam Saxton from Guy in a Cube has a great video on this called Power BI PowerShell and the Admin API. Check it out!