Skip to content

How to find a Dataset ID in Power BI

Find Power BI Dataset ID

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!

Who is Cathrine Wilhelmsen?

Cathrine is a Microsoft Data Platform MVP, BimlHero, Microsoft Certified Solutions Expert, author, speaker, blogger and chronic volunteer who loves teaching and sharing knowledge. She works as a Senior Business Intelligence Consultant in Inmeta, focusing on Azure and the Microsoft Data Platform. She loves sci-fi, chocolate, coffee, craft beers, ciders, cat gifs and smilies :)

Comments

Hi! This is Cathrine. Thank you so much for visiting my blog. I'd love to hear your thoughts, but please keep in mind that I'm not technical support for any products mentioned in this post :) Off-topic questions, comments and discussions may be moderated. Thanks!

Click to Show / Hide Comments