Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 Reporting