Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

Unexpected attributes returned for DatasourceConnectionDetails

I am using the Admin API to perform Workspace metadata scans.

 

One of the JSON attributes returned is named "connectionDetails" and it is of type DatasourceConnectionDetails.

 

The documentation is here:

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/workspace-info-get-scan-result#datasourcec...

 

The expected attributes include the following:

 

Precision_BI_0-1705696479555.png

 

However, when we use Amazon Redshift, the returned JSON looks like this:

(These are not the actual GUIDs, so don't get concerned and warn me about it)

 

Note that "extensionDataSourceKind" and "extensionDataSourcePath" are not documented (see above).

 

What is going on here, and are there other undocumented attributes that may be returned?

Is the documentation outdated?

 

Precision_BI_1-1705696734314.png

 

Thank you for considering and responding to this post!

 

 

4 REPLIES 4
lbendlin
Super User
Super User

yes, this is typical for an "Extensions"  type of data source. It is assumed that the actual information is squirreled away by the actual extension.

 

What's the problem you are trying to solve?

Anonymous
Not applicable

That makes sense. A piece of commercial metadata processing software has reacted negatively to this.

 

The documentation does not make mention of the possibility of additional attributes. It is worth noting that there are instances of Amazon Redshift connections in this same workspace where the "connectionDetails" attribute contains the "kind" and "path" attributes, and not these "extensionDataSourcePath" and "extensionDataSourcePath" attributes.

 

The documentation should be updated to reflect the fact that additional attributes may be returned, particularly in cases of "extensions". However, this is a certified connector. How is one to know what is native and what is an extension, when certified connectors are, in fact, extensions. Is this documented somewhere?

 

There are fairly large gaps in Microsoft documentation these days compared to the "Books Online" era.

 

Thank you.

Wait until you learn about SIMBA - makes you question if "native"  even means anything.

Anonymous
Not applicable

I assume this refers to the "Simba" drivers from insightsoftware, and not a new acronym.

 

Regardless, we need to find out why the documentation for the DataConnectionDetails attribute is fundamentally incorrect.

 

I sent Microsoft feedback on the page. Hopefully, they will update it accordingly.

 

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/workspace-info-get-scan-result#datasourcec...

 

 

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

Top Solution Authors