cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

 

 

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

 

IEDM.JPGUser Access.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

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

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

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

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

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:

111.jpg

 

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

1111.jpg

 

  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.

11111.jpg

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

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

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

View solution in original post

Highlighted
Regular Visitor

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

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:

 

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Users online (602)