Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
deepblack7
New Member

In Power BI Desktop, 'Edit query' option is missing for one table.

‎01-31-2023 04:10 AM

I'm trying to locate the data source for one of the PBIX files from a previous developer by right-clicking the table and selecting 'Edit query.' However, I am unable to find the 'Edit query' option for one of the tables. Has anyone encountered this issue before?

QA.png

Labels:
Message 1 of 4
761 Views
0
3 REPLIES 3
BiUSR
New Member

‎04-12-2024 06:42 AM

Hi @deepblack7  were you able to fix the issue?. What was the soultion?

Thanks

Message 4 of 4
365 Views
0
amitchandak
Super User
Super User

‎01-31-2023 06:18 AM

@deepblack7 , Have you created this table in DAX using script

 

like date table using calendar

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here
Message 2 of 4
708 Views
0
deepblack7
New Member
In response to amitchandak

‎01-31-2023 02:39 PM

Hi @amitchandak: Thanks for your reply. I believe this entity was not created using DAX script, otherwise I should have DAX formula showing when clicking the entity name. The issue I'm facing is I just can't locate the source of this entity even from the Power Query Edit model. 

Message 3 of 4
694 Views
0

Helpful resources

Announcements
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!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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

View All