Forum Discussion

JoachimSA's avatar
JoachimSA
Helper II
3 years ago

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

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi JoachimSA ,

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

     

    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.

    • JoachimSA's avatar
      JoachimSA
      Helper II
      3 years ago

      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 ?

  • JoachimSA's avatar
    JoachimSA
    Helper II
    3 years ago

    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...