Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I keep getting the following error when trying to refresh Power BI -
Expression.Error: We cannot apply field access to the type Null.
Details:
Value=
Key=company_name
I am querying Sage 200 with their own custom connector.
The refresh will work but I will have to try about 10 times for it to do so.
Full error - Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We cannot convert the value null to type Table."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: Customers.
I have tried so much here and cannot get to the bottom of the issue. Please help thanks
Thanks but why could that be? It seems to work mostly fine in the query editor but as soon as I want to load it into a report it gives me this error? Thanks
The query editor is usually limited to a subset of rows, 1000 or less. Maybe the full load is overwhelming the source.
Thanks but I dont think so as I have trailed this with smaller queries of no more than 10 rows
The error means that the call to Sage 200 returned no data.
Read about try ... otherwise ...
User | Count |
---|---|
77 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
100 | |
93 | |
52 | |
50 | |
48 |