Excel power query is not working and show as blank sheet

[Mya2015]

When I click the " from table range" or "blank query" from get transform data under the data tab. . The screen is blank (plain sheet) and can not see anything such as fomula bar, tabel, tabel name. I use office 365 update linsence version and I prepare all advise from the cimmunities (such as clean cach, add in, repaire and update). I already reinstall the office 365.

ow can I slove for that.

[Mya2015 · Accepted solution]

Hi All,

Thank you for the message. I can reslove that issue with the device updated.

[Omid_Motamedise]

The same problem happen for the other files?

[Mya2015]

I typed the some data in enter Data. Then press OK. The query is stilled blank sheet.

[v-aatheeque]

Hi @Mya2015

Apologies for the inconvenience.
Please try to reinstall Power BI Desktop and make sure it is the latest version.
Link : Download Microsoft Power BI Desktop from Official Microsoft Download Center

If you still encounter the issue , Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Microsoft Fabric Support and Status | Microsoft Fabric

 If this solution works for you, kindly click Accept Answer and select Yes for "Was this answer helpful?" Feel free to let me know if you have further questions! 

[Mya2015]

Thank you for your suggesstion. I can transform data in PowerBI. The query does not working in Excel. We  click the from table range, blank query, from folder, from excel file, ect.. the query editor does not work, show as plain sheet and can not edit anymore.

[v-aatheeque]

Hi @Mya2015 

Thank you for reaching out! Based on the screenshot you provided, we understand that you are experiencing an issue with Excel Power Query.

While this forum primarily supports Power BI and Fabric-related queries, we can confirm that you are able to transform data successfully in Power BI.

For Excel-specific Power Query issues like the one you're describing, we recommend reaching out to the Excel or Office community forums, where experts in those tools can provide specialized assistance.

If you encounter any challenges in Power BI or Fabric, feel free to return here, and we’ll be happy to help!

Don't forget to give a thumbs-up to any answers that have helped you along the way.

[Mya2015]

Thank you for the information. I had reach out with office community, they prefer the power bi community.

[v-aatheeque]

Hi @Mya2015 ,

Thank you for providing additional details. Based on your explanation, the issue appears to be related to Excel's Power Query functionality rather than Power BI. While we primarily handle Power BI-related concerns, we want to ensure you're guided to the appropriate resources for resolution.

Our recommendation is to escalate this issue to Microsoft Support for Excel or Office-specific troubleshooting. The support team can conduct a thorough investigation and suggest tailored solutions for your situation.

We hope this helps! Feel free to reach out if you encounter further challenges.

[v-aatheeque]

Hi @Mya2015 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.

In case if you have any resolution please do share that same with the community as it can be helpful to others.

[v-aatheeque]

Hi @Mya2015 ,

we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @Mya2015 

we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

[Mya2015]

This issue is not resloved yet.

[v-aatheeque]

Hi @Mya2015 ,

Apologies for the inconvenience.

Please reach out to support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to support team. Their expertise will be invaluable in suggesting the most appropriate approach.

Please go ahead and raise a support ticket to reach support team:

https://support.fabric.microsoft.com/support

[v-aatheeque]

Hi @Mya2015 ,

We haven’t heard back from you in a while, so we’ll be closing this thread for now. If you still need assistance or encounter any issues in the future, please don’t hesitate to reach out by creating a new post in the Fabric Community.

Thank you for being a valued part of the community, and we’re always here to help when you need us!

[Mya2015]

Yes. All the files. I cannot create new query, Edit query, ect.

[Omid_Motamedise]

Click on the enter Data and insert some data and press ok, then please send me the image again for the result

[dharmendars007]

Hello @Mya2015 , 

Please follow the below steps..

1. Check the Display Settings

1. Full-Screen Mode: Ensure Power BI is not in full-screen mode, which may cause the window to be too large for your screen and hide some UI elements.
2. Zoom Settings: Check the zoom settings in Power BI. If it's set too high or low, it might cause display issues.

2. Clear Cache

Sometimes, cached data can cause Power BI to behave unexpectedly. Try clearing the cache:

1. Go to File > Options and Settings > Options.
2. Under Global > Data Load, click on Clear Cache.

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN