New Idea
0 Kudos

I can load the data into an Excel spreadsheet and then use that

as a data source for Power BI but obviously it would be better if

Power BI could get it straight from Timetracker


When I try to load it in Power BI I get this Error:


Feedback Type:
Frown (Error)


Local Time:

Session ID:

December 2018

Product Version:
2.65.5313.1381 (18.12) (x64)

Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Cannot access a disposed object.
Object name: 'Microsoft.Mashup.Engine1.Library.OData.V4_7.Reader.ODataHttpResponseReader'. ---> System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'Microsoft.Mashup.Engine1.Library.OData.V4_7.Reader.ODataHttpResponseReader'. ---> System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'Microsoft.Mashup.Engine1.Library.OData.V4_7.Reader.ODataHttpResponseReader'.
at Microsoft.Mashup.Engine1.Library.OData.V4_7.Reader.ODataHttpResponseReader.AssertNotDisposed()
at Microsoft.Mashup.Engine1.Library.OData.V4_7.Reader.ODataHttpResponseReader.ToResourceReader(Boolean isResourceSet)
at Microsoft.Mashup.Engine1.Library.OData.V4_7.Reader.ODataReaderEnumerable.GetReaderEnumerator(GetReader getReader)
at Microsoft.Mashup.Engine1.Language.Query.SkipTakeEnumerable.GetEnumerator()
at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.GetEnumerator()
at Microsoft.Mashup.Engine1.Runtime.TableValue.Microsoft.Mashup.Engine.Interface.ITableValue.GetEnumerator()
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass5.<RunStub>b__3()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass7.<TryReportException>b__6()
at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass1e`1.<OnBeginGetResult>b__1b()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)
at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

OS Version:
Microsoft Windows NT 10.0.17134.0 (x64 en-GB)

CLR Version:
4.7 or later [Release Number = 461808]

Peak Virtual Memory:
37.9 GB

Private Memory:
366 MB

Peak Working Set:
529 MB

IE Version:

User ID:

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

Telemetry Enabled:

Model Default Mode:

Snapshot Trace Logs:
C:\Users\ibowl\Microsoft\Power BI Desktop Store App\

Disabled Preview Features:

Disabled DirectQuery Options:


DPI Scale:

Supported Services:
Power BI

0 Kudos
Buenos dias Desde el 9 de enero de 2019 la conexión con ONE DRIVE es un problema personal, alguien me puede colaborar con el siguiente error: Ha habido un error No se han recuperado los metadatos del archivo Vuelva a intentarlo más tarde o póngase en contacto con el soporte técnico. Proporcione estos detalles si se pone en contacto con ellos. Identificador de actividad550dffc1-7341-4c00-8ed4-bf39c809d265 Identificador de la solicitud9915abba-7257-1906-0ae6-140d54cf45da Carné de identidad. de correlaciónb8134324-e47f-ef15-28d3-c6fffbe9f656 Código de estado410 HoraSat 19 de enero de 2019 08:01:11 GMT-0500 (hora estándar de Colombia) Versión 13.0.7994.169 URI de clústerhttps: //
0 Kudos

If I have in Power BI Desktop:


q1 = 5;
q2 = #sections[Section1][q1];

And q1 is NOT loaded to model and q2 IS loaded to the model, I have such error when PBD applyes query changes:

"OLE DB or ODBC error: [Expression.Error] The field 'q1' of the record wasn't found.."


Why is that happens? From end user point of view (ie me :-)), all the PQ calculations should be done as one Transaction, isn't it?

0 Kudos

Some of my datasets acting up today. 


I have a schedule refreshes on my datasets, when the report is refreshing, it automatically started the new refresh and killed the old one with the error "The scheduled refresh is cancelled because a new refresh is detected on the same database" img 2.pngimg 1.png



Is there an issue with the service? 


0 Kudos

Hi All!


I cannot get to #shared in Power BI - what may be the problem?


I have empty pbix with only one Query, which is Source = #shared, and I get this error, if I try to refresh the Dataset from the pbix:

"You can't schedule refresh for this dataset because the following data sources currently don't support refresh:

  • Data source for Query1"


0 Kudos

Hi Support team,


We are sporadically facing issues in our Power BI dashboard where tile refresh is erroring out for some consumers. Our Dashboard uses tiles which gets refreshed from our datasets\reports which have a scheduled daily refresh. So far, we have tried many things, like restarting Power BI gateway and tabular services, resolve performance issues within underlying tabular cube, etc. , to resolve this issue, but nothing seems to be working. I believe its more of an issue with Power BI services rather than our environment, as we are not facing any performance issues while rendering the underlying Power BI reports, but the dash tiles. I have attached screenshots of technical details related to the issue adn also the dashboard error. 


It would be great as we can get some help soon on this issue as this is impacting our daily Dashboard reporting to senior management. 


Please let me know if any further information is required.


Below are the snapshots containing error details:







0 Kudos
Hi all,
Getting a strange error message on Power BI when I try to access the "Security" feature. It's been down all day as far as I can tell, but usually don't have an issue.
Here are the details:
Something went wrong
The roles could not be loaded. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 25203176-bdd2-4f6f-a01b-e2928b0e3929
Request ID: 8106d5d1-64a8-c3b6-ceca-b734bbd43a7b
Correlation ID: 987ff49e-206e-da67-e627-d7394f763f4c
Status code: 400
Time: Fri Jan 18 2019 15:42:52 GMT+0000 (Greenwich Mean Time)
Version: 13.0.7994.169
Anyone else having this issue?
Kind regards,
PS: Apologies if this is in the wrong place - I clicked on "Report a Bug" and the post button says "New Idea"... ?
0 Kudos

Scheduled Reports are taking error "Before the data import for (Data Source Name) finished, its data source timed out."  Most reports have 60 min. timeout coded and error occurs after a couple minutes.  Start of last week, a couple reports showed error.  By Fend of week about half the scheduled reports took the error.  Administrator restarted/rebooted Enterprise Gateway.  Reports immediately ran fine.  This week, a similar pattern emerged.  Some reports fail at start of week and by Friday, high percentage of reports failed with this error message.  Data sources are accessing SQL Server & Oracle databases.  We know the restart of the Gateway is the quick fix, but seems like there is a bigger issue.

0 Kudos
Hi there,
I was trying to remove old users on a workspace and add new members. But I get the below error when attempting to save the workspace.
Something went wrong
Couldn't update the group
Please try again later or contact support. If you contact support, please provide these details.
Activity ID0436c9b5-6c20-47c2-9eb5-e106397438e0
Request ID17234571-0220-c657-8c25-677535c93de6
Correlation ID366aec8b-a7b0-cdcf-5702-e221d2458081
Status code400
TimeFri Jan 18 2019 15:50:13 GMT+0200 (South Africa Standard Time)
0 Kudos

[intl bash] Typo about DataSets

Status: New
by hongju Frequent Visitor yesterday - last edited yesterday

I found that the text changed to “데이터 세트” From “데이터 집합”.

Many labels changed.




We can see “데이터 집합” for “DataSets” on Microsoft Terminology portal.




We think more better “데이터 집합” than “데이터 세트”.

That should be “데이터 집합”.


0 Kudos

dear madam, sir

we use powerbi sql connections in powerbi desktop 

we recieve from time to time error 0x80040E4E


The individual refresh of queries works, but the full report refresh gives this error. 

In addion when we do the refresh in the cloud sometimes it seems to work. 


kind regards



0 Kudos

I have problems with automatically created date / date hierarchy table after re-generating Master Calendar table in Power BI desktop application:

  • when You change the time scope in Master Calendar table,
  • then the Master Calendar table and automatic date hierarchy are re-created,
  • then
    • time intelligence functions stop to work correctly.
    • fragmentators with data from automatic date hierarchy stop to show correctly


Here is the detailed case:


Initially - I create the master calendar table named 99_Kalendarz - with the ADDCOLUMNS or GENERATE/RETURN ROW for period: from “1 January 2015” to “31 December 2018”.


99_Kalendarz =
CALENDAR (DATE(2015;1;1); DATE(2018;12;31)) ;
"DataSprz"; FORMAT ( [Date]; "YYYY-MM-DD" );
"Rok"; YEAR ( [Date] );
"Mies"; FORMAT ( [Date]; "MM" );
"RokMies"; FORMAT ( [Date]; "YYYY/MM" );
"DzTygNr"; WEEKDAY ( [Date]; 2 );
"DzTyg"; FORMAT ( [Date]; "ddd" );
"Kw"; "Q" & FORMAT ( [Date]; "Q" );
"RokKw"; FORMAT ( [Date]; "YYYY" ) & "/Q" & FORMAT ( [Date]; "Q" )


 In both cases Master Calendar table 99_Kalendarz contains the main field [Date] with the complete set of dates in the given period. The [Date] field has datatype Date/Hour and for this field the date hierarchy Year/Quarter/Month/Day is created automatically.

Later You refer to those fields like that:

‘99_Kalendarz[Date].[Date]      – main “Date” field

‘99_Kalendarz[Date].[Rok]        – field „Year” in automatically created hierarchy

‘99_Kalendarz[Date].[Kwartał]  – field „Quarter” in automatically created hierarchy

‘99_Kalendarz[Date].[Miesiąc]  – field „Month” in automatically created hierarchy

‘99_Kalendarz[Date].[Dzień]     – field „Day” in automatically created hierarchy


Then I join the master calendar table to the sales data table and create some time intelligence measures. In time intelligence measures I relate to the master calendar table like this: provide the notation of the field [Date] as a “hierarchical” field in master calendar table: ‘99_Kalendarz’[Date].[Date] as mentioned above:

Sp_WartVKP_LY = CALCULATE( '01_Sprzedaz'[Sp_WartVKP]; SAMEPERIODLASTYEAR( '99_Kalendarz'[Date].[Date] ) )

Time intelligence measures work as expected.


I can also create Fragmentators based on the master calendar table filed ‘99_Kalendarz”[Date].

I have to instruct Fragmentator visualization which part of [Date] field should it use.

[Date].[Date] field or some of automatically created date hierarchy field.

Fragmentators work properly and they show the chosen subpart of [Date] field: Date itself or Year/Quarter/Month/Day (from hierarchy) 


And here comes the problem:


I add new year 2019 to the Master Calendar table ‘99_Kalendarz’

I correct the data for CALENDAR in the table definition:



Then the Master Calendar table is re-generated and also the date hierarchy is probably re-generated automatically

But: After re-generation - the automatic date hierarchy is not visible on the Fields pane.


After this procedure:

  • Time intelligence measures stop to work properly.

The notation check does not show any errors - but SAMEPERIODLASTYEAR calculates the “present period” instead of “same period last year”


  • Fragmentators which used fields from date hierarchy start to show the basic “Date” field instead of “Year” or “Month” from date hierarchy – probably due to re-generation of automatic date hierarchy


Can You suggest - is it a bug or how can I add the new period (new year) to the master calendar without destroying the Data Model ?

0 Kudos

What does this status mean?

Scheduled 18/1/2019 11:01:19 18/1/2019 11:03:00 Failed
Cluster URI:
Activity ID: 0c866168-9744-4f3b-8099-ce6c6ca155de
Request ID: 3129da12-d692-4a05-8033-6367bfffc41f
Time: 2019-01-18 10:03:00Z


I don't know how to get any further. I've checked On-Premise Gateway and Power BI Online side and everything seems ok.


Any suggestions?

0 Kudos

Following API returns 404 not found{groupId}/datasets/{datasetKey}/Default.GetBoundGatewayDat...


HistoryId: 60

Message        : Response status code does not indicate success: 404 (Not Found).
StackTrace     :    at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()
                    at Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod.<InvokeRestMethod>d__31.MoveNext()
Exception      : System.Net.Http.HttpRequestException
InvocationInfo : {Invoke-PowerBIRestMethod}
Line           : $rawResult = Invoke-PowerBIRestMethod -Url "" -Method
Position       : At line:1 char:14
                 + ... rawResult = Invoke-PowerBIRestMethod -Url " ...
                 +                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
HistoryId      : 60


0 Kudos

When hovering in certain places in the screen, the report tooltip sometimes is cut off and overflows off the screen.

It seems the tooltip isn't clever enough to adjust position to show either left or right


Is this something known?

0 Kudos

We have had customers reporting intermittent issues rendering since the 71.0.3578.98 release of Chrome. The Power BI Embedded content just intermittently doesn't render (whether in incognito or not) leaving the user with a blank iframe. Other elements (non PBIE) still render fine. We have not been able to reproduce this on any other browser type/version.

Has anyone else started noticing something similar? We are struggling to find a solution as no error logs are thrown client side and the content passed back is just there as expected. Worth noting this is using the latest Power BI SDK also and that this is from a Premium capacity which is happily serving other customers/users not using Chrome 71.0.3578.98.

Any help gratefully accepted..


0 Kudos

I've previously been able to add Microsoft SQL servers as a data source on our gateway however when I tried to add one this morning, SQL Server is missing from the list. 

I checked out one of my existing SQL Server data source connections and it says Data Source Type as SQL Server.

My wife would ask me if I was having a man look, but I'm pretty sure it's missing.


Status: Delivered
0 Kudos

I'm having issues openening Power BI desktop. It seems to pause at the splash screen during 'Initializing Model'


Then I get the error message "We weren't able to create an empty database in the model"


This happens on multiple different .pbix files and even when just trying to open the application. I've tried uninstalling/reinstalling, disk cleanup utility, updating windows. The files work on other computers running the same version of Power BI desktop too.



Error Message


Feedback Type:
Frown (Error)


Local Time:

Session ID:

December 2018

Product Version:
2.65.5313.1381 (18.12) (x86)

Stack Trace:
   at Microsoft.AnalysisServices.Tabular.Server.CheckIfConnected(Boolean offlineCaptureXmlAllowed)
   at Microsoft.AnalysisServices.Core.Server.RollbackTransactionInternal()
   at Microsoft.AnalysisServices.Tabular.Server.RollbackTransaction()
   at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.Dispose()
   at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.Dispose()
   at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ExtendedModelChangeScopeBase.ExecuteChange(ModelChange modelChange, Boolean saveChange)
   at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabaseLocal.<>c__DisplayClass18.<ExecuteOutOfBandModelChange>b__17(IExtendedModelChangeScope scope)
   at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.RunOutOfBandExtendedModelChange(Action`1 extendedModelChange, IAnalysisServicesDatabase analysisServicesDatabase, IModelManager modelManager, Boolean requireASDBToBeUnattached)
   at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabaseLocal.RunOutOfBandExtendedModelChangeCore(Action`1 extendedModelChange, Boolean requireASDBToBeUnattached)
   at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabaseLocal.ExecuteOutOfBandModelChange(ModelChange modelChange, Boolean requireASDBToBeUnattached)
   at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabaseLocal.UpdateMashupProviderGlobalPipeReferences(String newGlobalPipeName)
   at Microsoft.PowerBI.Client.Windows.ReportPreparer.Prepare(Report report, PackageValidationResult mashupResult, IPowerBIWindowService windowService, Nullable`1 entryPoint)
   at Microsoft.PowerBI.Client.Windows.Services.PowerBIPackagingService.Open(FileStream fileStream, IPowerBIWindowService windowService, Nullable`1 entryPoint, PowerBIPackageOpenOptions options, Boolean& allCredentialsSatisfied)
   at Microsoft.PowerBI.Client.Windows.Services.FileManager.<LoadFromPbix>d__5.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.Client.Windows.Services.UIBlockingService.<>c__DisplayClassa`1.<<BlockUIAndRun>b__9>d__c.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion(Task task)
   at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.BlockUIAndRun[T](Func`1 asyncMethod)
   at Microsoft.PowerBI.Client.Windows.Services.FileManager.OpenFile(IPowerBIWindowService windowService, IPbixFile fileToOpen, Nullable`1 entryPoint)
   at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IUIHost uiHost, ISplashScreen splashScreen, IFileManager fileManager, IFileHistoryManager fileHistoryManager, String filePath, FileType fileType)
   at Microsoft.PowerBI.Client.Program.<>c__DisplayClass10.<Main>b__0()
   at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass7.<HandleExceptionsWithNestedTasks>b__6()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 461814]

Peak Virtual Memory:
892 MB

Private Memory:
136 MB

Peak Working Set:
182 MB

IE Version:

Telemetry Enabled:

DPI Scale:

Supported Services:
Power BI

0 Kudos

I have uploaded an icon to a worskpace, but that icon is not showing up for the related app.Workspace Image.JPGWorkspace Icon added

Status: Accepted
0 Kudos

If someone is given a link to a dashboard that is not shared with them they can click "request access". Now when this is done for a dashboard owned by an individual that individual gets an email notification. When this is done with a dashboard in a group workspace it seems that no one is getting an email. This has lead to a backlog of users requesting access and my team not having any idea that they are. Is there a way to specific who gets the email / notification ?