Forum Discussion
Discrepancy Between SAP Production Data and Power BI
Hello Gao,
Thank you so much for replying to my message! Really appreciate it.
1. Our SAP HANA consultant has confirmed that the account that I use has access to read data from SAP HANA database in Production. Please let me know if this level of access suffices to access data in Power BI. At my end, when I query tables (using the advance option), I can access them. The nature of my query is such SELECT * FROM SAPHANADB.MARD.
2. As I am in the intial step of just transforming data, I haven't applied any transformation steps yet. Here's a snippet of what my current transformation looks like
3. Yes, I do make sure that the data is refreshed regularly.
4. I am not aware of HDI Container based Calculation View or the HDI runtime container. How do I check if I am using these calculation views in Power BI? I beleieve this is different from using native database query SQL statement?
5.I believe I have the latest version of Microsoft Desktop
I look forward to further guidance.
Regards,
Merlyn
Hi Merlyn ,
Could you finally please double check the version of SAP HANA ODBC Driver?
Installing SAP HANA ODBC Driver on Windows 64 Bits | SAP Help Portal
If this is still not the problem please consider opening a ticket using the URL below:
newsupportticketBest Regards,
Gao
Community Support TeamIf 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