Combining Static and Live Data

Hi  Anonymous ,

If you have a data source in Direct query connection mode, you can add a data source in Import connection mode for example (import the table from excel to power bi)

If you have a data source in Live Connection mode, you can convert Live Connection to Direct Query through File - Options - Select Preview features - DirectQuery for PBI datasets and AS in Power BI Desktop. Then add other data sources.

But in Visual, it can only be static data or dynamic data, and cannot be presented in the same visual. You can try to use the new function field parameter

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Docs 

Best Regards,

Liu Yang

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