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!
Cathrine Wilhelmsen is a Microsoft Data Platform MVP, BimlHero Certified Expert, international speaker, author, blogger, and chronic volunteer. She loves data and coding, as well as teaching and sharing knowledge - oh, and sci-fi, chocolate, coffee, and cats :)
Thank you for this useful tip ! it helped !
Nice one Cathrine, thanks for sharing. Regards, Bhoga
Thanks very much for the tip. I did exactly as you described, searched high and low across the internet, started dabbling the Power BI Powershell commandlets and then found your blog post and there it was, in the URL all along! In my case I was looking for dataflow ID’s to assist me repoint a linked dataflow to a different source dataflow. After much copying and pasting it worked a treat! Happy Days. :-)
Thanks for sharing Catherine, your blogs are super helpful. Much appreciated.