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.
Dear Friends,
I have faced a problem in PBI.is there any soloution that a summarized table created by DAX formula bring in query editor.Seems that only the source tables can be seen in query editor?
Thank you,
Medi
Not like tables(queries) created in Query Editor can be shown and referenced in Data View of Power BI Desktop, the calculated tables created in Data View using DAX can only be used within Data View.
In this scenario, you may need to rebuild that table in Query Editor using M Query. Here is a similar thread for your reference.
Regards
Hi Medi,
You should download the DAX Studio. Connect Your PBI File with DAX Studio and Run your DAX Query againest the Model and set the output to the Text File. This File will have your Summerized table Data and You can ETL with this data into the PBI.
Correct. You would have to create a new query and do your summarize in the query editor instead.
Covering 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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |