Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Shawn_Eary
Advocate IV
Advocate IV

Does Power Query M Support Push Datasets?

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 PowerQueryM Work for Push DataSets?

Does this mean Power Query M is not supported for streaming Push Datasets?

Confused and Dissapointed,

 

Shawn

1 ACCEPTED SOLUTION
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

1 REPLY 1
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors