fbcideas_migusr
10 years agoNew Member
Status:
Needs Votes
Data Modelling when connecting to SSAS Tabular
We need to be able to mashup data online with enterprise data in a SSAS cube. To do this, we'll need the data modelling feature accessible when connecting to SSAS Tabular.
10 Comments
- gmelhaff1New MemberThis should be considered a critical feature
- ecklesNew MemberThis is needed not just to mashup data, but to allow users to make minor changes like establish new hierarchies or groupings.
- mahimasNew MemberThis is a big road block for us. We need to be able to make changes to enable true self service BI.
- ragnar1New MemberThis feature would make a big impact for users with other tools wanting to change. This would rock the hell out of Power BI
- john_byrnesNew MemberYep. Mixing internal and external data is important to us.
- fbcideas_migusrNew MemberThis is indeed a key missing feature and hard to understand why Excel can connect to multiple sources likes SSAS and other, but PowerBI cannot. It might become a kind of complex problem under the hood, but in my case it would be sufficient to render the different data sources on different Report pages. May be this is easier to accomplish?
- andrewt1New MemberIt seems like this shouldn't be a problem. You CAN add data from SSAS to a report with SQL Data, but you can't start from a SSAS model and add data from SQL sources. For me, this would be the more sensible approach. I have most of the data I need in my SSAS model, I just have some other bits out there I want to combine sometimes.
- bsvannieropNew MemberI believe this is pretty much the same idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12532173-ssas-get-data-multiple-data-sources?page=1&per_page=20
- aby_mathewNew MemberSTRUGGLE TO UNDERSTAND WHY POWER BI PUT OWN LIMITATIONS TO SSAS tabular.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Semantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v1 hour agoCommunity ChampionNew10Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401974 hours agoFrequent VisitorNew5Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf14 hours agoFrequent VisitorNew48Views3likes2Comments