The just (end of 2020) released "DirectQuery for Power BI Datasets and Azure Analysis Services" is a great feature, that leaves out AS multidimensional unfortunately. I see no chance that Microsoft would implement the whole feature also for AS Multidimensional. So the idea is to implement only the Direct Query part for AS Multidimensional and leave out the functionality of combining models and building chains. That means: Please allow to direct query Multidimensional, for example add a Sharepoint list or SQL data table. Allow to publish such a report on PBI Report Server on prem and to the PBI service. (Leave out the functionality to access this combined model via direct query - just because I don't see chances for implementation)
2 Comments
- michael18New MemberI added some more information regarding the idea here: https://www.mmertens.eu/2020/12/hype-about-directquery-for-power-bi-datasets-and-azure-analysis-services/
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Enable Paginated Report Authoring in Power BI Service When Public internet access is blocked
Currently, customers using Power BI Service with Private Link enabled and Internet access disabled are unable to create or author Paginated Reports directly in the Power BI Service. Provide support ...v-varunvv7 minutes agoMicrosoft EmployeeNew2Views1like0CommentsOption to Disable "Applied Filters" Sheet When Exporting Data from a Power BI Visualization
When exporting data from a Power BI visualization to Excel, Power BI automatically includes the "Applied Filters" worksheet and filter information. We would like an option to disable exporting fil...yokof5 hours agoMicrosoft EmployeeNew9Views2likes0CommentsHow to remind the Global team to respond to ECNs with greater efficiency
Suggest Power BI send emails to each responsible person, and display how many days they have spent handling each ECN, compared to the required number of calendar days for completion.richardzhu6 hours agoNew MemberNew5Views0likes0Comments