Store unchanging data in Power BI (MySQL)

[richardmayo]

We have moved our systems from an old MySQL database-driven application to Business Central.

Currently, I have a dataset which connects to the old MySQL database (through a personal-gateway) along with other connectors to Business Central and some online Excel files.

Since the MySQL database will no longer change, is there a way I can permanently import the data into the dataset so that everytime we refresh the dataset I does not need to connect to the MySQL server (also I would be able to stop using the personal-gateway).

[v-robertq-msft]

Hi, @richardmayo 

Has collinq’s reply helped you to solve this problem? Would you like to mark his reply as a solution if it’s useful so that others can learn from it too?

Thanks in advance!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[collinq · Accepted solution]

HI @richardmayo ,

If the datasource is not going anywhere, you could just disable the "enable refresh" on the query.  However, it sounds like you want the "table" to be permanently inside Power BI.  That is a bit different than just getting data routinely from a data source.  If I understand the question correctly, you are wanting a static table inside of Power BI.  Here are some links for how to do that:

Create Static Tables in DAX Using the DATATABLE Function - SQLBI

How To Create Static Table Using Data Table In Power BI (loginworks.com)

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!