How to avoid the 'dynamic data source' error during Power BI Service refresh

[Fern_21]

Hi all!

On a sharepoint list, the user uploads me images. I have to put these images in the Projects list (which is what I load on the report), which also contains the fields Title, ProjectName. Once this Projects list is loaded on Powert BI, I need to be able to display the corresponding image for each project.

This is the code that I use.

let

SharePointSite = "https://[nome_sito_sharepoint]/sites/[nome_sito]",

ListName = "[Nome_lista_progetti]",

Source = OData.Feed(SharePointSite & "/_api/web/lists/getbytitle('" & ListName & "')/items", null, [Implementation="2.0"]),

SelectedColumns = Table.SelectColumns(Source, {"Title", "Project_Name", "URL_Immagini"}),

#"Added Image Data" = Table.AddColumn(SelectedColumns, "ImageData", each try Web.Contents([URL_Immagini]) otherwise null),

#"Added Base64 Image" = Table.AddColumn(#"Added Image Data", "Base64Image", each
if [ImageData] <> null
then "data&colon;image/jpeg;base64," & Binary.ToText([ImageData], BinaryEncoding.Base64)
else null
),

#"Added Custom" = Table.AddColumn(#"Added Base64 Image", "SharePointImageURL", each [Base64Image])
in
#"Added Custom"

This works when I refresh it in Desktop, but when I publish it to the Service, I get this 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."

How to avoid this mistake?

Thanks

[GilbertQ]

Hi @Fern_21 

The reason for this is because the url is based off parameters. It is not a defined. url that can be accessed. There is a work around for this in Chris Webb, blog post where he explains how to move those components to a different part of the URL. Chris Webb's BI Blog: Web.Contents, Text Concatenation And Dataset Refresh Errors In Power BI/Power ...

[Fern_21]

Hi @GilbertQ !

Even following this concatenation logic with '&', I continue to receive the refresh issue on the Service.

How can I resolve ? 

Thanks

[Anonymous]

Hi  @Fern_21, hello GilbertQ, thank you for your prompt reply!

To determine whether your dynamic data source can be refreshed, open the Data source settings dialog in Power Query Editor, and then select Data sources in current file. In the window that appears, look for the warning message, as shown in the following image:

If that warning is present in the Data source settings dialog that appears, then a dynamic data source that can't be refreshed in the Power BI service is present.

As a workaround, we suggest you store images on a public site.

More information for your reference:

Data refresh in Power BI - Power BI | Microsoft Learn

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.