Refresh dynamic data source

[jaryszek]

Hi Guys,

i have table like here:

and code to add additional column with table sources is:

= Table.AddColumn(Table1_Table, "Custom", each Table.AddColumn(Table1_Table, "Custom", each if [ConnectorKind] = "Web" then Csv.Document(Web.Contents([Connector]),[Delimiter=",", Encoding=1250, QuoteStyle=QuoteStyle.None]) else Expression.Evaluate([Connector],[PostgreSQL.Database = PostgreSQL.Database])))

And it is nice but the issue is that after publising into power BI service it complains that dataset has dynamic datasource which can not be refreshed which i neeeed so much.

How can i create one table with refreshable tables as one additional column? 
From queries i will just refer to this one table.

Please help,
Jacek

[jaryszek]

Hi @v-cgao-msft ,

ok i checked possibilities and using gataway solving issue entirely. 
So i suppose that relative path will work only for external internet connections but can you please confirm?

Best,
Jacek

[jaryszek]

Thank you, 

does Microsoft have also documentation about it?

Best,
Jacek

[v-cgao-msft]

Hi @jaryszek ,

This is briefly mentioned in the official document. Please refer:

Data refresh in Power BI

Best Regards,
Gao
Community Support Team

[jaryszek]

O wow not any more and not about m language query parameter syntax...

best,
Jacek

[v-cgao-msft · Accepted solution]

Hi @jaryszek ,

To refresh dynamic data sources in Power BI Service, you can use Web. Contents() and Relative Path parameter in it, please refer:

Web.Contents(), M Functions And Dataset Refresh Errors In Power BI

Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code

Setting a scheduled refresh on a Dynamic Data Source in Power BI | by dataninja

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data