cancel
Showing results for 
Search instead for 
Did you mean: 

Datamart of a Table Query generates "Unexpected Error"

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;

Status: Needs Info

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

Comments
v-mengzhu-msft
Community Support
Status changed to: Needs Info

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
New Member

Hi @v-mengzhu-msft,

 

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

 

Kind regards,

Daniel