New Idea
0 Kudos

I all and many thanks in advance for any support.

 

I have some issues on data refresh concerning a big query (about 300 million rows, 50 cols).

I set up an environment where power bi service refresh such a dataset from an odbc connection through the on premise data gateway.

 

I tried it from the desktop client and all seems ok even if it took about two hours, but once the refresh has been scheduled from online service  (using the gateway) it fails. On request refresh neither worked.

 

A microsoft consultant state that the gateway is limited to one hour per query, then it goes directly to a timeout error.

I cannot find this information in official documentation or in previous posted messages.

 

Is there any experience concerning such a limitation? or some parameter that can be managed in gateway configuration?

 

 

Thank you in advance,

 V

 

 

 

 

 

 

Status: Needs Info
0 Kudos

Hi,

 

I have a very frustrating problem that I can't manage to understand or get around. I have a report that uses a MySql data source. I deploy it to cloud powerBI and use the on premise data gateway to connect to it. This particular report throws out this error:

 

Invalid connection credentials.
Please try again later or contact support. If you contact support, please provide these details.

 

Underlying error code -2147467259
Underlying error message The MySql source doesn't support encrypted connections. (Source at <removed>.)
DM_ErrorDetailNameCode_UnderlyingHResult -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind MySql
Microsoft.Data.Mashup.CredentialError.DataSourcePath<removed>
Microsoft.Data.Mashup.CredentialError.Reason EncryptedConnectionFailed
Cluster URIWABI-UK-SOUTH-redirect.analysis.windows.net
Activity ID1e295340-c1a8-4377-9414-d97e4dde1869
Request ID8b452c72-2255-03bc-f6fb-5044397aa9ad
Time2017-02-07 11:22:54Z

 

This is very frustrating because I'm using the exact same source through the exact same gateway in a different report and that one is working just fine. The MySQL source does support encrypted connections also. So the error doesn't even make sense.

 

I've tried the following:

1. Redeploying the report

2. Recreating the data source in the manage gateway page

3. Restarting the data gateway

4. Clearing up the permissions in the data source settings of the report and adding them again

