Excel Workbook Data and Single Sign-on Issue

I learned that using Single Sign-On data query models causes loading issues with reports while using Publish to Web. In my case, I import Excel Workbooks from Microsoft 365 into the Power BI Service and use DirectQuery to create relationships and use measures. Has anyone found a workaround for this issue? I was told to use Datasets instead of Datamarts, but I need to make connections through modeling and want to be able to share Excel files within my organization so the data can be refreshed.