I usually create a template that contains all the necessary formatting. Although I believe it would be possible to do some formatting with a script task, it would be extremely...

You should be able to filter or ignore any rows with no value in Col B in SSIS, or alternatively import all the data into a staging table and filter...

It's not impossible, but the question is what the value of that indicator will be when you're looking at more than one customer type or more than one product type?...

Pretty sad situation if you go to all the trouble of building SSAS cubes, but you're not able to provide direct access to your end users. 

If you use...

A few thoughts: Understand that CDC is not going to be implemented, but have a close look at the source schema again. It is my understanding that Dynamics CRM contains...

https://sqlserverbi.blog/2016/06/13/row-level-security-just-got-better-passing-report-credentials-to-analysis-services-in-sql-server-2016/

https://docs.microsoft.com/en-us/sql/analysis-services/supplemental-lesson-implement-dynamic-security-by-using-row-filters

Before answering your question, my own would be why you would want to drive type-2 changes for every record. Are you trying to save 20 lines of code and the...

Was there an error message, and if so what is the error message? Are you sure your data source connection is pointing to the right server/database?

As the others have said, a Power BI Pro license will cost you $10 per user/month. To compare it with SSRS pricing, you really need to look at the edition...