Is it possible to import tables from a sql server connection? Desire to use power bi service offline

[CarlSagan]

I have a project that is using tables from dataverse and sql server.  I know my dataverse table source settings are set to import and I want to do the same for my sql server tables that currently have an active connection in order to access the data.

When using the front-end of power bi with the report builder and I hover over a particular table, it tells me the storage mode is Import. When I try to use the app offline the visuals break.

So I go into the back-end of power bi (power query/transform) and open the settings for the source and all it shows is a dialog box for the sql server connection.

Hopefully that makes sense. I'm trying to use the app in an area that may not receive great connection so the tables need to be stored offline aka import.

[v-yaningy-msft · Accepted solution]

Hi, @CarlSagan 

Power BI supports importing data from SQL Server using Import mode, but please note that Power BI Service is a cloud-based service and does not support offline use.

How to connect SQL Server: Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum