POWER BI user acess and An IEdmModel instance failed validation while accessing Odata feed from NAV

[rahulverma]

HI ,

I am getting the user access error while i try to fetch data from OData page feed from navision and getting the error

Details: "OData: Request failed: The remote server returned an error: (500) Internal Server Error. (An IEdmModel instance was found that failed validation. The following errors were reported:
BadProperty : The member name 'Inventory' cannot be used in a type with the same name. Member names cannot be the same as their enclosing type.
)"

I have duplicate the issue on my local computer also.

I have analysed the event viewer logs and found the below errors while i try to access odata feed in POWER BI desktop version.

The description for Event ID 46 from source MSOLAP$AnalysisServicesWorkspace2019673146 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

　

If the event originated on another computer, the display information had to be saved with the event.

　

The following information was included with the event:

The description for Event ID 72 from source MSOLAP$AnalysisServicesWorkspace2019673146 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

　

If the event originated on another computer, the display information had to be saved with the event.

　

The following information was included with the event:

　

C:\Program Files\Microsoft Power BI Desktop\bin\FlightRecorderSnapshotDef.xml

[v-qiuyu-msft]

Hi @rahulverma,

I 'm trying to involve sennior engineer to have a look at this issue. But they want top collect below information from you:

1. What is the exact entity / full URL they are attempting to connect to?
2. Does this work directly from the NAV server using localhost?
3. Did this work previously?  If so, when did this first start to fail?
   1. Also, if this did work previously, what changes have been made since then?
4. Does this occur for any user?
5. What are the results if they use the base URL of http://localhost:7048/DynamicsNAV90/OData?
6. Does the URL being used pull the data properly if input into an Internet Explorer window?
7. What is the full version of Dynamics NAV?
8. What is the full version of Power BI Desktop?
9. Also, please capture the following logs while recreating the issue.
   1. Fiddler Trace
   2. Power BI Desktop Trace

Steps for these traces are below for your convenience.

Fiddler Trace

============

1. Install Fiddler from http://www.telerik.com/download/fiddler/fiddler4 if not already done
2. Launch fiddler, then click Tools > Fiddler Options
3. Click the ‘HTTPS’ tab.
4. Verify the options are set as shown in this screenshot:

5. If fiddler prompts you to trust their root certificates, then click ‘Yes’.

6. Then navigate to repro the problem while fiddler is capturing traffic.

7. After the trace is captured, go to File > uncheck box next to Capture Traffic

8. File > Save > All Sessions and send the traces to me.

Note: Once we are completed with troubleshooting please uninstall this application from your computer.

Power BI Desktop Trace

==================== 

1. Go to File > Options and settings > Options

1. Select Diagnostics tab
2. Put a check in Enable Power BI Designer Tracing.  
3. Click on the Open traces folder to get to where the data is logged. This is where the file will be outputted for you to collect once you have completed tracing.

5. Reproduce the issue, noting the date and time that the error occurred.

6. Once done reproducing the issue, go to the traces folder and send me all files in that folder.

Best Regards,
Qiuyun Yu

[Anonymous]

Just starting today with the new download of the new PowerBI Desktop - I'm getting the following errors:

The description for Event ID 11 from source MSOLAP$AnalysisServicesWorkspace995042309 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

[rahulverma · Accepted solution]

Hi @v-qiuyu-msft,

Thanks for reply.

I am able to resolve the problem.

Point 1 :-It was due to duplicate name in data field of Odata service.

For example:-http://localhost:7048/DynamicsNAV90/OData/Company('CRONUS%20USA%2C%20Inc.')/Invenotry

Data item field name of odata was also Invenory so  i have changed the service name to Item Inventory.

http://localhost:7048/DynamicsNAV90/OData/Company('CRONUS%20USA%2C%20Inc.')/ItemInvenotry

Point 2 :- And user access problem was coming due to company name format in Odata URL.

so i have changed it to below:-

http://localhost:7048/DynamicsNAV90/OData/Company('CRONUS USA, Inc.')/ItemInvenotry

and user access problem get solved