This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
So, we're building a report that contains links to other reports. This is working fine and we're building report URLs using data pulled from the backend of Power BI (Report ID, Report Name, Workspace ID, Workspace Name etc). However, a colleague pointed out that many people don't have access to a report directly but access them via apps. So, I set about building a URL for the relevant apps. But, I've hit a snag.
Report URLs are comprised of hard-coded parts like 'https://app.powerbi.com/' and workspace and report IDs. But an app URL appears to have an ID I can't find. Here's an obviously anonymised example:
So, if building the URL the blue section would be hard coded and the green would be the app ID. However, where does the red ID come from? I can't find it in any of our extracted data?
Solved! Go to Solution.
ctid is your company tenant ID . It is not a required part of the URL and can be safely omitted.
ctid is your company tenant ID . It is not a required part of the URL and can be safely omitted.
Perfect! That'll explain why I can't find it in the data.
Thanks!
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 40 | |
| 37 | |
| 31 | |
| 23 | |
| 15 |
| User | Count |
|---|---|
| 76 | |
| 59 | |
| 31 | |
| 31 | |
| 25 |