question

MikeHutchinson-4435 avatar image
0 Votes"
MikeHutchinson-4435 asked emilyhua-msft commented

Can I edit an Excel created/based Power Query in Power BI Desktop

Can I edit and thereby update a query that was created in, and resides in Excel and will it continue to run with all the edits from the Excel workbook in which it is contained?

power-query-not-supportedoffice-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered emilyhua-msft edited

@MikeHutchinson-4435
Based on my research, if I load the one Excel file with queries into Power BI Desktop via "Import data from Excel", some changes of source data in Excel file would be updated to the data on Power BI Desktop.

But there are some limitations, such as you could not modify the applied steps from Excel file in Power BI Desktop, such as the "Grouped Rows" as following image shown. At present, I do not find any related articles that describe these limitations from Microsoft.
83264-capture74.png

Besides, according to this thread "Table.FromRecords(recsList, RecFields, MissingField.UseNull) works in PBI but not in excel", there may be a difference between Excel Power Query and Power BI Desktop in the use of a certain function.

Hope the information could be helpful.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


capture74.png (49.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MikeHutchinson-4435 avatar image
0 Votes"
MikeHutchinson-4435 answered emilyhua-msft commented

Thanks for your reply @emilyhua-msft

I was looking for some of the helps in Power BI (like to tool to view the running steps - forget what that is called)... but sounds like you shouldn't mix Power Query from Excel based queries with m Language as it is in Excel.
From your answer, it looks clear that m code doesn't round trip between the two.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MikeHutchinson-4435
Thanks for your reply.
As I am not a Power BI desktop expert, to better help you, I would also suggest you post a new thread on the following forum.
Microsoft Power BI Community

Thank you for your understanding

0 Votes 0 ·