Forum

Convert Query in PB...
 
Notifications
Clear all

Convert Query in PBIX to XLSX

2 Posts
2 Users
0 Reactions
832 Views
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
Topic starter
 

@Riny van Eekelen,

I'm looking for a solution of this same problem to Power Query in Excel described here

Importing Multiple Tables from Multiple Excel Files | Power Query | Excel Forum | My Online Training Hub

Can you help me and convert pbix-file to xlsx-file?

 

Thanks from Luschi / Leipzig-Germany

 
Posted : 17/03/2023 1:33 pm
Riny van Eekelen
(@riny)
Posts: 1191
Member Moderator
 

I'm not aware of an option that lets you convert a pbix file to xlsx. The OP in the thread you referred to used Power Query within Power BI to connect to multiple files. You can just copy the query(s) from a Power BI file and paste them into PQ for Excel. That should work just fine. Obviously, you need to set the Source for each query to point at the relevant file location(s) on your own system.

 
Posted : 18/03/2023 2:30 am
Share: