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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ranahazim
Frequent Visitor

A table not visible in edit queries

why one of the tables doesnt apear when i open edit querie?

i try to merge 2 tables, one of them is a date table and its not visible when i hit edit query..   

Also it has a lighter table color that i dont understand 

 

here to the left i cant find the date tablehere to the left i cant find the date tableCapture.PNG

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @Ranahazim,

 

Is this DimDate table made with DAX?

 

Table made with DAX are not available in the query editor since this uses M Language for the coding, although some steps when made in the Report Editor appear on the query editor (example: renaming columns or deleting columns in tables) creating a new table in the report view will not have any reflection on the query editor.

 

You can do a DimDate table also on M Language, check this link with the coding and example.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

1 REPLY 1
MFelix
Super User
Super User

Hi @Ranahazim,

 

Is this DimDate table made with DAX?

 

Table made with DAX are not available in the query editor since this uses M Language for the coding, although some steps when made in the Report Editor appear on the query editor (example: renaming columns or deleting columns in tables) creating a new table in the report view will not have any reflection on the query editor.

 

You can do a DimDate table also on M Language, check this link with the coding and example.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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