dataflow
13 TopicsNo se activan las alertas en power BI service
Buen día Tengo 4 alertas en power bi service y estas alertas van a un flujo de power automate que envía un correo cuando el valor es negativo, el primer día el valor de -11% envía el correo, pero al día siguiente actualiza el informe en power bi , la targeta se actualiza pero no se desencadeno la alerta lo que causa que no enviara el correo desde power automate, revise el flujo y todo esta bien, el problema biene que power bi service no desencadena la alerta, debo entrar y hacer un cambio manualmente en la alrta y darle guardar para que esta se active y power autome envie el correo, pero no puedo hacer esto ya que la idea es que el proceso sea automatico, tengo un par de alrtas mas y ninguna se activa apesar que se cumplen los requerisitos (el dato si cambia y si cumple la condicion de mayor o menor a 0 que le pongo), algien me puede ayudar a como hacer que se active la arlta si que yo deba entrar manualmente y mover algo hasta que esta se active, No agregado pantallazo de power automate porque alli no reside el problema, el problema es en que poweeri bi no activa la alerta, estoy en fase de pruebas para implementar al menos 40 alertas para diferentes equoipos y paises pero si no se envia las 4 de prueba menos las 40 que tenemos pensadas agregarSolved992Views0likes1CommentCan't create a Dataflow gen2
Hi, I am trying to create a dataflow gen2 in Power Bi, however when I select the alternative I get the message: "Unable to create this item To create a Dataflow Gen2, you need a free Microsoft Fabric trial capacity. " I have microsoft fabric so how is this possible that I can not create the dataflow? I can't create a free trial. What licence do I need to create the dataflow?Solved2.8KViews0likes1CommentAzure Analysis Services Connection to Dataflow or Datamart
Hi, So for some reason I cant connect to Analysis Services when I'm connecting via dataflow or datamart. As of now when I'm in the company building I can connect via "Power BI Desktop" to the Analysis Services. Also I published report and use a gateway the team setup for me. The issue I have is I want to create bunch of Dataflow so I can massage the data so user outside the building can still use the data. Specially working from home. Here are the steps I'm doing let me know if im missing anything or I need to talk to our IT team for a privilage setup or something. So I go to the Workspace > New > Dataflow Then I select Then input the credentials When i click next i get this error : What does this mean? I google the error but I dont get any luck finding a solution. Thanks Chris1.6KViews0likes3CommentsHow to get M query from dataflows. Power BI Server Analysis Services DMV request
The target is to get all M codes from Power BI Service. dataflows take a big part in the Power BI data structure. I tried codes that work for datasets, but they apparently do not work for dataflow: SELECT * FROM $SYSTEM.TMSCHEMA_PARTITIONS and SELECT * FROM $SYSTEM.TMSCHEMA_EXPRESSIONS In The Power BI Workspace opened with Analysis services there is an entity named "Dataflows" with all the dataflow inside. I try running the same codes for this entity as for datasets, but the results are weird. Some codes show reference to a table itself, and 90% of tables are missing. Is there a way to get M Query for all tables inside dataflow (loaded and not loaded) using DMV queries? d_gosbell , lbendlin could you help with this issue?Solved2.4KViews0likes1CommentOn-premises gateway, setting DbConnectionPoolMaxSize against Oracle
Hi, the on-premises gateway does take quite a lot of simultaneous database connections against our Oracle database when we refresh a dataflow residing in the Power BI Service or in the PowerApps/Power platform. It looks like it consumes about the same amount as the number of tables in the dataflow. Is there any way to limit this? I have tried to set DbConnectionPoolMaxSize=4 (the default was 256 i believe) in the following file on the gateway server C:\Program Files\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config in sections <setting name="DbConnectionPoolMinSize" serializeAs="String"> <value>4</value> </setting> <setting name="DbConnectionPoolMaxSize" serializeAs="String"> <value>4</value> </setting> <setting name="DbConnectionStatefulPoolMaxSize" serializeAs="String"> <value>4</value> </setting> But the gateway still consumes 9 connections simultaneously. If we start several refreshes against Oracle at the same time, we may easily end up starving our main business critical application for database connections. Anyone who has more knowledge about this? -Is it possible to set the DbConnectionPoolMaxSize? -Is there a minimum value not possible to go under? -Is this the right place or the right setting? EirikSolved2.6KViews2likes4CommentsDataflow used On-Premise - Can't schedule refreshes
We have a dataflow feeding an app to be used on-premise. It refreshes fine in desktop. But once it's uploaded to the on-site server, scheduled refresh isn't available. Here is the message: Scheduled Data Refresh is not available for reports. The report does not have any external data connections defined or is using an unsupported data source. Note: The ability to define the datasource is 'grayed out' / disabled. Can dataflows not be scheduled to refresh in on-premise applications?Solved3.2KViews0likes8CommentsReplace custom SQL datasource with dataflow
l have apublished report that uses a custom SQL as its datasource. I created a dataflow using the M-code version of that SQL. It is published, refreshes, etc with no issues. Now I want to take a few existing reports that use this SQL as the main datasource, and convert them to use the dataflow I have created. I have searched these forums and elsewhere but am unable to find a solution to this particular question. I was able to make a new datasource in the report using the dataflow. But this report has many VIZ (30+) and I don't want to recreate them all using the new dataflow datasource. Is there a way to either (1) modify the SQL datasource by replacing the custom SQL with the new dataflow, or tell Power BI to use the dataflow instead of the SQL datasource (I would then delete the SQL from the datasource list)? Thanks in advance for any help this community can provide2.4KViews2likes3Commentsscheduled refresh in Report Server not working for a report using only Dataflow??
Hi, I've created a report only connected to dataflows, and published it on our Report Server. But when I try to set up a scheduled refresh on this report server, it doesn't work (see screenshot). I've looked at the doc, but it doesn't seem that dataflow is on the exception list of authorised sources for scheduled refresh in Report Server... Does anyone have a clue if yes or no, it can work? Thx! Ben686Views0likes2CommentsCreate and use dataflow with Report Servre
Hello everyone, My client hasn't purchased Power BI Service, he's running Report Server (May 2019). I need to create a dataflow, but as far as I' looking this is just possible with PBI Service, also my client doesn't want his data to be stored on the cloud. What solution(s) do(es) I have ?Solved3.4KViews0likes2Comments