Refresh Issue with Dynamic table input

Power BI
1

Hi,

I have sql data source and in that sql server we have many DB .

I created a function in power query which take DB name from one of the static table and based on the name of DB it bring the data from respective DB’s as all DB contain same table.

image
image663×518 10.8 KB

image
image1101×382 28.3 KB

My problem arise when i publish it and while setting its refresh it mark it as dynamic source so i am not able to create its refresh .

image
image721×130 4.49 KB

Any post any help is appreciated.

Thanks,
Anurag

1 Like
2

Hi @Anurag,

Don’t know if that’s possible… examine this article and especially the links below it.
https://medium.datadriveninvestor.com/setting-a-scheduled-refresh-on-a-dynamic-data-source-in-power-bi-409ccec7337b

Let me highlight these:

3

Hi @Melissa

Thanks for those link i already end up while searching and i found out its not look do able now what i want to achieve.

Thanks