half_pint2152
New Member
- Joined
- Mar 23, 2019
- Messages
- 2
Hi all,
Hope all is well
Thanks for taking the time to read this.
I have recently started with Power BI, previously relying on Microsoft Query to pull data into Excel to manipulate.
Looking for any guidance to getting Power BI set up to replace / refresh Microsoft Queries.
In principle I see two options:
1. [Ideal] Transplant & update the Microsoft Query code into Power BI, update and appropriate and draw down directly from the data source into the data model.
2. Make a connection between Power BI and Microsoft Query, essentially Power BI refreshes Microsoft Query and draw in the data through a chain.
I'd appreciate any thoughts / guidance on how to achieve this ?
Thanks in advance!
Hope all is well
Thanks for taking the time to read this.
I have recently started with Power BI, previously relying on Microsoft Query to pull data into Excel to manipulate.
Looking for any guidance to getting Power BI set up to replace / refresh Microsoft Queries.
In principle I see two options:
1. [Ideal] Transplant & update the Microsoft Query code into Power BI, update and appropriate and draw down directly from the data source into the data model.
2. Make a connection between Power BI and Microsoft Query, essentially Power BI refreshes Microsoft Query and draw in the data through a chain.
I'd appreciate any thoughts / guidance on how to achieve this ?
Thanks in advance!