cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DivakarKrishnan Frequent Visitor
Frequent Visitor

To View Specific table name and column name

Dear Team,

 

I am new to Power BI development.

 

I am facing one issue in existing Power BI workspace where data is not refreshed correctly.

 

Inside the edit queries, i can see multiple queries (sales1, sales2) and all are using Microsoft SQL DB. I want to see which SQL table /  specfic column has been used particularly in sales1 queres. Please let me know on how to check this asap. Thanks!

 

Thanks,

Divakar

 

 

1 REPLY 1
Community Support Team
Community Support Team

Re: To View Specific table name and column name

hi, @DivakarKrishnan 

In Edit Queries, Click QUERY SETTINGS to view every step of the query 

or in Advanced Editor to see all the query.

You could see which SQL table /  specfic column has been used particularly.

5.JPG

6.JPG7.JPG

 

And also you could refer to this blog:

https://www.mssqltips.com/sqlservertip/4563/power-bi-native-query-and-query-folding/

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.