Datamart Internal error

raguraam 

It is giving some hint there Parameter 'transactionId' is not expected to be null..HttpStatusCode500

Something specific to your parameter, you need to check that, why it is NULL being an ID

Regards,

Ritesh

Hi, I encountered same error on my Datamart. There is no parameter or a column called "transactionId". I suspect this is something with the datamarts on Power BI side as my code was not changed. This is happening since yesterday 08/15/22. My tenant is in US East 2. 

I am also getting the same error in Datamart where I am just connecting to an Azure Blob as the data source. I tried to just create a very simple query of just the list of files in the blob and even then I get the same error.

Dear all, I also getting the same error after two weeks that my datamart was automatically refreshing well. I do not have "transactionid" in any of my tables. In transform data all tables refresh well without error. Datasource of this datamart is a dataflow that is refreshing well. This dataflow is linked to ADLS Gen2. Thanks for any support.

Hi,  raguraam 

I cannot reproduce it here. Is it a temporary problem?

If the problem persists, it is recommended to create a support ticket to let MS engineers look into the issue on your side. 

Best Regards,
Community Support Team _ Eason

I started getting this error too.

My new datamart refreshed fine for about two hours.

Then when I added a bunch of new Salesforce Objects, it started showing this cryptic error. Obviously, I do not use any 'transactionId' parameter. That's some internal stuff...

I have tried to disable load on all the new tables, but the query still won't save.

It's also very annoying that each tme I am orced to click 'Go back to editing' all my changes like groups and disabling load are lost.

Hello, I am also getting this error when trying to connect to a Salesforce object.

Are there any updates?

Had same issue and manage to fix.

It might be becasue in one or more columns you specifying filter on, you have unexpected/empty item. Before implementing your filter, remove empty records. 

Me too, same issue.

All was fine yesterday, and today I get that error message.

Stuck.

I get the same error now - Happened suddenly overnight:

InternalError

Activity ID: 70085e2e-7c30-e400-78bd-0981cf6fd20a
Request ID: f462b5a9-604e-4050-96c8-1b679bdaa4a3
Status code: 500
Error Code: InternalError
Batch ID: 4708eb84-0f45-4b8d-9d16-560fbaa36da3@dec1fbae-c318-4b84-a431-8828b07b30da$2023-01-17T06:03:44.2599006Z@761cf92b-79ed-4780-b343-43e2caf7a5f6