I have created a composite model and published it to the service but having issues with other users seeing the data. Here is my current setup: Workspace A: PowerBI Dataset A Workspace B: Power BI Report A (composite model using the data below) PowerBI Dataset A Gateway access to 3 .csv files ...
I want a way to export a visual matrix (already assembled in my Power BI report) and take it to excel, without the data being tabulated vertically.
We have made improvements to export to Excel recently: https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave2/power-bi/export-excel-improvements-table-matrix-visuals. Marking this ideas a completed.
In order for a Power Query data source to be refreshable via scheduled or on-demand refresh inside the Power BI service, the Web.Contents base URL has to be hardcoded. For example, the following is not allowed: (URL) => Web.Contents(URL) Only the following is allowed: Web.Contents("https://bing...
Power Query supports dynamic URL refreshes with the Web.Contents function - https://docs.microsoft.com/en-us/powerquery-m/web-contents
Currently you have to connect via gateway, but it would be much more convenient to be able to connect directly from PowerBI to Snowflake.
Currently a fix credential is used to configure connectivity from Denodo connector in Data Gateway to Denodo Server. It is not able to capture login user in Power BI service and allow pass through down to Denodo Server so that only authorized rows/dataset is return. Please work on this ASAP as we...
SSO support for Denodo exists today within Power BI, to learn more: https://powerbi.microsoft.com/en-us/blog/power-bi-denodo-end-to-end-security-through-single-sign-on-sso/
Allow users outside organisation to receive subscription email like users within the organisation currently do
This was added
Data Analysts want to be Power BI certified professionals. You should have a certification exam for professionals. Expected Exam Fee: Below $200 Any votes?
The DA-100 Exam exists today - https://docs.microsoft.com/en-us/learn/certifications/exams/da-100
Now that Power BI has the Analyse in Excel function, can you please make Excel Online (Excel in a browser) connect to the Power BI data source so slicers and timelines function and the workbook can refresh from the Power BI data source?
PivotTables connected to Power BI datasets are supported in Excel Online.
Now that the "analyze in excel" has been released it would be nice if Excel Online recognized Power BI an internal data source. This would allow users to make Pivot tables in excel (connected to a data model) and upload them as "First Class Citizen" excel files with full functionality. Don't kn...
The Excel team is currently rolling this feature out please review the following blog post for additional information - https://techcommunity.microsoft.com/t5/excel-blog/power-bi-connected-pivottables-in-excel-for-the-web/ba-p/2175918
Allow the Power BI admin role to access the Power Platform admin portal. This will allow the Power BI admin to see all data gateways used in an organization.
Power BI admins have access to configure and administer gateway resources via the Power Platform Admin Center, to learn more: https://powerbi.microsoft.com/en-us/blog/add-and-edit-power-bi-data-sources-on-power-platform-admin-center/
Administrator
Thanks - we are investigating to change this before GA of this feature.
Update 4/11/2023: this feature is now GA: https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-for-composite-models-on-power-bi-datasets-and-analysis-services-models/