Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
84 | |
80 | |
70 | |
47 | |
43 |
User | Count |
---|---|
109 | |
54 | |
50 | |
40 | |
40 |