cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power BI Team dimazaid
Power BI Team

[Personal Gateway Upgrade required] The On-premises data gateway (personal mode) is now available

ACTION REQUIRED BY 7/31/2017 to avoid interruption in your Power BI Data refresh of on-premises data

 
Hello gateway owners
 
Today we're shipped a new, enhanced version of the personal gateway - On-premises data gateway (personal mode). We’re starting the process of moving all existing personal gateways to use the new release. The new release of the gateway is built on top of the same on-premises data gateway infrastructure and will be part of the unified gateway story across the Power * suite (Power BI, PowerApps, and Microsoft Flow). New features in this release include: an improved Fast Combine experience, ability to delete the gateway from the Power BI portal, export logs functionality, and enhanced overall reliability and performance.
More features will be added in the next few months, including the ability to use the gateway in personal mode outside Power BI.
 
Here’s the link to install the new On-premises data gateway (personal mode).
Moving to the new personal gateway is very simple; you just need to install and configure the On-premises data gateway (personal mode) on your machine. Once it’s configured your datasets will discover the new gateway, and all refreshes will start going through the On-premises data gateway (personal mode) instead of the old personal gateway. Documentation on the new gateway, how to install it, and list of FAQs can be found here.
 
Refreshes through your existing personal gateway will stop working after July 31st, 2017; please ensure that you upgrade to the new gateway by July 31st, 2017 to keep your datasets up to date. If you have a technical reason preventing you from using the On-premises data gateway (personal mode) or have not been able to migrate to the new personal gateway, please use this post to give feedback or ask questions.
 
Thanks!
Dimah
Gateway and connectors team
36 REPLIES 36
Wiatrak Regular Visitor
Regular Visitor

Re: [Personal Gateway Upgrade required] The On-premises data gateway (personal mode) is now availabl

Hi Dimazaid,

I'm pro user. I created report one week ago. Yesterday around the same time as now I set up schedule refresh and my all users who are also Pro cannot see my work. They see only message loading data... and almost done... Could you advise how to solve it? I use ODBC data(Service Now connection). Last thing - for me it's working fine. I use old personal gateway and till 6th everything was working fine.
Power BI Team dimazaid
Power BI Team

Re: [Personal Gateway Upgrade required] The On-premises data gateway (personal mode) is now availabl

Hi @Wiatrak,

 

Which auth type are you using with ODBC? Basic or Windows? Do they see any errors other than the loading data message? 

Can you send me the gateway logs so we can take a look? 

 

Thanks!
Dimah 

Wiatrak Regular Visitor
Regular Visitor

Re: [Personal Gateway Upgrade required] The On-premises data gateway (personal mode) is now availabl

It was my mistake. I created dashboard with pinned page and I wanted to create something like menu for reports. I deleted pinned page and left dashboard without it but only text boxes with links to reports. After added again pinned page everything was fine. False alarm Smiley Happy 

 

One question regarding new on-premises data gateway(personal mode). When I upgrade gateway will I still have an access to my ODBC data? I use Basic authentication.

 

Thank you.

 

Regards,

Pawel

Power BI Team dimazaid
Power BI Team

Re: [Personal Gateway Upgrade required] The On-premises data gateway (personal mode) is now availabl

Hi @Wiatrak,


Glad to hear it was resolved! 
The new gateway supports ODBC data source with Basic mode today, so you should be able to still access your data. Please let me know if you see otherwise. 

 

Thanks!
Dimah 

ascendbi Regular Visitor
Regular Visitor

Re: [Personal Gateway Upgrade required] The On-premises data gateway (personal mode) is now availabl

Hi - we installed this update as we have a few data models that use data sources not yet supported by the Data Gateway Enterprise mode.

 

Unfortunately, we had to uninstall the update as it does not support all the data sources that the existing Personal Gateway supports.

 

Specifically, we are refreshing Active Directory Data. I recognize (now! Smiley Happy) that that lack of AD support (along with others) is detailed in the linked documentation under Limitations and considerations, but considering that data refresh via the existing personal gateway will stop working in 7 weeks, I am surprised at the lack of feature parity. I see OLEDB, ODBC, Spark and R being developed, but no AD mention. 

 

