Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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:
Steps for these traces are below for your convenience.
Fiddler Trace
============
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
====================
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
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:
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |