Great session, Thanks for making it available on RU-vid. One question here, looks like Tabular model is extension of multidimensional model, so what is the counter part of semantic model. For example, in SSRS 2008, there was a concept of semantic model which could connect to cubes as well as directly to database. It was a user friendly model, which gave business users capability to create their own reports. Suppose we want to migrate those SSRS reports to Power BI, for example there are two categories of reports, Semantic model based SSRS reports which use cubes and which do not use cubes. The ones which use cubes can be migrated using this video , by creating a user friendly model, is there any way we can migrate the semantic reports which don't use cubes, there is a way that we generate physical SQL query for them but that approach is not good for business users so I am looking for an approach which will create a semantic kind of model. Please let me know if my question is not clear. Thanks in advance for your suggestion,
Hi Peter...I am trying to connect Azure SQL DW in Direct Query mode with SSDT and get this error - Failed to save modifications to the server. Datasource has authentication kind OAuth2. This is not supported in DirectQuery 1400 mode. I read in the MS docs that Direct Query mode is not supported with OAuth credentials. Need help.
The Web designer was a Beta version that has been taken off from 1st of March. Can you help or create a video on how to connect to Azure Analysis Services using Data Tools?