User Profile
-Rem-
Frequent Visitor
Joined 6 years ago
User Widgets
Contributions
Can Pro users access Workspace Apps hosted on an EM SKU Premium Capacity Workspace
Hello, I am currently facing he following scenario: the company has a E5 license for everyone, so all employees have Power BI Pro. The company now wants to add Premium Capacity to their PBI landscape. They are considering getting an EM1 license since the capacity needs are somewhat limited. However one department is hosting their reports via a workspace app and that workspace is one that requires Premium capacity. Now sharing scenarios using EM SKUs seem to be somewhat limited according to this: What is Microsoft Power BI Premium? - Power BI | Microsoft Learn I want to talk especially about this passage: P SKUs allow free Power BI users to consumer Power BI apps and shared content, in the Power BI service. EM Premium SKUs do not support unlimited content sharing, though they do support embedding in applications. So there seems to be a limitation on Power BI Apps. With a P1 license even users without Power BI Pro oder PPU would be able to access a workspace app. However if a workspace is hosted using capacity from an EM1 SKU, would non-free users, be able to access that app - and would they be fine accessing with a Power BI Pro license or would they need a Premium per User license to access the app?Solved671Views0likes1CommentRe: Dataflow shows connection to Web data source when I am not using any
Well... exporting the JSON and re-importing it made the Web source go away. Still not sure where that web source came from (originally I tried using Excel on OneDrive as a source but I never selected a file so I did not expect this to create a source entry) but this issue is fixed now.2.2KViews0likes0CommentsRe: Dataflow shows connection to Web data source when I am not using any
Hey Denis, I checked now and for every query it shows me as source Source = Table.FromRows(...) when the source is Enter Data and Source = Sql.Database(...) when the source is SQL Database. I see no calls to Sharepoint in the M code for all the queries. Best wishes2.2KViews0likes0CommentsDataflow shows connection to Web data source when I am not using any
I have created a new dataflow and if I look at it in the PBI Service, the Lineage View is showing a Web data source. Similarly, in the settings for the flow, there are credentials for that particular data source. However, if I open up that particular data flow, I am never accessing that web data source in any of my queries. They are all either sourced through "Enter Data" or coming from SQL Server. Ultimately, I'd like to remove this unused web data source because I fear it will cause problems further down the line. How do I best go about that?Solved2.2KViews0likes4CommentsSUMMARIZECOLUMNS - Sólo el valor superior para varias agrupaciones
Tengo una tabla que contiene información sobre regiones y vendedores activos en estas regiones. Relacionado con esta tabla también es una tabla de ventas. Con SUMMARIZECOLUMNS ahora quiero crear una tabla que devuelva el vendedor superior por unidades para cada región. Lo que he intentado hasta ahora es esto: Top Sellers= SUMMARIZECOLUMNS('Customers'[Region],'Customers'[Salesperson],"Unit Sales",[Sum of UnitQTY]) Esto produce una tabla como: Región Vendedor Ventas unitarias A Adán 5000 A víspera 200 B Steve 4000 B víspera 8000 C Adán 5 C Steve 100 C víspera 50 Sin embargo, mi resultado deseado sería este: Región Vendedor Ventas unitarias A Adán 5000 B víspera 8000 C Steve 100 ¿Cómo puedo lograr esto usando SUMMARIZECOLUMNS o una función aquivalente que producirá una nueva tabla?Solved309Views0likes1CommentSUMMARIZECOLUMNS - Only the top value for multiple groupings
I have a table that contains information about regions and sellers active in these regions. Related to this table is also a table of sales. With SUMMARIZECOLUMNS I now want to create a table that returns the top salesperson by units for each region. What I have tried so far is this: Top Sellers= SUMMARIZECOLUMNS('Customers'[Region],'Customers'[Salesperson],"Unit Sales",[Sum of UnitQTY]) This produces a table such as: Region Seller Unit Sales A Adam 5000 A Eve 200 B Steve 4000 B Eve 8000 C Adam 5 C Steve 100 C Eve 50 However my desired result would be this: Region Seller Unit Sales A Adam 5000 B Eve 8000 C Steve 100 How can I achieve this using SUMMARIZECOLUMNS or an aquivalent function that will produce a new table?Solved1.9KViews0likes1CommentCan I save costs with Power BI Premium?
I am working with an organisation that has around 150 PBI Pro licenses in use. The vast majority of those are actually only used for people who consume reports only. I am now looking to find a way to save the organisation some costs and I am exploring the capabilities of Power BI Premium in this regard. The P1 node is out of the question but recently I saw that there are various other nodes available like A or EM SKUs. Currently the organisation has a clear set of reports delivered via app.powerbi.com to users, namely through an app in a workspace. The company presently also uses both Teams and Sharepoint. For my understanding: a) To be able to provide reports to users via Power BI premium, I would need at least an EM1 SKU since this allows for embedding in Teams or Sharepoint? Furthermore, the reports rely heavily on RLS, which leads me to my second question: b) Is it possible to use RLS together with an EM1 SKU for users that do not have a Pro license? If not, are there alternatives? Finally, the company has some scenarios where they are currently using PowerApps and embedding Power BI in model-driven Power Apps. Final question: c) Would I be able to integrate EM1 SKUs in model-driven PowerApps just as I am currently doing with Power BI Pro?714Views0likes1CommentGetting selected element in a Power BI report from API
I am looking to get what item has been selected in Power BI and to send that information to a program outside of Power BI. Previously, I have done this in connection with PowerApps. Using PowerBIIntegration.Data, I was able to get information based on a visual selection in Power BI - such as which customer had been selected in a list. We have now decided to replace PowerApps with custom developed third party software for our particular use case. So now, instead of being able to select a customer in Power BI and have PowerApps be automatically pre-populated with information from this customer I need a way so I can still select a customer in Power BI but get the information to a different destination. I have researched the REST API PBI offers but I was unsuccesful.Solved2.8KViews0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.