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.
I have a streaming Push Dataset in Power BI that I need to transform. DAX is still confuing me big time. Fortunately, I've found much easier ways to do part of what I want in Power Query M. Unfortunately, when I go to Home / Transform Data, several of the options are missing. Also, the Data and Model buttons are gone from the left hand side of the main Power BI Desktop frame:
Does this mean Power Query M is not supported for streaming Push Datasets?
Confused and Dissapointed,
Shawn
Solved! Go to Solution.
No. Some datasets come in as SSAS tabular models directly and Power Query has no access to those. Connecting to another dataset from a Power BI workspace produces the same, or connecting directly to an SSAS server as well. That too is why your Table and Model views are missing. You cannot change them.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingNo. Some datasets come in as SSAS tabular models directly and Power Query has no access to those. Connecting to another dataset from a Power BI workspace produces the same, or connecting directly to an SSAS server as well. That too is why your Table and Model views are missing. You cannot change them.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |