MELISSA MCCORRISTON on 9/23/2022 12:48:01 AM
Power BI
Allow users to create visual querys and SQL Querys in Service without contributor access to the datamart/workspace
Allow users to create queries (both with SQL and visual) on the Datamart within Power BI Service without granting them permission to edit the Datamart. This will allow users to access the data they need in the format they need.
Ashwani Tiwari on 12/13/2022 6:43:58 PM
Power BI
PowerBi datamart RLS: Dynamic role assignment
I want to setup roles based on business units. One role per business units. User can see records from their business units. When ever a new member is added in business unit respective role should be assigned to them. We can achieve using myaccess projects or security groups.
But in powerbi datamart role assignment, it doesn't allowing me to add security group in a role. What is alternate for this.
Brian Hayes on 10/4/2022 6:13:08 PM
Power BI
Have Consistent UI For Datamart and Dataflow Refresh Errors
When there is a dataflow refresh error, it is possible to access the refresh history using the warning glyph - as well as via the "More options" icon/glyph. Being able to access the refresh history using warning glyph is an obvious way to access the history so that you can get to the CSV file with the failure information.
When there is a datamart refresh error, the refresh history cannot be access via the warning glyph.
Dan McAllister on 4/7/2017 2:12:50 AM
Power BI
PBI Access to the "Financial Reports" Datamart from Dynamics 365 for Operations
Add the Financial Reports" datamart (fka Management Reporter) as a data source for Power BI so we can easily build financial reports in Power BI. Either that, or add the ability to embed PBI tiles in Financial Reports.
CHRISTOPHER REYNOLDS on 9/5/2023 3:14:44 PM
Power BI
Can't view the visual error in App from Report based off DataMart
For reports based off Datamarts only, users are getting a "Can't display the visual. See details" error on every visual in the App.
To fix this issue, I have to give these users "Viewer" access to the workspace. This isn't ideal, since the primary benefit of the app is that I can share with the Entire Organization without needing to give everyone access to the workspace.
Barry Whitlow on 10/7/2022 6:17:46 PM
Power BI
Power BI Datamart allow Views/queries to be referenced again by another View/query.
It would be great if you could add the feature to the Power BI Datamart allow Views/queries to be referenced again by another View/query. In most Databases/DataMart's if you build a view/query. You can then reference that view/query. They are commonly referred to as "Nested Views" This would be extremely beneficial. This would allow it to be used by other development of views/queries.
Thank you.
Theo Kontos on 3/21/2023 5:48:55 PM
Power BI
Query a Power BI Dataset into a PBI Datamart using the native Power Query interface
Our team needs the ability to query a Power BI Dataset that is published in the service, into a Datamart, so we could take weekly snapshots without using Excel, Power Automate, or another solution. This helps us bring the data straight in and is much easier to maintain than Power Automate solutions. Right now Power Query in Dataflows/Datamarts does not allow querying Power BI Datasets, which seems a bit counterintuitive.
Yue Lyu on 9/29/2023 9:28:25 AM
Power BI
Send notifications when Data mart refresh fails.
Currently, when the Datamart refresh fails, we do not receive notification emails, and there is no API to check if the Datamart refresh has failed.
Implementing the feature would be greatly appreciated.
Thye Jansman on 7/18/2022 1:46:26 PM
Power BI
Multiple On-Premise Data Gateway per query/mashup
Currently, all queries in one 'project' must use the same On-Premise Data Gateway. Not sure why it was designed this way, but in order to use a datamart like a datawarehouse and combining multiple sources, there can't be just one gateway.
Suggestions:
- Possibility to use mutiple gateways per project;
- Possiblitiy to NOT use a gateway for a source/project (cloud resources), when combining with resources that need one
- Possibility to add multiple projects per Datamarts, so the limited use of one gateway isn't a problem.
Power BI User on 5/16/2017 1:02:51 PM
Power BI
PowerBI connection in SSIS
Can we have Power BI integrated as a connection on SSIS so that when the data is processed and ready on the DWH/DataMart or Cube, it can refresh the Power BI Dashboard in the package itself.