The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello All,
I have connected to S4HANA in Power BI Desktop using SAP HANA DATABASE option in Get Data.
For the same I have used the ODBC driver & the connection is successful. I want to access the CDS view.
When I connect to datasource & the available table list gets opened. But I could not able to locate the required table(CDS View).
But the same table(CDS View) I do get, when I use the Advanced Option of writing the SQL Query.
I am unable to understand the issue.
Please guide.
Hi @MangeshVC ,
Being able to CDS table in power query means that the connection is successful, please check if any table is hidden. Or refresh all data, right click CDS table, open enable load.
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Thanks for reply.
But the issue is I am unable to locate the CDS Table itself in the database.
It can only be accessed using Select query in advanced option & it works for import mode.
But the same option is disabled for Direct query.
The CDS has used the required annotations as well as the OData released.
User | Count |
---|---|
80 | |
73 | |
40 | |
30 | |
28 |
User | Count |
---|---|
107 | |
97 | |
55 | |
47 | |
46 |