@dimazaid, while I applaud unifying and simplifying, we are going to have a problem if 2017-07-31 rolls around and On-premises data gateway (personal mode) is not at feature parity for supported connections with the existing Personal Gateway. 

Power BI Team dimazaid
Power BI Team

Re: [Personal Gateway Upgrade required] The On-premises data gateway (personal mode) is now availabl

Hi @ascendbi,

Thank you for the feedback and for using the gateway! We will be looking into adding AD based on this, I will respond back with an ETA once it's clear. 


p.s: Sorry if you're getting this twice, I sent a response yesterday but can't see it anymore. 

 

Thanks!
Dimah 

starmoonknight Regular Visitor
Regular Visitor

Re: [Personal Gateway Upgrade required] The On-premises data gateway (personal mode) is now availabl

Hi Dimah,

 

I reinstalled my OS due to a faulty drive thus has directly downloaded the new On-premises data gate way (personal mode). (I used to be a personal gate way user)

 

After I signed in the gateway, it asked me to update my credentials for datasets the PBI. However, all credentials could be updated but the analysis cube.

 

Capture.PNG

 

I also have some OneDrive files as data sources whose authentication method is also "WindowsWithoutImpersonation" and they worked well. 

 

BTW, I use "my current credential" for the same analysis cube in PBI desktop and it works good. I tried to publish the pbix file again to replace the existing dataset but still got the same error. Not sure what's the issue here. Could that be a local computer configuration issue?

 

Very much appreciated if you give me sime advise.

 

Many thanks in advance,

 

Olivia 

Power BI Team dimazaid
Power BI Team

Re: [Personal Gateway Upgrade required] The On-premises data gateway (personal mode) is now availabl

Hi @starmoonknight,

 

Can you check the gateway logs and see what additional info it's providing? 

You can find this by going re-opening the gateway from your machine (Start->"On-premises data gateway (personal mode)"), sign in, and click on export logs. 

 

Thanks!
Dimah 

Highlighted
starmoonknight Regular Visitor
Regular Visitor

Re: [Personal Gateway Upgrade required] The On-premises data gateway (personal mode) is now availabl

Hi @dimazaid

 

Since the log is quite long, I searched for possible key words, and the following is quoted from the log which might be helpful:

 

......

