Standardize D365 Internal and External Reporting

We're trying to organize our reporting strategy across internal and external consumers. To date, we've only used Power BI internally, using PBI Pro licenses for developers and consumers. While this has worked to this point, we're experiencing high levels of fragmentation across datasets (inconsistent refresh intervals) and we need to standardize the data in preparation for external customers. We've begun experimenting with Dataflows in a PPU workspace, though we're being told this may be overkill and we could accomplish the same goals using PBI-Pro features. We've also been trying to see if an Azure Data Lake would be a better option to create the data warehouse for all reporting Our goals are the following:

• Single-source of truth - all reports using standardized/approved datasets
• Embed to Dynamics 365 Sales - internal consumption with limited Power BI licensing
• Embed to Power Portal - external consumption by non-AD users

Looking for some anecdotes on how people have achieved the goals and what pitfalls we could be walking towards.

Thanks in advance.