Forum Discussion

pgelli's avatar
pgelli
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Get Table information from dataset Programmatically

Hi All,   Is there a way to programatically get the information of datasource & tables used in a dataset (like some kind of metadata).  I saw there is a GetDataSet API, but that works on the datas...
Need Help
pgelli's avatar
pgelli
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

I verified that I am looking at right dataset. However, PowerBI report is built using "import" and not "direct query".
Does it make a difference lbendlin ?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

No, once you access the dataset it doesn't matter much if  the query connection type is import/ direct query or mixed.  

 

I just tried it with one of my direct query datasets and got the expected result. 

 

As expected it will not work at all with live connections.