Unable to open PBIX due to M query error

[Anonymous]

I removed a dataset from the Service and need to republish it, however Desktop can't open the PBIX due to the following eror.

I've tried turning off options inside Desktop Options but with no success. Is there any way to get past this kind of error?

[Fowmy]

@Anonymous 

A change or a modification has happened in your source that is feeds the query 'Product - Targets FY'. Please open a blank PBIX file connect to the same source and check.

[Anonymous]

Thanks for replying, @Fowmy 

I actually don't know what the source is - I need to look at the PBIX to find out. Is there a way to do that?

[v-xiaotang]

Hi @Anonymous 

I find similar posts might helpful, please check

https://community.powerbi.com/t5/Desktop/Unable-to-convert-an-M-query-in-table-Dataset-Table-into-a/td-p/1550560

https://community.powerbi.com/t5/Desktop/Error-Unable-to-convert-an-M-query/td-p/1401998

Hope it helps!

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.