Dynamic M Query not supported in the Power BI Web for Odata Feed (From SAP S/4 Hana)

[PankajMantri]

Hi , 

I am in the process of preparing the dashboards in Power BI. The data source is ODATA services from SAP S/4. I am able to successfully get the data from SAP using the ODATA service call in Power BI Desktop with parameters(from sharepoint list)  . but when I published in the Power BI Service , i am getting the below error :"This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed."

m

[GilbertQ · Accepted solution]

Hi @PankajMantri 

You can use the solution below

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...

[v-hjannapu · Accepted solution]

Hi @PankajMantri,

Thank you  for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank @GilbertQ , for actively participating in the community forum and for the solutions you have been sharing in the community forum. Your contributions make a real difference.

This error usually happens when Power BI sees the data source URL as dynamic  for example, if you are building the OData URL using parameters from a SharePoint list. Power BI Service doesn't support refresh for such dynamic sources.

To fix this, you can try using the Web.Contents function with RelativePath and Query options. This makes the URL more static, and Power BI will then allow scheduled refresh.

Kindly refer to the below documentation links for better understanding:
https://learn.microsoft.com/en-in/powerquery-m/web-contents

Hope this helps if you have any queries we are  happy to assist you further.
Best Regards,
Harshitha.

[v-hjannapu]

Hi @PankajMantri,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Harshitha.

[v-hjannapu]

Hi @PankajMantri,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Harshitha.

[v-hjannapu]

Hi @PankajMantri,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.

Regards,
Harshitha.

[GilbertQ · Accepted solution]

Hi @PankajMantri 

You can use the solution below

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...