cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qsong
Helper II
Helper II

Advanced editor for live connection to Azure Analytics Service

Hi everyone,

 

I am wondering if there is an advanced editor for live connection to Azure Analytics Service. Once the data are loaded, I am not able to open edit queries option. 

 

I am asking for that because I need to copy M script and paste it in the blank query of the dataflow. If advanced query is not available in this case, should I choose import mode instead of live connection mode?

 

Thank you

 

Best, Qianru

1 ACCEPTED SOLUTION
d_gosbell
Super User II
Super User II

There is no M script when you have a live connection to Azure AS. Power BI fires DAX queries directly at the Azure AS data model, there is no M involved.

 

If you want to use dataflows you could do import from Azure AS. But I think you would be better off opening up the Azure AS solution and coping the M queries from there so that you are pulling data from the original source system. Tabular models are not well suited for dumping large volumes of detailed data. They are really designed for doing high speed aggregations.

View solution in original post

1 REPLY 1
d_gosbell
Super User II
Super User II

There is no M script when you have a live connection to Azure AS. Power BI fires DAX queries directly at the Azure AS data model, there is no M involved.

 

If you want to use dataflows you could do import from Azure AS. But I think you would be better off opening up the Azure AS solution and coping the M queries from there so that you are pulling data from the original source system. Tabular models are not well suited for dumping large volumes of detailed data. They are really designed for doing high speed aggregations.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors