Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |