Dynamic Date (30Days ago) and Dynamic Data Source error, no scheduler

[Anonymous]

Hi all,

i have a Odata API Call where i want to get only the last 30 days based on the Date Column "lastSeen", GT stand for "greater than".

The API CAll is:

"https://api.securitycenter.microsoft.com/api/machines?$select= id, computerDnsName$filter=lastSeen Gt 30DaysAgoDate"

The 30DaysAgoDate Value is dynamic. I use M-Code and it works on Power BI Desktop. 

filter=lastSeen Gt "& (Date.ToText(Date.AddDays(Date.From(DateTime.FixedLocalNow()), -31), "yyyy-MM-dd")

But it is a Dynamic Data Source and i can not turn on the scheduler,

when i publish the report.

If i would use filter=lastSeen Gt 2022-03-03, i wouldn´t get the error.,

but this is not dynmaic.

How can i get dynamic "last 30 days" and setting up ther scheduler in pbi online?

Thanks for your help.

[v-luwang-msft]

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi  @Anonymous ,

this blogpost consolidates all relevant info about dynamic datasources: http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/

Similar  error code question refer:

https://community.powerbi.com/t5/Power-Query/Dynamic-data-sources-aren-t-refreshed-in-the-Power-BI-service/td-p/1563630 

https://community.powerbi.com/t5/Service/Error-while-schedule-refresh-getting-error-quot-This-dataset/m-p/1326552 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien