Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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