Have you looked into resolving through DNS rather than IP? Azure DNS?

Have you tried using SSIS?
SSIS has a lot of Azure components and will do what you are asking quite easily.
Data Factory will as well, ,not sure about Flow...

Hi Anthony,

Yes I have gone through that and I am happy I have satisfied the pre-requiesites.

And yes, DEV and LIVE are both enterprise editions.

Hi Brian,
I'm not deploying/processing a database.(I can do that)
What I have is a Live and Dev environment and instead of deploying the solution again to DEV I want to...

Hi,
No, I pass through fiscal year in the dataset on purpose.
Anyway, I did solve my issue
The way to open up a new window in javascript with passing parameters...

Thanks. That was a useful read

Process Add will allow you to put in a query so you can just capture the data you need to process on a daily basis.

If you script out...

I solved it in the end!

I did this with my member assignment

WITH

MEMBER [CompareDates]

AS

"{

[Date].[Calendar Date].[Date].&[20050701]

,[Date].[Calendar Date].[Date].&[20050702]

,[Date].[Calendar Date].[Date].&[20050703]

,[Date].[Calendar Date].[Date].&[20050704]

}"

and then with that I can do

STRTOSET([CompareDates])

This solved my issue and I was able...

Thanks.

I did have this working but instead of using a SET I used separate members to do the dates like I did in the WHERE slicer

and this worked out the...