5. Tried changing the name of the data source (you can't do that in power bi desktop si I just appended to port at the end in hopes of tricking it)

 

I just can't figure out what the problem might beSmiley Sad

 

data gateway version: 1.15.6170.1

mysql connector net: 6.6.5

power bi desktop: 2.42.4611.701 64-bit (January 2017)

windows server 2016 

 

At this point im desperate vor ANY ideeas!

Thank you!

Andrei  

 

Full error logs from the data gateway:

DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2523736Z DM.EnterpriseGateway bc28a748-1625-412e-9dc3-f1008587af23 6f93a005-b7ca-4c85-a924-954ef2624146 MGEA 8dcd056a-dd80-497a-bb1e-02c3239cced6 D88DD922 [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: Microsoft.Data.Mashup.MashupCredentialException (0x80004005): The MySql source doesn't support encrypted connections. (Source at<removed>)
at Microsoft.Data.Mashup.MashupResource.<>c__DisplayClass24.<PromptOrThrow>b__23()
at Microsoft.Data.Mashup.MashupResource.PromptOrThrow(Func`1 invokeDialog, Action throwOnCancelOrCannotPrompt)
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<>c__DisplayClass22.<<ExecuteAdoQuery>b__1a>d__24.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__a`1.MoveNext()
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2523736Z DM.EnterpriseGateway bc28a748-1625-412e-9dc3-f1008587af23 6f93a005-b7ca-4c85-a924-954ef2624146 MGEA 8dcd056a-dd80-497a-bb1e-02c3239cced6 D0174D8B [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=150, err=MashupCredentialException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 87BAEBB0 [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessCredentialException: Missing or invalid credentials for data source. Reason = 'EncryptedConnectionFailed', DataSource = 'MySql/<removed>', DataSourceReference = '', DataSourceOrigin = '', DataSourceReferenceOrigin = ''.; ErrorShortName: MashupDataAccessCredentialException[ErrorCode=-2147467259,HResult=-2147467259]/Wrapped(MashupCredentialException)[ErrorCode=-2147467259,HResult=-2147467259]
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 8AA61592 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorCode = <pi>-2147467259</pi>
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 0834FCD8 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorMessage = <pi><pi>The MySql source doesn't support encrypted connections. (Source at<removed>)</pi></pi>
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 6A5E25DC [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingHResult = <pi>-2147467259</pi>
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 6D769432 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.CredentialError.DataSourceKind = <pi>MySql</pi>
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 75291C07 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.CredentialError.DataSourcePath = <pi><removed></pi>
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 D87BB53A [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.CredentialError.Reason = <pi>EncryptedConnectionFailed</pi>
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 389729ba-e9d6-42d4-b007-aeeaf9e92f28 6f93a005-b7ca-4c85-a924-954ef2624146 MGEQ 8dcd056a-dd80-497a-bb1e-02c3239cced6 9DD226C9 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=868, err=MashupDataAccessCredentialException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2017-02-07T08:02:02.2533629Z DM.EnterpriseGateway 4f655709-8eda-4676-9c0e-70d45c0f834c 6f93a005-b7ca-4c85-a924-954ef2624146 MGPE 8dcd056a-dd80-497a-bb1e-02c3239cced6 9DD226C9 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=868, err=MashupDataAccessCredentialException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Information: 0 : 2017-02-07T08:02:02.2583631Z DM.EnterpriseGateway 143e92c3-1b5a-4629-8d89-fde9169cbef6 6f93a005-b7ca-4c85-a924-954ef2624146 MGPP 8dcd056a-dd80-497a-bb1e-02c3239cced6 ABE5CED4 [DM.GatewayCore] Async operation 80301c2e-7ddb-4a7e-9e4c-38d804d09b33 completed with an error: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessCredentialException: Missing or invalid credentials for data source. Reason = '<pi>EncryptedConnectionFailed</pi>', DataSource = '<pi>MySql/<removed></pi>', DataSourceReference = '', DataSourceOrigin = '', DataSourceReferenceOrigin = ''.

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_InvalidConnectionCredentials
Reason=<pi>EncryptedConnectionFailed</pi>
DataSource=<pi>MySql/<removed></pi>
DataSourceReference=
DataSourceOrigin=
DataSourceReferenceOrigin= --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: MashupCredentialException:<pi>Microsoft.Data.Mashup.MashupCredentialException (0x80004005): The MySql source doesn't support encrypted connections. (Source at<removed>.)
at Microsoft.Data.Mashup.MashupResource.<>c__DisplayClass24.<PromptOrThrow>b__23()
at Microsoft.Data.Mashup.MashupResource.PromptOrThrow(Func`1 invokeDialog, Action throwOnCancelOrCannotPrompt)
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<>c__DisplayClass22.<<ExecuteAdoQuery>b__1a>d__24.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__a`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<<ExecuteAdoQuery>b__19>d__27.MoveNext()</pi>

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
InnerType=MashupCredentialException
InnerMessage=<pi>The MySql source doesn't support encrypted connections. (Source at<removed>.)</pi>
InnerToString=<pi>Microsoft.Data.Mashup.MashupCredentialException (0x80004005): The MySql source doesn't support encrypted connections. (Source at<removed>.)
at Microsoft.Data.Mashup.MashupResource.<>c__DisplayClass24.<PromptOrThrow>b__23()
at Microsoft.Data.Mashup.MashupResource.PromptOrThrow(Func`1 invokeDialog, Action throwOnCancelOrCannotPrompt)
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<>c__DisplayClass22.<<ExecuteAdoQuery>b__1a>d__24.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__a`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<<ExecuteAdoQuery>b__19>d__27.MoveNext()</pi>
InnerCallStack= at Microsoft.Data.Mashup.MashupResource.<>c__DisplayClass24.<PromptOrThrow>b__23()
at Microsoft.Data.Mashup.MashupResource.PromptOrThrow(Func`1 invokeDialog, Action throwOnCancelOrCannotPrompt)
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<>c__DisplayClass22.<<ExecuteAdoQuery>b__1a>d__24.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__a`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<<ExecuteAdoQuery>b__19>d__27.MoveNext()
([1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException.StackTraceSmiley Happy
at Microsoft.Data.Mashup.MashupResource.<>c__DisplayClass24.<PromptOrThrow>b__23()
at Microsoft.Data.Mashup.MashupResource.PromptOrThrow(Func`1 invokeDialog, Action throwOnCancelOrCannotPrompt)
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1c.<>c__DisplayClass22.<<ExecuteAdoQuery>b__1a>d__24.MoveNext()

Status: Delivered
0 Kudos

Log In Issue

Status: Needs Info
by mzeppieri Frequent Visitor on ‎02-15-2017 08:51 AM

I am having trouble logging into my account both on the desktop and web.  I've been able to log into PowerBI for months using the account I created associated to my work email.

 

Now, when I go to login, the system goes into this endless redirecting loop.  What I see on the screen is:

 

A blue circular icon that looks like a badge, with my username next to it.

Below that, the word "Redirecting"

Below that, the words "We're taking you to your organization's sign in page"

 

The problem is that it never advances to the next page.  It just keeps redirecting and refreshing in an endless loop.

Status: Needs Info
0 Kudos

Hi,

 

We have a Windows Server 2012R2 box up in azure running MS SQL server - I have managed to install the enterprise gateway fine and can access the SQL DB fine with PowerBI Desktop, but when I am trying to add a new data source within office 365 I get the following error:

 

powerbi problem.jpg

 

I have set up data sources from servers in our own DC fine, just never when MS SQL is on a server up in azure, any suggestions?

 

Status: Needs Info
0 Kudos

My dataset schedule refresh failed

Status: New
by WeeraS New Member on ‎12-12-2016 03:21 PM

Hi all,

 

I have 6 datasets in my powerBi service. I have set up auto refresh of all thesedatasets via a personal gateway. Recently I notice that some of my datasets not refreshed as scheduled. Those dataset are quite big reports( 0.6 GB , 0.5GB and 0.38 GB) and small reports refresh without any problem. These datasets don't refresh at same time  i have spread them to give enough time gap for refresh each dataset assuming that if all reshresh same time could coulf heavy data traffics. I checked my gate way is alway online and activated. I have upgraded gateway and poweBI desktop to see whether that would fix the problem. But datasets refresh still fails.

Error message I get was,Capture111.JPG

 

This is really headache for me. Please can anyone help me to get rip of this issue

 

Thanks

0 Kudos

On-Prem Live Tabular connection shows refresh error - even though reports work

Status: Delivered
by mthierba Frequent Visitor ‎02-16-2017 08:37 AM - edited ‎02-16-2017 08:38 AM

I've had to change some user mapping settings on a Gateway Tabular data source in order to account for users that were previously blocked. That worked fine and I achieved the desired result.

 

However, ever since then all the existing datasets that use that gateway connection show up with a refresh warning sign and each scheduled refresh as "Failed". Any reports based on those datasets, however, work absolutely fine, and definitely show live data!

 

If anything, this seems to be some UI hick-up, but it is quite distracting, and I'd rather have no errors showing up there.

 

Also notice the "Last Refresh" timestamp:

PBI-SSAS-Refresh-errors 2.png

 

This (nothing) shows up when clicking "Show Details":

PBI-SSAS-Refresh-errors.png

 

Status: Delivered
0 Kudos

It's very frustrating to have to leave the refresh settings page just to test it, then return to that page to see results of the refresh. (For instance, when refresh credentials need to be configured or when switching between gateways.)

 

Can we add a "Refresh now" button to that refresh configuration page, so that I don't have to leave the page and then come back?

 

 

Thanks!

Aaron

0 Kudos

Missing Data Sources on the Web

Status: New
by yash1105 Frequent Visitor on ‎12-14-2016 04:31 PM

Suddenly my data sources for the dashboards on the web are missing.

I tried un-installing and installing the Personal Gateway again. 

and because of the issue, none of the dashboards are able to refresh.

 

 

Power Bi Error.JPG

 

0 Kudos

Gateway refresh failure

Status: Delivered
by kyle705 Frequent Visitor on ‎05-19-2017 01:22 AM

I have a SQL data source. The enterprise gateway refresh failed first day (Wednesday), succeeded second day (Thursday) & failed today (Friday).

 

Why?!?

 

Capture.PNG

Status: Delivered

Hello

 

Still unable to refresh on Power BI Service (Online), where we have a numbe of reports that employees rely on for daily data. 

 

Do we have an idea when this is going to be fixed? I am a user in the UK

 

Cheers


Rob

Status: Delivered
0 Kudos

Can't refresh my dataset.

Status: Needs Info
by PresidentJSMC New Member on ‎01-17-2017 10:47 AM

My refresh are not working.. see below screenshot.

 

Picture1.png

Status: Needs Info
0 Kudos

Hi all. When posting a dataset to a group so that I can enable row level security I get this error.

 

It's connecting to our PWA server using oData connectors. Works fine internally just not working in this group.

 

As a side point the RLS doesn't seem to work either but I have a feeling it might be related to the dataset not refreshing back to the database to check security?

 

Capture.JPG

Status: Delivered

Invalid credentials on Sharepoint folder

Status: Accepted
by csabil Frequent Visitor on ‎11-22-2016 10:46 PM

Since yesterday I'm having an issue connecting to an excel file in a Sharepoint folder. It was already working, but I made some changes and republished it. Refresh works fine in Power BI Desktop, but online. It seem it's trying to connect to a Sharepoint list, instead of folder. I have an other report connecting to an other excel file in the same folder and it works fine. Could this be connected to the issue in North Europe? I'm in that datacenter.

 

Capture.PNG

Status: Accepted

errorJPG.JPG

I'm getting this error since yesterday on a new dataset. It is a simple excel file table. I've done the following.

Signed out of Power BI Desktop and back in

Got the latest personal gateway

turned the gateway service off / on

republished multiple times during this process.

 

Others seem to be having the same issue. see thread here

There is a current support site error message, but it is specific to SharePoint as a data source only.

Status: Accepted
0 Kudos

Curios observation here that's somewhere between feature and bug. 

 

I have mysql database running on a server that can only be tunnelled into and once the tunnel is open (via SSH) the connection to the database doesn't require a password. Connecting goes fine on the PowerBI Desktop:

 

Config Panel for MySQL in PowerBI Desktop

 

screenshot- 2017-05-02 16-32-07.jpeg

 

 

Connected Datasource in PowerBI Desktop from Previous step -- no password required.

 

Screen Shot 2017-05-02 at 4.11.06 PM.png

 

Datasource config panel for On Premises Gateway in Power BI Web Application -- Same configuration as PowerBI Desktop however Password is required.

 

screenshot- 2017-05-02 16-34-03.jpeg

Status: Accepted
0 Kudos

Power BI Scheduled Refresh is not working

Status: Accepted
by sgk123 Frequent Visitor on ‎04-20-2017 08:09 AM

The Power BI schedule refresh is not working for any of my dashboards.

Refresh now is working fine.

 

I scheduled my dahsboards at 8am and 9am

None of them refreshed till now it's almost more than 2 hours

Status: Accepted
0 Kudos

Data Gateway

Status: Delivered
by hermanmaier Visitor on ‎02-24-2017 09:30 AM

Hello Everyone, I have an issue

 

I tried to install an on-premises data gateway but I received this message:

"no address have been provided 51.140.167.3:443

   at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

   at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)"

 

Do you know what could cause the issue?

Status: Delivered
0 Kudos

I got error when I try to connect SAP HANA database. Kindly help me.

Gateway Error.PNG

 

Status: Delivered
0 Kudos

Hi, 

I'm still getting an error after installing PowerBI personal Gateway :

"Sequence Contains no elements"

I've seen several topics regarding this problem but still didn't find the solution. 

 

 w System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   w System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   w Microsoft.DataProxy.PowerBIPersonalGatewayConfigurator.NotifyTaskCompletion`1.<WatchTaskAsync>d__0.MoveNext().
GWConfig.exe Error: 0 : Error from PersonalGatewayConfigurator, exception: Microsoft.DataTransfer.PowerBIGatewayAgent.UpdateServiceUserException: Nie można zaktualizować użytkownika usługi systemu Windows ---> System.InvalidOperationException: Sekwencja nie zawiera elementów.
   w System.Linq.Enumerable.First[TSource](IEnumerable`1 source)
   w Microsoft.DataTransfer.PowerBIGatewayAgent.ConfiguratorWorkflowSteps.GetServiceStartupType()
   --- Koniec śladu stosu wyjątków wewnętrznych ---
   w Microsoft.DataTransfer.PowerBIGatewayAgent.ConfiguratorWorkflowSteps.GetServiceStartupType()
   w Microsoft.DataTransfer.PowerBIGatewayAgent.ConfiguratorWorkflowSteps.get_ServiceAutoStartEnabled()
   w Microsoft.DataTransfer.PowerBIGatewayAgent.ConfiguratorWorkflowSteps.StartService()
   w Microsoft.DataProxy.PowerBIPersonalGatewayConfigurator.MainViewModel.<GetIsConfiguredAsync>b__7()
   w System.Threading.Tasks.Task`1.InnerInvoke()
   w System.Threading.Tasks.Task.Execute()
--- Koniec śladu stosu z poprzedniej lokalizacji, w której wystąpił wyjątek ---
   w System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   w System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   w Microsoft.DataProxy.PowerBIPersonalGatewayConfigurator.MainViewModel.<GetIsConfiguredAsync>d__8.MoveNext()
--- Koniec śladu stosu z poprzedniej lokalizacji, w której wystąpił wyjątek ---
   w System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   w System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   w Microsoft.DataProxy.PowerBIPersonalGatewayConfigurator.NotifyTaskCompletion`1.<WatchTaskAsync>d__0.MoveNext().

 Is there any chance to fix it? 

Thanks

Status: Delivered

Hello,

I've published a report from my work account.

Under Dataset Settings it shows Datagateway error and shows:

This data set has been configured by *myprivate*@gmail.com .

I've tripple checked my credential, sign-out and in ...

I see my WORK environment, but it somehow connects the Dataset to gmail....

And doesn't allow me to set up Enterprise Gatway for Dataset or Refresh

I know others are experiencing same issue here:

https://community.powerbi.com/t5/Service/This-data-set-has-been-configured-by-gmail-com-gt-can-t-set...

 

Please help.

Thanks

Michael

Status: Delivered
Idea Statuses