Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Errors in Powerbi after switch to AlphaVantage

I switched to AlphaVantage yesterday as googleweb stopped working. Works fine in Excel but I'm receiving many errors in the graphs on powerbi.
Here the error. It's lengthy so I'll cut a bunch off the end.

Error Message:
MdxScript(Model) (89, 187) Calculation error in measure 'Report'[Equity Value]: A table of multiple values was supplied where a single value was expected.

OS Version:
Microsoft Windows NT 10.0.16299.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 461308]

Peak Virtual Memory:
34 GB

Private Memory:
350 MB

Peak Working Set:
461 MB

IE Version:
11.309.16299.0

User ID:
bc70b973-7bcc-4fdc-b2f1-fbb994cd20b9

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\Rick\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot73793132.zip

Performance Trace Logs:
C:\Users\Rick\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_AdobeAnalytics
PBI_qnaExplore
PBI_variationUIChange
PBI_customVisualsGallery
PBI_canvasTooltips

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

shared Account = let
Source = Excel.Workbook(File.Contents("X:\portfolio\PortfolioSlicerV2.3-XL16.xlsx"), null, true),
Account_Table = Source{[Item="Account",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Account_Table,{{"Account", type text}, {"Portfolio", type text}, {"Tax", type text}, {"Currency", type text}, {"Active", type text}, {"Account Group 1", type text}, {"Account Group 2", type text}, {"Account Group 3", type any}, {"Calc WHT", type text}, {"DRIP", type text}})
in
#"Changed Type";

shared Config = let
Source = Excel.Workbook(File.Contents("X:\portfolio\PortfolioSlicerV2.3-XL16.xlsx"), null, true),
Config_Table = Source{[Item="Config",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Config_Table,{{"MinDate", type date}, {"TrackCash", type text}, {"MarketIndex1", type text}, {"MarketIndex2", type text}, {"DripFlag", type text}})
in
#"Changed Type";

shared Trans = let
Source = Excel.Workbook(File.Contents("X:\portfolio\PortfolioSlicerV2.3-XL16.xlsx"), null, true),
Trans_Table = Source{[Item="Trans",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Trans_Table,{{"Account", type text}, {"Date", type date}, {"TransType", type text}, {"TransSubType", type text}, {"SymbolName", type text}, {"Qty", type number}, {"Price", type number}, {"Fee", type number}, {"ExchRate", type number}, {"Comment", type text}, {"CostBasisOverride", type number}, {"AccruedInterest", type number}, {"ExchRateRpt1Override", type number}, {"ExchRateRpt2Override", type number}, {"ExchRateRpt3Override", type number}, {"TTR", Int64.Type}, {"TotalAmnt", type number}, {"CashImpact", type number}, {"CashBalance", type number}, {"QtyChange", type number}, {"QtyHeld", type number}, {"Symbol", type text}, {"TransID", Int64.Type}, {"QHBS", type number}, {"CBI", type number}})
in
#"Changed Type";

etc etc etc

Comments

Sign In or Register to comment.