Discrepancy Between SAP Production Data and Power BI

Hi Merlyn ,

-- Extracted data from SAP Production for material number ET80HT-100 for the year 2024 in a certain table MARD does not match the data imported in Power BI. Infact, there is no 2024 data for the material number ET80HT-100 in Power BI as opposed to actual data existing in SAP Production.

1. First, make sure you are using an account with the same permissions to view/query the data.

2. Next check to see if a transformational step has been applied in PowerQuery that could affect the results.
3. Make sure that the data in Power BI Desktop is refreshed after making changes to the data source. You can refresh the data manually by clicking on the "Refresh" button.
4. If you are accessing HDI-container-based Calculation Views in Power BI, ensure that the HANA database users you use with Power BI have permission to access the HDI runtime container that stores the views you want to access.
Power Query SAP HANA database connector - Power Query | Microsoft Learn

The easy way to make your HDI container accessible... - SAP Community
5. Try updating to the latest version of PBI Desktop and then try connecting to the SAP HANA database.
Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum