Datamart of a Table Query generates "Unexpected Error"

[dphugo]

Hi everyone,

The Datamart of a Table Query generates the following error and doesn't render data.

-----------------------------

---------- Message ----------
Unexpected Error

---------- Stack ----------
ApiResponseError: Unexpected Error
at d.handleLoadEvent (https://europe.prod.powerquery.microsoft.com/MashupEditor/scripts/o.a.a0f2f234e5e6b59012c8.bundle.js...)
at XMLHttpRequest.<anonymous> (https://europe.prod.powerquery.microsoft.com/MashupEditor/scripts/o.a.a0f2f234e5e6b59012c8.bundle.js...)

---------- Session ID ----------
b2ba38bd-9eee-4317-9d9a-86010b9f85ee

---------- Request ID ----------
4b787162-ce08-489e-a731-018a37413bab

---------- Mashup script ----------
section Section1;
shared Query = let
Source = Sql.Database("5apouaivbrqedgjc6ob7hgqzxy-ex5ebrsfcijebiw7dk4aftkkuq.datamart.pbidedicated.windows.net", "datamart", [CreateNavigationProperties=false]),
table = Source{[Schema = "model", Item = "Query"]}[Data]
in
table;

section Section1;
shared Query = let
Source = Sql.Database("5apouaivbrqedgjc6ob7hgqzxy-ex5ebrsfcijebiw7dk4aftkkuq.datamart.pbidedicated.windows.net", "datamart", [CreateNavigationProperties=false]),
table = Source{[Schema = "model", Item = "Query"]}[Data]
in
table;

section Section1;
shared Query = let
Source = Sql.Database("5apouaivbrqedgjc6ob7hgqzxy-ex5ebrsfcijebiw7dk4aftkkuq.datamart.pbidedicated.windows.net", "datamart", [CreateNavigationProperties=false]),
table = Source{[Schema = "model", Item = "Query"]}[Data]
in
table;

section Section1;
shared Query = let
Source = Sql.Database("5apouaivbrqedgjc6ob7hgqzxy-ex5ebrsfcijebiw7dk4aftkkuq.datamart.pbidedicated.windows.net", "datamart", [CreateNavigationProperties=false]),
table = Source{[Schema = "model", Item = "Query"]}[Data]
in
table;

section Section1;
shared Query = let
Source = Sql.Database("5apouaivbrqedgjc6ob7hgqzxy-ex5ebrsfcijebiw7dk4aftkkuq.datamart.pbidedicated.windows.net", "datamart", [CreateNavigationProperties=false]),
table = Source{[Schema = "model", Item = "Query"]}[Data]
in
table;

section Section1;
shared Query = let
Source = Sql.Database("5apouaivbrqedgjc6ob7hgqzxy-ex5ebrsfcijebiw7dk4aftkkuq.datamart.pbidedicated.windows.net", "datamart", [CreateNavigationProperties=false]),
table = Source{[Schema = "model", Item = "Query"]}[Data]
in
table;

section Section1;
shared Query = let
Source = Sql.Database("5apouaivbrqedgjc6ob7hgqzxy-ex5ebrsfcijebiw7dk4aftkkuq.datamart.pbidedicated.windows.net", "datamart", [CreateNavigationProperties=false]),
table = Source{[Schema = "model", Item = "Query"]}[Data]
in
table;

section Section1;
shared Query = let
Source = Sql.Database("5apouaivbrqedgjc6ob7hgqzxy-ex5ebrsfcijebiw7dk4aftkkuq.datamart.pbidedicated.windows.net", "datamart", [CreateNavigationProperties=false]),
table = Source{[Schema = "model", Item = "Query"]}[Data]
in
table;

section Section1;
shared Query = let
Source = Sql.Database("5apouaivbrqedgjc6ob7hgqzxy-ex5ebrsfcijebiw7dk4aftkkuq.datamart.pbidedicated.windows.net", "datamart", [CreateNavigationProperties=false]),
table = Source{[Schema = "model", Item = "Query"]}[Data]
in
table;

section Section1;
shared Query = let
Source = Sql.Database("5apouaivbrqedgjc6ob7hgqzxy-ex5ebrsfcijebiw7dk4aftkkuq.datamart.pbidedicated.windows.net", "datamart", [CreateNavigationProperties=false]),
table = Source{[Schema = "model", Item = "Query"]}[Data]
in
table;

section Section1;
shared Query = let
Source = Sql.Database("5apouaivbrqedgjc6ob7hgqzxy-ex5ebrsfcijebiw7dk4aftkkuq.datamart.pbidedicated.windows.net", "datamart", [CreateNavigationProperties=false]),
table = Source{[Schema = "model", Item = "Query"]}[Data]
in
table;

section Section1;

section Section1;
shared #"base-dim_subscription_current" = let
Source = Sql.Database("asql-cii-shared-dev-001.database.windows.net", "Hyperscale_SQL_Shared_001", [Query = "SELECT * #(lf)FROM base.dim_subscription da#(lf) WHERE da.is_current = 1"])
in
Source;

section Section1;
shared Query = let
Source = Sql.Database("5apouaivbrqedgjc6ob7hgqzxy-ex5ebrsfcijebiw7dk4aftkkuq.datamart.pbidedicated.windows.net", "datamart", [CreateNavigationProperties=false]),
table = Source{[Schema = "model", Item = "Query"]}[Data]
in
table;

section Section1;
shared Query = let
Source = Sql.Database("asql-cii-shared-dev-001.database.windows.net", "Hyperscale_SQL_Shared_001", [Query = "SELECT * #(lf)FROM base.dim_subscription da#(lf) WHERE da.is_current = 1"])
in
Source;

section Section1;
shared Query = let
Source = Sql.Database("5apouaivbrqedgjc6ob7hgqzxy-ex5ebrsfcijebiw7dk4aftkkuq.datamart.pbidedicated.windows.net", "datamart", [CreateNavigationProperties=false]),
table = Source{[Schema = "model", Item = "Query"]}[Data]
in
table;

[v-mengzhu-msft]

Hi @dphugo ,

It seems to be a query issue, how was your data mart created? What is the data source?

Best regards,

Community Support Team Selina zhu

[dphugo]

Hi @v-mengzhu-msft,

The data source is a Azure Hyperscale DB with a SELECT * query with one WHERE condition.

Kind regards,

Daniel