topic M Query to R Script in Developer

M Query to R Script

Marcky — Tue, 11 Oct 2022 00:30:43 GMT

Hello Guys,

Can anyone help me here please?

im trying to convert this m query to R script for me able to extract it. Its working on the PBI desktop but when it comes in PBI Service its wont refresh due to the dynamic query, so I am trying to get the data in other way.

(site as text) =>
let
Source = OData.Feed("https://Sample.sharepoint.com/sites/pwa/"&site&"/_api/web/lists/GetByTitle('Issues')/Items()?")
in
Source

Thank you.

Re: M Query to R Script

Anonymous — Wed, 12 Oct 2022 01:04:13 GMT

HI @Marcky,

perhaps you can try to parameterized your connection string with query parameters. Then you can modify these parameters to get data from different path.

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev

Notice: these data sources need to have same data structure or it will show the error about the new records not match with cached data structure keys.

Regards,

Xiaoxin Sheng