DM.PersonalGateway Error: 0 : 2017-06-18T23:40:57.3111621Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 435C38AF [DM.Analytics] Performance counters not installed, application performance metrics will not be traced (category = On-premises data gateway)
DM.PersonalGateway Information: 0 : 2017-06-18T23:40:57.6551754Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 CAB8F9C3 [DM.GatewayCore] Attempting to create and start service host for 'Transfer service'
DM.PersonalGateway Information: 0 : 2017-06-18T23:40:57.7706991Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 F3B572FA [DM.GatewayCore] Using configured 'AutoDetect' for ServiceBus ConnectivityMode
DM.PersonalGateway Information: 0 : 2017-06-18T23:40:57.8459589Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 87990171 [DM.GatewayCore] Creating GatewayTransferServiceHost against 'sb://wabi-south-east-asia-relay36.servicebus.windows.net/eedcdc10-bdc2-459d-b8d0-227ce63e01fa/' with following binding configuration: {"ReliableSession":{"Enabled":false,"Ordered":true,"InactivityTimeout":"00:10:00"},"HostNameComparisonMode":0,"ConnectionMode":0,"TransferMode":0,"MaxBufferPoolSize":8500000,"MaxBufferSize":8500000,"MaxConnections":1500,"ListenBacklog":10,"IsDynamic":false,"MaxReceivedMessageSize":8500000,"ReaderQuotas":{"MaxStringContentLength":8192,"MaxArrayLength":16384,"MaxBytesPerRead":4096,"MaxDepth":32,"MaxNameTableCharCount":16384,"ModifiedQuotas":0},"Scheme":"sb","EnvelopeVersion":{"NextDestinationActorValue":"http://www.w3.org/2003/05/soap-envelope/role/next"},"Security":{"Mode":1,"RelayClientAuthenticationT..."}
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:00.2643817Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 0756374B [DM.GatewayCore] ServiceEndpoint Connection status: Online, LastError: ''
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:00.2847940Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 500124B1 [DM.GatewayCore] Transfer service started
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:00.2847940Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 0CF4AAA9 [DM.GatewayCore] <ii>sb://wabi-south-east-asia-relay36.servicebus.windows.net/eedcdc10-bdc2-459d-b8d0-227ce63e01fa/</ii>
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:00.3337406Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 0E6D6CC9 [DM.GatewayCore] Successfully created and started service host for 'Transfer service'
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:18.4266036Z DM.PersonalGateway 693b20b4-325a-4007-8963-c65274a87b61 ed2d4621-ebf9-4e4e-b419-3b2ec8bb66d3 MGPP 00000000-0000-0000-0000-000000000000 A08BF3B6 [DM.GatewayCore] Deserialized TestGatewayConnectionRequest, executing
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.2617806Z DM.PersonalGateway 0c832e9b-cc4b-480f-a9da-4b4dcaeca4c8 439b3242-beb8-4d75-9762-e1dca2a08f6b MGPP 88233a60-e569-43d4-a615-62ee291b9a1e E5E3865A [DM.GatewayCore] Deserialized OpenConnectionRequest, executing
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.3137012Z DM.PersonalGateway cbea8389-4947-413f-803b-0b29410b6670 439b3242-beb8-4d75-9762-e1dca2a08f6b MGPP 88233a60-e569-43d4-a615-62ee291b9a1e E5E3865A [DM.GatewayCore] Deserialized OpenConnectionRequest, executing
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.3327019Z DM.PersonalGateway c6ab6a7d-f813-4e5b-a738-931fbd264ab3 439b3242-beb8-4d75-9762-e1dca2a08f6b MGPP 88233a60-e569-43d4-a615-62ee291b9a1e E5E3865A [DM.GatewayCore] Deserialized OpenConnectionRequest, executing
DM.PersonalGateway Warning: 0 : 2017-06-18T23:41:32.5319431Z DM.PersonalGateway 6acb356a-0dde-4241-b3f4-45337aa91553 439b3242-beb8-4d75-9762-e1dca2a08f6b MGGC 88233a60-e569-43d4-a615-62ee291b9a1e 9315B129 [DM.Pipeline.Common] Failed to parse gateway core config file: Object reference not set to an instance of an object.
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.5549177Z DM.PersonalGateway 2b48e621-2c8d-437d-9032-d08ec789a7ec 439b3242-beb8-4d75-9762-e1dca2a08f6b MGCC 88233a60-e569-43d4-a615-62ee291b9a1e 23BF7B0C [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[Basic] Encrypted Credential information omitted</pi>]
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.5549177Z DM.PersonalGateway 8a0b78d0-aed7-4feb-b4e7-28e1d2e66ea2 439b3242-beb8-4d75-9762-e1dca2a08f6b MGCC 88233a60-e569-43d4-a615-62ee291b9a1e 23BF7B0C [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[Basic] Encrypted Credential information omitted</pi>]
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.5629089Z DM.PersonalGateway 8fd162d9-d753-4096-9def-aba9936a0a81 439b3242-beb8-4d75-9762-e1dca2a08f6b MGCC 88233a60-e569-43d4-a615-62ee291b9a1e 1522A50B [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[WindowsWithoutImpersonation] Encrypted Credential information omitted</pi>]
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.6867711Z DM.PersonalGateway 6d304a1a-fb7a-4022-8c68-bad36b698ea5 439b3242-beb8-4d75-9762-e1dca2a08f6b MGCC 88233a60-e569-43d4-a615-62ee291b9a1e 1522A50B [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[WindowsWithoutImpersonation] Encrypted Credential information omitted</pi>]
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.6867711Z DM.PersonalGateway 5f7550f7-5e68-4bf4-bf2e-1aed84444d82 439b3242-beb8-4d75-9762-e1dca2a08f6b MGCC 88233a60-e569-43d4-a615-62ee291b9a1e 1522A50B [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[WindowsWithoutImpersonation] Encrypted Credential information omitted</pi>]
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.6867711Z DM.PersonalGateway ed1ec124-0e0d-41c3-b1f3-aa1bcfdec43d 439b3242-beb8-4d75-9762-e1dca2a08f6b MGCC 88233a60-e569-43d4-a615-62ee291b9a1e 1522A50B [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[WindowsWithoutImpersonation] Encrypted Credential information omitted</pi>]

......

 

Thanks,

Olivia

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 336 members 3,229 guests
Please welcome our newest community members: