Forum Discussion

rjhale's avatar
rjhale
Helper V
2 years ago

Info.Datasources DAX Function Usage

Hello,

 

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.  

Need Help

7 Replies

    • rjhale's avatar
      rjhale
      Helper V
      2 years ago

      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.