Skip to main content
Showing results for 
Search instead for 
Did you mean: 

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.

New Member

Need to consume CDS Views with Paraments from S4HANA Cloud to Power BI

Hi There,

We have to consume S4HANA Cloud CDS veiws with parameters in Power BI, please find the below scenario 

1. Creating Custom CDS view using sales order cube [standard CDS]



2. CDS with parameter 


After communication scenario and communication arrangements, genetrated Odata Service url in S4HAna cloud


3. In power bi tried to consume this odata url through Odata feed, we are facing the error as below.


Anyhow, We can able to consume the CDS without parameters using Odata service Url in power BI.

Please suggest us how to pull the CDS views with parameters.


Thanks & Regards,

Abdul Suhana.





New Member

Hi there,

Iam new to PoweBi, i have question that, do we require SAP HANA database to consume parameterised standard CDS views to power Bi through Odata url in S4HANA Cloud, or else do we have any other option withouth using HANA database we can consume cds views to powerbi.


Actually when iam trying to create CDS views in S4HANA cloud, given parameters and generated Odata url to consume data in PowerBi, iam getting error like this when iam loading the data.


Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] OData: Request failed: The remote server returned an error: (500) Internal Server Error. (Runtime Error: 'TSV_TNEW_PAGE_ALLOC_FAILED'. The OData request processing has been abnormally terminated. If you use SAP S/4HANA Cloud, please create an incident. Otherwise, if "Runtime Error" is not initial, launch ADT feed "Runtime Errors" or transaction ST22 / SM21 (system log analysis) for details and analysis.). '

Community Support
Community Support

Hi @Abdul_Suhana ,


It seems that some fields couldn't be found in your data source, I think you can try to remove this field in advance editor and try again.

Transform Data > Advance Editor > find "YY1_Salesorder..." and remove it in M Query.

Or please check your data source and make sure whether it is in it.


Also you may refer to the official documentation below to check if the prerequisites for connecting to the SAP HANA database are met.

For reference: Link1
Here are the detailed steps to connect to SAP HANA database using Power BI please check.

For reference: Link2


Best Regards,
Rico Zhou


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.