Dataset refresh asks for installation of personal gateway, when on-premise gateway is running

Question

Data Source Settings of original pbix file:

Picture of successfully running data source:

I go to refresh the uploaded pbix data set and get this:

Cannot find any documentation on this error.

jeremy_rogers · Answer

Has anyone heard any more about this?&nbsp; The "work around" of publishing the pbix first then creating the gateway connection is counter intuitive however it also is not workable.&nbsp; It works for the first pbix you publish however when you try to publish the second one (gateway connection already created at this point) it won't publish.&nbsp; That dog won't hunt as they say.

ankitpatira · Answer

CLEARIFY&nbsp;i think i have come across this issue before and the way it was solved is by deploying in below steps.&nbsp;1. Take out gateway data sources in power bi service2. Create pbix file to data source3. publish pbix file to service4. add data source to gateway5. refresh dataset in power bi service&nbsp;also ensure in power bi desktop you've signed out under File -&gt; sign out and then when you publish it will ask you for credentials and enter it then. this step may or may not have anything to do with this error but has worked for me in the past and so putting it here.&nbsp;i haven't been able to find any exact reason or the cause except that trying out in above steps have worked for me. i certainly have seen that error before and believe it is to do with the steps a report is published in.&nbsp;

clearify · Answer

Well that works.&nbsp;&nbsp;What was interesting was that I couldn't load any other pbix files - even logging out before uploading.&nbsp; The only way this seems to work is if the data source doesn't exist berfore publishing the files.&nbsp;So.... this is not ready for prime time yet.&nbsp;How do we report this bug for&nbsp;Microsoft to fix - this is cretainly repeatable

v-qiuyu-msft · Answer

Hi CLEARIFY,
&nbsp;
Did&nbsp;this issue only happen to ODBC data source? You said "couldn't load any other pbix files - even logging out before uploading", have you tried to upload files in Power BI&nbsp;Service by Get Data-&gt; Local Files.
&nbsp;
After publishing the reports to Power BI Service, please check which gateway is used by the dataset. You can change it to use on-premises data gateway which you have configured before publishing.
&nbsp;

&nbsp;&nbsp;
&nbsp;
Best Regards,Qiuyun Yu

clearify · Answer

The premise of our product (QQube™) is to elminate the need for using cumbersome connectors, becuase of the need to know tables, relationships, connecting strings, reverse engineering etc.&nbsp;We have a traditional star schema data warehouse for QuickBooks, and have created 'shells' for each subject. (Subjects are independen, and minimize any need to create "cross FACT" analysis.)&nbsp; We install several ODBC drivers, and have shells for many products, e.g. powerpivot, access, crystal reports, etc. so that people can just open up a shell and never once have to deal with a connector. They don't have to spend time figuring out the nuts and bolts - they can just start dragging their fields into the canvas.&nbsp;All shells for all products use the same ODBC connectors, so that if one person creates a dashboard/pbix file on one desktop, all they have to do is send the pbix file to someone else who has our product, and then they can refresh with their own data - never once, having to create a new connection of any sort - or having to recreate the dashboard/layout.&nbsp;So once we create the shells using one of our ubiquitous ODBC connectors, anybody should be able to (a) install the on-premise or personal gateway, then (b) create something using one of the shells we have provided, and (c) hit the publish button to get it going. (Obviously they have to create the PowerBI Pro account before doing so).&nbsp;We have checked, and double checked, and somebody in the community found a workaround, which intimates that there is a bug.&nbsp; The workaround is to upload the files FIRST, then install the on-premise gateway; then everything works fine.&nbsp; This is repeatable. &nbsp;&nbsp;The problem is, we can't upload any other shells, after the gateway is in place.&nbsp;And no, the Get Data&gt;Local Files also didn't work.&nbsp;Several customers have reported that using the personal gateway works most, but not all, of the time.&nbsp;We would like to be able to give customers simple instructions to use our product seamlessly with PowerBI Pro to refresh their data automatically, but unfortunately, we will have to wait until this is fixed - or somebody can find the nature of the problem.&nbsp;Not trying to be "salesy' or create a pitch here (we just want this to work), but if you want to see how we interface with your product you can go here to one of our guides: https://clearify.com/wiki/view/1422/connecting-to-qqube&nbsp;

Forum Discussion

Dataset refresh asks for installation of personal gateway, when on-premise gateway is running

7 Replies

Related content

Issues Installing on-premises data gateway

On premises Data gateway installation failed (personal mode)

on premise gateway installation issue

On- Premise Gateway Installation

Installing Power BI On-Premises Data Gateway in another Region