Publishing failed for an unknown reason

I built it up step by step as you described. Was fine until I added the OLEDB query and when I tried to publish that version it succeded but said that it couldn't refresh the dataset and that I'd have to manually do it in the service (which makes senses I guess as it a local db. However, once I add the visuals to the dashboard and tried to publish, it failed with the same error as before ("unknown reason"), and even stepping back afterwards to just the data queries without the visuals did not resolve the error, until I removed the OLEDB query. So it does seem to be the OLEDB query, which makes sense I guess, just wish the error could be more descriptive, like "unable to connect to database". Anyway to set something like VPN settings for the Power BI Service to connect to a locally hosted database?