MS Excel table within Power BI

Can I ask a question - are you actually able to help with this at all?

In any case - here's the response from Microsoft from March 2024:

"

Issue Definition:

Power BI data export as an xls, M parameter part is missing.

Analysis and Resolution: 

I have submitted your request to the Power BI Customer Advocacy Team on your behalf. Power BI team reviews feedback from multiple channels including our public Ideas site , customer engagements and market research. We incorporate and prioritize all of this feedback which is published into our public roadmap in the spring and fall . The team will review your feedback and provide a response to your technical account manager. Getting a response to the request might take couple of months while it is researched and reviewed. 

I want to set expectations early that these requests may not be approved. I recommend looking at workarounds that will let you continue to proceed with your project now, so that you don't lose traction if the request isn't approved, or even if it gets approved and until gets implemented. 

Please also note that if a request is approved but it's not already scheduled within a current development wave, we won't be able to provide an ETA until the next wave is fully planned next semester. It may also get approved into the long-term backlog, for which there are no ETAs until future planning cycles. 

"

Hi Hammad, Microsoft opened a ticket TrackingID#2402230050002261. However they promptly closed it citing the issue as known limitation and asked us to submit a design change recommendation.

Hi Anjan_Madhwesh,

Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you for your understanding and assistance.

Hi Anjan_Madhwesh,

Thank you for coming back and updating us on the status of your support ticket. As Microsoft support team mentioned its a known limitation, you can raise a topic on Ideas Forum or up-vote an existing topic which is related to your issue.

Best Regards,

Hammad.

nope - see above my response above - Microsoft needs to reach out to me. I think we are going around in circles on this topic. Either solve it or move on knowing you can't really solve it.

Did you submit the Business Impact Statement?

So do you have an answer for me?

Hi Anjan_Madhwesh,

Apologies for the delay. The Product Group team will review this issue if it receives enough upvotes from the community.

If you’re facing any other issues, please feel free to reach out here in the community.

Thank you.