This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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 PowerQueryM Work for Push DataSets?
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 ReportingCheck out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 6 | |
| 6 | |
| 4 |