I created a Power BI report that collects data from:

• a MySQL database (located on the external server)
• a webpage (currency exchange rate table)

When everything worked fine on the Power BI Desktop, I published a semantic model and report on My workspace and tried to refresh it. Refreshes fail!

The failure was the “unavailability of the data gateway (personal mode)“. That was correct, as the data gateway (personal mode) was not running on my laptop. But note! Both data sources are from the cloud! So, no data gateway is necessary.

I experimented. I removed the connection to a web page and left only the MySQL connection — no problem! When I reintroduced a connection to a webpage, a semantic model expected data gateway again.

For a test, I installed the data gateway (personal mode), and when it runs, the semantic model refreshes. However, I do not want to keep my laptop running whenever a refresh is expected.

How can I make the semantic model not demand the presence of an unnecessary data gateway?

The setting page of the semantic model looks like this: