Change Type without Query Editor

Hi Stanmore_1 ,

Thanks for the reply from DataInsights,  please allow me to provide another insight:

Please try converting the data type again in the power query editor without using a relationship. Complex relationships may result in ‘The type of the current preview value is too complex to display’ error.

Alternatively, you can try using dataflow, which is a collection of tables created and managed in the workspace of the Power BI service. A table is a set of columns used to store data, much like a table in a database. You can transform this data into well-formatted, actionable information within it. You can add and edit tables in a data flow and manage data refresh schedules directly from the workspace where you created the data flow.

More details can be found in the documentation: Creating a dataflow - Power BI | Microsoft Learn

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.