Extend the tabular data model to be cloud hosted without the 10 GB constraints in Power BI. Provide the ability to leverage Azure platform end-to-end for analytics. The combination of Azure SQL, Azure Tabular Data Model, and Power BI Reports/Dashboards should be available for users to create and centralize the data model in the cloud. The tabular data model should be editable within Power BI Designer and sync with the Azure Tabular Model.
3 Comments
- winterb1Advocate IWould be a great logical addition to the PowerBI service available. Having an enterprise tabular model with a single place to hold our DAX definitions and modelling logic would be valuable. Our analysts can access this cube on premise with Excel or in Excel Online workbook. Without a central tabular model in Azure, my analysts who wants to work in Excel (one of the greatest BI tools) against a cube would need to have the model (PowerPivot) embedded in their workbook. Once they do that, they need to worry about having a refresh schedule and a gateway online and available. I in IT need to worry about how to handle enhancement and bug fixes to that model that has been copied N number of times for each workbook. Our analysts like having an enterprise cube managed by IT (or Business power user), that they can connect to in Excel and build analytical reports (pivot tables/charts, slicers, etc.) and/or do ad-hoc analysis (drag/drop subtotaling, showing fields as % of, etc.) and share with others via One-Drive, network share, etc.
- BrynnBortonRegular VisitorThis would be great addition i.e the abilty to host large models in a paas tabular layer. We have some clients that want to use powerbi to query models containing billions of rows. Direct query to sql with these volumes is fairly sluggish and ssas hosted on a vm restricts a large amount of self service functionality. Having the same user experience coupled with the abilty to publish these large models would be ideal. A billing model similar to azure data warehouse would work well i.e separating cpu/memory consumption from physical storage. A model could be paused and hence unloaded from memory, or left running to ensure the model is always cached and hence immediately responsive to the end user. As a step further the idea of applying an mpp approach to ssas tabular where data is distributed across multiple tabular instances could allow for far greater volumes. Understand this would be a big architectural step, but could be great.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Fix Direct Lake semantic model binding in Deployment Pipelines
When deploying Direct Lake semantic models via Deployment Pipelines, the Lakehouse source is incorrectly treated as an external SQL source. This results in broken lineage and prompts for credentials....lk1236 hours agoAdvocate INew1.5KViews27likes2Comments:: operator for typecast in T-SQL
Introduce support for the ::type cast operator in Fabric Data Warehouse as syntactic sugar for the existing CAST(... AS type) expression. The new operator would be functionally equivalent and compile...jovanpop-msft8 hours agoMicrosoft EmployeeNew47Views7likes2CommentsAllow calls of Fabric SQL Database stored procedures from Data Warehouse
It would be great if there were a possibility to call a SQL Database stored procedures directly from a Data Warehouse stored procedures. A use case for this would be e.g. logging activities and even...Vojtech_Dolejsi11 hours agoNew MemberUnder Review2.9KViews13likes2CommentsPower BI - Org apps and cross-report drillthrough
This idea is a request to provide cross-report drill-through capability for org apps. This means being able to navigate between reports hosted in different org apps. The following sections detail why...TomMartens12 hours agoSuper UserNew1.3KViews24likes3CommentsSemantic Model 'Make Changes to this Model'
The link or action item to make changes to the importing Semantic Model is to obscure. Nobody looks down in bottom right corner of the Power BI Desktop window unless they want to resize the current ...RobRayborn12 hours agoHelper IVNew4Views0likes0Comments