Mixed storage mode: Live connection + Direct Query

Hi thhmez7 ,

So far, Power BI provide three connection types to connect data source, they are Import, QirectQuery and Live Connect. Live Connect is used for ssas,aas and power bi dataset , and cannot combine with other connection types. but you can change Live Connect to Direct Query for as and power bi dataset.

For three connection types ,please read these documents: Power BI Connection Types: DirectQuery, Live, or Import? Tough Decision! - RADACAD , Using DirectQuery in Power BI - Power BI | Microsoft Docs 

For  change Live Connect to Direct Query, please read this document:  Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.