Explode Date Range

Hi All,
Firstly  johnt75 thank you for your solution!
And Anonymous , If your data is stored in SQL Server Analysis Services database, you can use power query in import mode to make changes.
However, in the case of a live connection, Power BI connects directly to the SSAS server and the query request is processed by SSAS and the data is not stored in Power BI. Therefore, Power Query cannot be used to perform any transformations or cleansing operations on the data.
All calculations and data summarization are done in SSAS, and Power BI is only used as a front-end presentation tool.

If you have any further questions, you can check out the documentation I found for you on the subject.
I hope this helps, and I would be honored if I could solve your problem!
DirectQuery in Power BI - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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