Forum Discussion
Dynamic M Query not supported in the Power BI Web for Odata Feed (From SAP S/4 Hana)
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
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-contentsHope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.
5 Replies
- GilbertQ
Super User
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-contentsHope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.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.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.