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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Otto_Luvpuppy
Helper II
Helper II

Using DAX in the Advanced Options area of Power BI Data import

Hi,

Does anyone know where I can find some documentation, or examples, of DAX queries being used in the Advanced Options area of Power BI data import?

I have an Azure Analysis Services data set that I want to pre-filter before I import it. The reason I'm not using Live Connection is because I want to try to reduce the data set and Live gives me the whole thing whether I'm using it or not, so I'm trying to retrieve the relevant tables only...I can do this but the data is still too large to import....hence the pre-filter.

Any ideas?

Thanks

6 REPLIES 6
Otto_Luvpuppy
Helper II
Helper II

Thanks for the response on this one. Yes, I kind of knew that wasn't the way to go but I'm actually trying to get around another problem by pulling the data into a dataflow as I want to restrict what is coming down the pipe. As you say the 'cube is ginormous' and my Measures are taking an age.......I'm probably barking up the wrong tree but the dataflow was worth a try I thought.
Thanks

Use Performance Analyzer and DAX Studio to improve measure performance. Use fewer visuals to improve the UX.

Yep...done that already. I have 80+ Measures and I'm only loading subsections of those into simple tables at the moment. Can still take 10mins+ to load. I think I need to move them to calculated columns so they are only refreshed once/twice a day. Still can't work out why they are taking so long though...not complext measures at all really.

Thanks

That's not really an option in an Analysis Services source situation. In DAX Studio look at the query plans and identify the spots where large loops are happening. Then rewrite your measures to avoid these large loops.

😁If only I were that proficient with Dax and Dax Studio...I'm getting there but at the moment not nearly good enough. You may as well ask me what blue smells like 😂

 

Thanks for your interest though...much appreciated.

lbendlin
Super User
Super User

DAX is used to query data for visualization. It is not an ETL/ELT language.  For that you use Power Query.

 

You don't really import data from an Azure Analysis Services connection. Well , you do, but only the data that is required to render the visuals on the first page the user sees.  So that rendering performance depends on the number of visuals on your page, the complexity of the measures involved in pulling the render data, and the overall performance of your data source.  If you are nimble with the measures and frugal with the visuals then you can connect to ginormous cubes with little to no delay. 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.