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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
JoachimSA
Helper I
Helper I

Connected Excel Tables from Power BI as Power Query ?

Hi folks,

 

I got this feature running and it is amazing! DAX seems to be changeable, too!

I build some DAX queries in DAX Studio and just pasted them over the one created by the service on export...very slick.

 

To use this effectively now I would like to read this data into my Data model in Excel. At the moment I am importing the Connected table on the spreadsheet to power query which does not seem elegant...especially for larger Tables!
Is there a way to get those connected tables as Queries in my Excel Power Query directly ??

 

Thanks and best regards

4 REPLIES 4
JoachimSA
Helper I
Helper I

I think you understood it right.

I would like to Query my online PBI dataset using the newly announced connected tables. I like that I can produce a flat table using DAX instead of connecting via Pivot Table using "Analyze in Excel". I found this to become rather slow if you need a lot of columns/dimensions to produce a rather wide flat table. Using a DAX expression seems way more adequate.

I would just like to be able to work with this flat table in power query... 

v-rongtiep-msft
Community Support
Community Support

Hi @JoachimSA ,

It seems that I have misunderstod the meaning. You want to connect Power BI dataset in the Excel?

Start in Microsoft Excel to connect to Power BI datasets - Power BI | Microsoft Learn

 

If so, you can refer to the document to see if it helps you.

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-rongtiep-msft
Community Support
Community Support

Hi @JoachimSA ,

You cannot create a DirectQuery / Live connection to an Excel spreadsheet per Microsoft's documentation on Power BI data sources.

 

vpollymsft_0-1675391590106.png

If it still does not help, please provide more details.

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Alright so that means that I would have to import the tble to a spreadsheet inside the excel and then have power query import that table right ?

If I wanted to go straight to power query inside my Excel file I would have to recreate my online Dataset as a Datamart an then use SQL to query it, right ?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors