Thanks. I didn't see this page in particular, but I did watch the video on it previously. I could not pull out a definitive answer to the question though. As...

I'm not surprised with this. I feel like that for Microsoft, Azure is marketing rather than technology. They put just enough effort into building something out to say they have...

Thanks Grant & Steve. I think this is enough to get me going.

Thanks. I love your idea about versioning. Python does this and once I figured out that Synapse was on an older version, I could use the drop-down to set the...

I had a project with Synapse recently and I found the documentation to be lacking. For the most part, I was doing the Python ELT so I can't speak to...

Thanks Grant. I'm in the same boat as you in that my current knowledge will keep me employed until I retire which should be 7.5 years out. I'm just not...

Azure doesn't make it easier, just different. You deploy to the cloud. The VPN should connect him to the network so it will run just as if he's in the...

You could use SSAS Azure. If your boss can connect to the network with a VPN, that should also work.

Sorry, but I don't even know if MD supports many-to-many relationships.

If you want it to change in context, then it needs to be done in the measure. Calculated columns are done at processing time and don't change. Take a look...

If this is tabular, you can set up a two-way relationship on fact_datum. Off the top of my head I'm pretty sure it's to dim_Spell but it could be dim_Datum....

I do this all the time and have not had any problems. I agree that it is easier this way for related projects. Too many projects and then it becomes...

You can create a Tabular model in either place. There are a lot of pros/cons which I suggest you google for all of them. The primary for me is code...

Looks like this would give you the same, except the results are always numeric or blank:

DIVIDE([Complaint], [Received)*1000000

If Complaint is 0 it will be 0. If Received...

The rename will not empty the cube. I've done this with both tabular and MD, but the syntax is probably different for MD. It's been too long now so I...