PowerBI Dataset connection issue

Hi Gaborfromungarn ,

In this case, you must use the gateway.

//I cannot use any gateway.

If you can't use a gateway, I can only suggest that you start with the location of the data source, for example, if you save the Excel file in the cloud in OneDrive, the dataset will be refreshed in a different way. I don't know what data source you are connecting to with the live connection, is it possible to put the data source in the cloud instead of going to the connected dataset?

If you can install and use the gateway, then the problem will be easy, follow the steps in this post to configure the mapped data source and remember to refresh the dataset at the end.

Solved: How to enable Gateway Connection using Direct Quer... - Microsoft Power BI Community

Best Regards,
Gao
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