Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am running desktop version 2.110.1161.0 (October 2022). I want to switch my report from DirectQuery mode to Import mode. When I am in Model view and I click a table, the Advanced section is not appearing in Properties. I have also tried this with a brand new report connected to a single table via DirectQuery.
Solved! Go to Solution.
Hi , @Believer
According to your description, your current situation cannot be converted to import mode.
The reason is because the connection mode used when connecting to datasets in Power Bi Desktop is Live Connection.
If we are currently connected to a data source, and when we connect to the dataset, the system will be prompted to change the Live Connection mode to Direct Query mode by default.
This is a new feature that allows us to connect to other data sources in Live Connection mode.
For more information, you can refer to :
Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Learn
Connect to datasets in the Power BI service from Power BI Desktop - Power BI | Microsoft Learn
And for this function, after converting the Live Connction mode to the Direct Query mode, we can no longer convert the Direct Query mode to the Import mode.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@johncolley , @v-yueyunzh-msft I do not see that message at the bottom of the screen. Starting from a new report, Get Data, Connect to dataset, then I see this message: "Connected live to the Power BI dataset: <dataset name> in <workspace name>. Make changes to this model." The last part is blue and clickable. Before I click it, on the Model tab, the Properties pane is disabled for all tables. After I click it to add a local model, the message changes to "Storage Mode: DirectQuery". In the Model tab the Properties pane is enabled, but no Advanced section.
Hi , @Believer
According to your description, your current situation cannot be converted to import mode.
The reason is because the connection mode used when connecting to datasets in Power Bi Desktop is Live Connection.
If we are currently connected to a data source, and when we connect to the dataset, the system will be prompted to change the Live Connection mode to Direct Query mode by default.
This is a new feature that allows us to connect to other data sources in Live Connection mode.
For more information, you can refer to :
Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Learn
Connect to datasets in the Power BI service from Power BI Desktop - Power BI | Microsoft Learn
And for this function, after converting the Live Connction mode to the Direct Query mode, we can no longer convert the Direct Query mode to the Import mode.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Believer , That's the intended behaviour. Please read these links for more information:
- https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
Hi , @Believer
If you're connected by Direct Query, you'll see the message "DirectQuery: Enabled (Click to Change)" in the status bar at the bottom right hand screen on Power BI Desktop:
Second, if you switch from Live Connection to Direct Query mode, you can't convert to Import mode.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Believer, Strange that the advanced option isn't showing up there. Can you see this option along the bottom of your PBI Desktop window? And what is the data source type?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |