I created a Power BI report that collects data from:
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?
Finally, I managed to get rid of the annoying problem.
The problem was that the working folder in which I had saved *.pbix files locally (before publishing them to the Power BI service) was synchronized with the OneDrive cloud. This most likely creates a conflict with the Power BI automatic update mechanism.
I did the following: