Forum Discussion
Super UserHow to convert DirectLake to Import Mode?
HI jaryszek,
Thank you Kedar_Pande, for your insights.
The issue arises because Direct Lake models do not use standard data source connections or credentials. When converting the model to Import mode with scripting, a valid data source including connection details and authentication is not automatically set up. In Power BI, the “Data source credentials” option appears only when a properly defined data source is present. Since the converted model lacks this configuration, the option is not shown. To resolve this, connect the model to a supported data source (like a Lakehouse SQL endpoint or Warehouse) with a valid query and credentials. Alternatively, recreating the model in Import mode using Power BI Desktop is a recommended and supported method to ensure proper setup.
Thank you.
Super Userthank you, I am not using snowflake.
partition.DataSource = Model.Model.DataSources.First();
What is a snowflake query ?
Best,
Jacek
Community SupportHI jaryszek,
Thank you Kedar_Pande, for your insights.
The issue arises because Direct Lake models do not use standard data source connections or credentials. When converting the model to Import mode with scripting, a valid data source including connection details and authentication is not automatically set up. In Power BI, the “Data source credentials” option appears only when a properly defined data source is present. Since the converted model lacks this configuration, the option is not shown. To resolve this, connect the model to a supported data source (like a Lakehouse SQL endpoint or Warehouse) with a valid query and credentials. Alternatively, recreating the model in Import mode using Power BI Desktop is a recommended and supported method to ensure proper setup.
Thank you.