Support for Converting Live Query Connection to Import Mode

[jrmahesh7]

I would like to request the ability to convert a live query connection to import mode in Power BI. This feature would be extremely beneficial for scenarios where users need to switch from a live connection to an import mode without rebuilding the entire report. It would save time and effort, especially when dealing with complex reports and datasets.

Benefits:

• Flexibility to switch between connection modes based on project requirements.
• Improved efficiency in managing and updating reports.
• Enhanced user experience by reducing the need to recreate reports from scratch.

Thank you for considering this feature request.

[v-sathmakuri · Accepted solution]

Hi @jrmahesh7 ,

I hope this information proves helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.

Thank you!!

[v-sathmakuri]

Hi @jrmahesh7 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-sathmakuri]

Hi  @jrmahesh7 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thanks!!

[v-sathmakuri]

Hi @jrmahesh7 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin  for the prompt response.

If your dataset has already been created using a Live Connection, you cannot directly switch it to Import Mode. Unfortunately, to use Import Mode, you would need to rebuild the report from scratch using a new connection.

If you find this limitation inconvenient, I recommend submitting your detailed feedback and ideas through Microsoft's official feedback channels, such as the Microsoft Fabric Ideas.  

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

[lbendlin]

Sadly you can already do this. Use the "Analysis Services"  connector and then choose "Import".  

Your listed benefits are outweighed by the loss of agility , the breaking of the security chain, and the newly added overhead of having to manage the import schedule.