Forum Discussion
Publishing failed for an unknown reason
Community ChampionIf you create a new file, do you get the same issue? For example, create a new file and just copy over the lookup tables. Publish. Then add in the web query. Publish. Add in the OLEDB source, Publish and then build reports and Publish iteratively. Interested if you can publish anything at all.
Good idea, I'll give it a try and report back. Does the trace give any indication of the issue?
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?
Hi sgruber,
>> Anyway to set something like VPN settings for the Power BI Service to connect to a locally hosted database?
You can use personal gateway to manage these local databases. If your dataset contains multiple data sources which need both personal gateway and on-premise gateway to refresh, it may cause the issue.
Regards,
Xiaoxin Sheng