Errors in Powerbi after switch to AlphaVantage

charmed

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

dmorley64

I was having some issue with PowerBI today as well. I decided to start with a fresh download of the PortfolioSlicerV2.3.pbix file. I set up the links to my spreadsheet and data files and it fixed the problems I was having.

Perhaps try this or at least check the links in your PowerBI file to make sure they are still pointing to your spreadsheet and csv file locations.

VidasMatelis

You most likely have same issue as in this forum post: http://support.portfolioslicer.com/discussion/299/powerbi-original-currency-display-not-working-other-currency-fine#latest

Please use suggestions from that thread.

charmed

Deleting the quotes and symbols not used cured the problem thanks.

Rick