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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper IV
Helper IV

Info.Datasources DAX Function Usage



I'm attempting to use the new DAX function Info.Datasoureds() for the first time.  I attempted to use this in the DAX query view in a pbix that has a number of queries loaded to the data model, but the function returns a completely empty table with columns such as ID, ModelID, Name, Description, Type, ConnectionString, etc.  I also tried connecting to several published semantic models using analysis services and running a DAX query that calls that function, but again, those return blank tables. 


Does anyone have any suggestions on how to use this function or if I need to call it in a different way to return metadata about the sources used in each model?  I was hoping I could use this as a way of easily pull in data source information across a lot of models spanning a dozen or so workspaces.  

Community Support
Community Support

Hi @rjhale ,


Thanks for @lbendlin  reply, here's a relevant sample you can refer to:DAX query view introduces new INFO DAX functions | Microsoft Power BI Blog | Microsoft Power BI


Hope it helps!


Best regards,
Community Support Team_ Scott Chang


If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User


Thanks.  That's good to know.  Do you have any other insight into why INFO.DATASOURCES function returns blank values? 


Also, I don't suppose there is a way to get the connection details for queries that don't get loaded directly into the model?  For example, we may merge data from a power bi dataflow with a SQL source, but that dataflow query will have "Enabled Load" disabled.   


Interesting.  That does look promising.  


Before I mark this closed though, can someone explain what INFO.DATASOURCES is used for or how to get it to return values? 

The documentation on that on is, uhm, sparse.



Right. I was seeing the same thing.  That's why I posted here, and I was hoping someone from Microsoft might weigh in with more info about intended use, a roadmap, or something like that.  

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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