question

SandipDeshmukh-7872 avatar image
0 Votes"
SandipDeshmukh-7872 asked KranthiPakala-MSFT commented

How to refresh Dynamic Data Sources in Power BI Services

Hi,

I have created Power BI Dataset using different data sources like Azure API, Sharepoint, SQL Database.

Now I have published this to Power BI Services and tried to refresh it but it's showing error message that, " 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. " I believe that this is because of API connections that I have used as a source for some files. So how can I overcome this error?

Below are first few rows of my MQuery Code of the file fetched from API Links,
let
Source = Json.Document(
Web.Contents(
"https://api.maerks.com/hr/v1/?activitytypeid=2&startdate="
& #"DynStartDt-60D-BFR-PM-Start-Txt"
& "&enddate="
& #"DynEndDt-BFR-PM-End-Txt",
[Headers = [#"Ocp-Apim-Subscription-Key" = "
**"]]
)
),
#"Converted to Table" = Table.FromRecords({Source}),
#"Expanded Table1" = Table.ExpandListColumn(#"Converted to Table", "Table1"),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Table1", {<!-- -->{"Table1", type any}}),
#"Expanded Table2" = Table.ExpandRecordColumn(
#"Changed Type",

not-supportedpower-query-not-supported
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @SandipDeshmukh-7872,

Thanks for the question and using MS Q&A platform.

PowerBI is currently not supported in the Q&A forums, the supported products are listed over here https://docs.microsoft.com/en-us/answers/products (more to be added later on).
Note: PowerBI is supported on their own forums. I would recommend reaching out on these forums for assistance: https://community.powerbi.com/

Hope this info helps.

0 Votes 0 ·

0 Answers