Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear all,
i was building a successful query for web content using power bi desktop, once all was set I pushed it to our on premise gateway, when I hit refresh I get an error which does not happen locally
let
strRangeStart = DateTime.ToText(RangeStart,[Format="yyyy-MM-dd'T'HH'Z'", Culture="en-US"]),
strRangeEnd = DateTime.ToText(RangeEnd,[Format="yyyy-MM-dd'T'HH'Z'", Culture="en-US"]),
Query1 = Json.Document(Web.Contents("http://xxxxx.xxxx", [Timeout=#duration(0,5,0,0),RelativePath="v2", Headers=[#"Authorization"="foo",#"Content-Type"="application/json"],
Content=Text.ToBinary(
"{
""queryType"": ""groupBy"",
""dataSource"": ""bids"",
""intervals"": """& strRangeStart & "/" & strRangeEnd & """,
""granularity"": ""month"",
""dimensions"": [""organization"",""os"",""account_manager"",{
""type"": ""extraction"",
""dimension"": ""campaign"",
""outputName"": ""campaign_type"",
""extractionFn"": {
""type"": ""registeredLookup"",
""lookup"": ""campaign_type""
}},
{
""type"": ""extraction"",
""dimension"": ""ad"",
""outputName"": ""content_type"",
""extractionFn"": {
""type"": ""cascade"",
""extractionFns"": [
{
""type"": ""registeredLookup"",
""lookup"": ""content_type""
},
{
""type"": ""registeredLookup"",
""lookup"": ""content_type_display_value""
}
]
}}
],
""filter"": {
""type"": ""in"",
""dimension"": ""event_type"",
""values"": [""bid"", ""click"", ""win"", ""buying_conversion""]
},
""aggregations"": [
{
""name"": ""bids"",
""type"": ""longSum"",
""fieldName"": ""bids""
},{
""name"": ""wins"",
""type"": ""longSum"",
""fieldName"": ""wins""
},
{
""name"": ""clicks"",
""type"": ""longSum"",
""fieldName"": ""clicks""
},{
""name"": ""impressions"",
""type"": ""longSum"",
""fieldName"": ""impressions""
},
{
""name"": ""supply cost"",
""type"": ""longSum"",
""fieldName"": ""win_price_eur""
},
{
""name"": ""revenue"",
""type"": ""longSum"",
""fieldName"": ""buying_price_eur""
},
{
""name"": ""spend rate"",
""type"": ""doubleSum"",
""fieldName"": ""spend_rate""
},
{
""name"": ""ap_conversions"",
""type"": ""longSum"",
""fieldName"": ""ap_conversions""
},
{
""name"": ""ap_customer_revenue_eur"",
""type"": ""longSum"",
""fieldName"": ""ap_customer_revenue_eur""
}
]
}"
)]
)),
totable = Table.FromList(Query1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
expand = Table.ExpandRecordColumn(totable, "Column1", {"timestamp","event"}, {"date","Column1.event"}),
custom = Table.ExpandRecordColumn(expand, "Column1.event", {"organization", "account_manager","os","campaign_type","content_type", "bids","wins","impressions","clicks","supply cost","revenue","spend rate","ap_conversions","ap_customer_revenue_eur"},{"organization","account manager", "os","campaign type","content type","bids","wins","impressions","clicks","supply cost","revenue","spend rate","ap_conversions","ap_customer_revenue_eur"})
in
custom
When I use a dataflow all works, but since we use incremental update and the workspace cannot be premium I need to stick with a dataset.
We use an on premise gateway:
I uses ananoumus authentication
But I have no clue what that error means?
the logs says something like:
M.EnterpriseGateway Error: 0 : 2023-02-22T20:20:33.8391400Z DM.EnterpriseGateway cbd63194-1766-4939-895b-b8f46ef0be60 779be232-a0ee-47a8-91cc-35b32ff3a7ec MGTD 062a95cf-3e0d-4157-9457-ec85a3af5fc1 fa96f4a9-d6e4-406e-a5c1-6b911e7727c4 fa96f4a9-d6e4-406e-a5c1-6b911e7727c4 CC89564C [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorMessage = <ccon>[ccon]Web.Contents failed to get contents from 'http://xxxxx.xxxx' (405): Method Not Allowed[/ccon]</ccon>
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
39 | |
33 | |
31 | |
25 |