Online Data Source - Analysis Services - Gateway Setup/Connection Issue

[dstramilov]

Hello,

I am getting error during gateway setup for my Analysis Services data source.

"Unable to connect: We encountered an error while trying to connect to https://sdsdsgdsgsd.com/excel/. Details: "Username needs to include a domain. Please use the format user@domain or domain\user and try again."Show details

Troubleshoot connection problems"

Previously, I was able to create report in powerbi desktop using Analysis Services online data source then publish it & schedule refresh, now power bi requires go thru gateway creation for online data source. 

Assist, please.

[dstramilov]

Any help on this issue?

[v-haibl-msft]

@dstramilov

What did you input for the Username field? You need to use the format user@domain or domain\user as my screenshot.

Following information should also be helpful to you.

Best Regards,

Herbert

[dstramilov]

@v-haibl-msft, thank you for your responce. I am using this format "companyname\username", I can get  data from my data source thru desktop PowerBI. Previosly I was able post data set & schedule refresh, but since PowerBI settings changes for this data source I can't schedule refresh.

[dstramilov]

[v-haibl-msft]

@dstramilov

I’m still not able to repro the same issue. I suggest you to create a support ticket at http://support.powerbi.com (see bottom of page) since it may be account specific.

Best Regards,

Herbert

[anleite]

I am getting an error when trying to launch Power Bi 64. I tried to clean my registry, install and reinstall powerbi... but it is not work. I really appreciate any help.

Feedback Type:
Frown (Error)

Timestamp:
2017-04-28T13:32:36.2576533Z

Local Time:
2017-04-28T09:32:36.2576533-04:00

Product Version:
2.45.4704.722 (PBIDesktop) (x64)

Release:
April, 2017

IE Version:
11.0.9600.18617

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:
4.6.1 or later [Release Number = 394271]

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Peak Working Set:
227 MB

Private Memory:
229 MB

Peak Virtual Memory:
3.54 GB

Error Message:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Stack Trace:
System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
   at System.Windows.Forms.UnsafeNativeMethods.LoadLibrary(String libname)
   at System.Windows.Forms.RichTextBox.get_CreateParams()
   at System.Windows.Forms.Control..ctor(Boolean autoInstallSyncContext)
   at System.Windows.Forms.TextBoxBase..ctor()
   at System.Windows.Forms.RichTextBox..ctor()
   at Microsoft.Mashup.Client.ClientShared.Ux.DisabledAutoSizeRichTextBox..ctor(IExceptionHandler exceptionHandler, Int32 maxWidthInCharacters)
   at Microsoft.PowerBI.Client.Windows.Ux.Intellisense.ParameterHintsControl.InitializeSignature()
   at Microsoft.PowerBI.Client.Windows.Ux.Intellisense.ParameterHintsControl.InitializeComponent()
   at Microsoft.PowerBI.Client.Windows.HtmlControls.DaxFormulaBarHtmlControlAsync..ctor(String moduleName, String formulaBarName, HtmlForm applicationForm, CefWebBrowser hostControl, WindowsHost windowsHost, IExceptionHandler exceptionHandler, IHostedScriptAsync hostedScript, IModelProxy modelProxy, IModelAuthoringRoutingService modelAuthoringRoutingService, IUIBlockingService uiBlockingService, IEventAggregationService eventAggregationService, ISchemaItemActivationService schemaItemActivationService, SynchronizationContext syncContext)
   at Microsoft.PowerBI.Client.Windows.HtmlControls.ReportView.ReportFormulaBarHtmlControlAsync..ctor(String moduleName, String formulaBarName, HtmlForm parentForm, CefWebBrowser hostControl, IModelProxy modelProxy, IHostedScriptAsync hostedScript, IModelAuthoringRoutingService modelAuthoringRoutingService, IUIBlockingService uiBlockingService, IEventAggregationService eventAggregationService, ISchemaItemActivationService schemaItemActivationService, IViewSelectionService viewSelectionService, SynchronizationContext syncContext)
   at Microsoft.PowerBI.Client.Windows.HtmlControls.ReportView.ReportCanvasProxyHtmlControlAsync..ctor(String clientModuleName, IEventAggregationService eventAggregationService, IModelProxy modelProxy, ISchemaItemActivationService schemaItemActivationService, MainWindow mainWindow)
   at Microsoft.PowerBI.Client.Windows.HtmlControls.ReportView.ReportViewHtmlControl..ctor(IEventAggregationService eventAggregationService, IViewSelectionService viewSelectionService, IModelProxy modelProxy, ISchemaItemActivationService schemaItemActivationService, MainWindow mainWindow)
   at Microsoft.PowerBI.Client.Windows.HtmlControls.ViewContainerHtmlControl..ctor(String clientModuleName, ITestHostedScript hostedScript, IEventAggregationService eventAggregationService, IViewSelectionService viewSelectionService, MainWindow mainWindow)
   at Microsoft.PowerBI.Client.Windows.HtmlControls.MainHtmlControl..ctor(String clientModuleName, MainWindow mainWindow)
   at Microsoft.PowerBI.Client.Windows.HtmlControls.MainWindowHtmlControl..ctor(String clientModuleName, ITestHostedScript hostedScript, MainWindow mainWindow)
   at Microsoft.PowerBI.Client.Windows.MainWindow..ctor(IWindowServiceFactory windowServiceFactory, IEventAggregationService eventAggregationService, IFileOperationUIHandler fileOperationUIHandler, IFileManager fileManager, IModelAuthoringRoutingService modelAuthoringRoutingService, IUIBlockingService uiBlockingService, ISchemaItemActivationService schemaItemActivationService, IViewSelectionService viewSelectionService, IUpdateNotificationManager updateNotificationManager, IPowerBIStringProvider stringProvider, IPowerBITelemetryService telemetryService, ITypeNameProvider typeNameProvider, WindowsHost windowsHost, MainWindowParameters initializationParameters, FormulaHistoryManager formulaHistoryManager, Icon dialogIcon, IReportManager reportManager, IPowerBIServiceClient powerBIServiceClient, IAuthenticationManager authenticationManager, IAuthenticationUIHandler authenticationUIHandler, ICloudConfigurationManager cloudManager, ApplicationTracingHost applicationTracingHost, IFileHistoryManager fileHistoryManager, ICefBrowserFactory cefBrowserFactory, IDiagramViewManager diagramViewManager, IPowerBISettings powerBISettings, IModelProxy modelProxy, IFileDialogManager fileDialogManager, EditorScaler editorScaler, String[] additionalDefaultOptionalModules)
   at Microsoft.PowerBI.Client.Program.<>c__DisplayClassd.<Main>b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Invocation Stack Trace:
   at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
   at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)


User ID:
c2db3f71-cc83-4216-95ee-1ae8120b869b

Session ID:
56a6b0d2-8950-46f2-ad9a-9394b03d9067

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\aleite\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot158149024.zip

Performance Trace Logs:
C:\Users\aleite\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_Impala
PBI_Snowflake
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_allowBiDiCrossFilterInDirectQuery
PBI_esriEnabled
PBI_pivotTableVisualEnabled
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_PbiServiceLiveConnect
PBI_daxTemplatesEnabled

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

Formulas:


section Section1;