Forum Discussion
PowerBI Gateway Release notes
Hi All,
Does any one has a link to release notes for the latest version of PowerBI Gateway server?
In addition, is there a separate forum to discuss about PowerBI gateway server issues?
Thanks,
John
9 Replies
Hi johnpjustus
Here is the latest update
On-premises data gateway September 2023 release | Microsoft Power BI Blog | Microsoft Power BI
you can also subscribe
No there is no separate forum for Power BI Gateway.
Latest version is 202.16 and the release notes are nowhere to be seen. It worked resonably well for a while (although the release notes were mostly devoid of actual information) but now it's back to what we had last year, deafening silence and frequent bug fixes.
Incidentally just today I built myself a Power Automate flow to keep track of the gateway versions being released on the sly.
There's also this Currently supported monthly updates to the on-premises data gateways | Microsoft Learn
but it is incomplete and partially inconsistent.
Interesting, looks like the power automate flow will be helpful to keep track of the versions.
I will build one and see. Whenever microsoft releases new version, I expect release notes attached to the installation file.
Feel free to expect that 🙂 Not sure if it is going to happen any time soon though. You can mention it to your Microsoft contacts so they can bring it up with the product team.
Hey lbendlin - are you able to share this flow? This is pretty cool!
{ "name": "d1ce5648-76a3-4f06-a768-d65abfda7b91", "id": "/providers/Microsoft.Flow/flows/d1ce5648-76a3-4f06-a768-d65abfda7b91", "type": "Microsoft.Flow/flows", "properties": { "apiId": "/providers/Microsoft.PowerApps/apis/shared_logicflows", "displayName": "Check Power BI Gateway version", "definition": { "metadata": { "workflowEntityId": null, "processAdvisorMetadata": null, "flowChargedByPaygo": null, "flowclientsuspensionreason": "None", "flowclientsuspensiontime": null, "flowclientsuspensionreasondetails": null, "creator": { "id": "xxx", "type": "User", "tenantId": "xxx" }, "provisioningMethod": "FromDefinition", "failureAlertSubscription": true, "clientLastModifiedTime": "2024-01-19T02:48:16.3688018Z", "connectionKeySavedTimeKey": "2024-01-19T02:48:16.3688018Z" }, "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#", "contentVersion": "1.0.0.0", "parameters": { "$authentication": { "defaultValue": {}, "type": "SecureObject" }, "$connections": { "defaultValue": {}, "type": "Object" } }, "triggers": { "Recurrence": { "recurrence": { "frequency": "Day", "interval": 1, "startTime": "2022-03-09T15:00:00.000Z", "schedule": { "hours": [ "15", "3", "9" ] } }, "metadata": { "operationMetadataId": "d4e7aea5-e8bf-4b8e-a5de-ce6844c23150" }, "type": "Recurrence" } }, "actions": { "HTTP": { "runAfter": {}, "metadata": { "operationMetadataId": "6e944f3c-cf84-46c3-8af7-39ad496a100c" }, "type": "Http", "inputs": { "uri": "https://www.microsoft.com/en-us/download/details.aspx?id=53127", "method": "GET", "headers": { "Cache-Control": "no-cache" } }, "operationOptions": "DisableAsyncPattern, DisableAutomaticDecompression" }, "Initialize_variable": { "runAfter": { "HTTP": [ "Succeeded", "Failed" ] }, "metadata": { "operationMetadataId": "93c083e0-f727-40b7-ab60-d9e36abbaef5" }, "type": "InitializeVariable", "inputs": { "variables": [ { "name": "HTML", "type": "array", "value": "@json(split(split(body('HTTP'),'downloadFile\":')[1],'\"localeDropdown\":')[0])" } ] } }, "Get_items": { "runAfter": { "Initialize_variable": [ "Succeeded" ] }, "metadata": { "operationMetadataId": "66e39958-be43-4764-8a3f-b2066a190583" }, "type": "OpenApiConnection", "inputs": { "parameters": { "dataset": "https://xxx.sharepoint.com/teams/PowerBI", "table": "351df56a-1cda-43aa-b0f4-10a95bda5d51", "$orderby": "Published desc", "$top": 1 }, "host": { "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline", "connectionName": "shared_sharepointonline", "operationId": "GetItems" }, "authentication": "@parameters('$authentication')" } }, "Apply_to_each": { "foreach": "@outputs('Get_items')?['body/value']", "actions": { "Condition": { "actions": {}, "else": { "actions": { "Create_item": { "metadata": { "operationMetadataId": "ecbb136b-e06e-41e1-8660-43831d33ae91" }, "type": "OpenApiConnection", "inputs": { "parameters": { "dataset": "https://xxx.sharepoint.com/teams/PowerBI", "table": "351df56a-1cda-43aa-b0f4-10a95bda5d51", "item/Title": "@{variables('HTML')[0]['version']}", "item/URL": "@{variables('HTML')[0]['url']}", "item/Size": "@variables('HTML')[0]['size']", "item/Published": "@{variables('HTML')[0]['datePublished']}" }, "host": { "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline", "connectionName": "shared_sharepointonline", "operationId": "PostItem" }, "authentication": "@parameters('$authentication')" } }, "Send_an_email_(V2)": { "runAfter": { "Create_item": [ "Succeeded" ] }, "type": "OpenApiConnection", "inputs": { "parameters": { "emailMessage/To": "[email protected]", "emailMessage/Subject": "New Gateway version detected", "emailMessage/Body": "<p><span style=\"white-space: pre-wrap;\">Version </span>@{variables('HTML')[0]['version']}<span style=\"white-space: pre-wrap;\"> has been released at </span></p><p><span style=\"white-space: pre-wrap;\">https://www.microsoft.com/en-us/download/details.aspx?id=53127</span></p>", "emailMessage/Importance": "Normal" }, "host": { "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365", "connectionName": "shared_office365", "operationId": "SendEmailV2" }, "authentication": "@parameters('$authentication')" } } } }, "expression": { "and": [ { "equals": [ "@variables('HTML')[0]['version']", "@items('Apply_to_each')?['Title']" ] } ] }, "metadata": { "operationMetadataId": "ce778fae-e07d-419c-95b1-07b628856e4e" }, "type": "If" } }, "runAfter": { "Get_items": [ "Succeeded" ] }, "metadata": { "operationMetadataId": "b0aafb66-a9c0-40ab-88de-ef5774c247e5" }, "type": "Foreach" } } }, "connectionReferences": { "shared_sharepointonline": { "connectionName": "shared-sharepointonl-a17f8a06-6fbd-47de-8b5b-bfcb9d9e8715", "source": "Embedded", "id": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline", "tier": "NotSpecified" }, "shared_office365": { "connectionName": "shared-office365-9eeab932-f7b5-49af-928e-edff54ece18d", "source": "Embedded", "id": "/providers/Microsoft.PowerApps/apis/shared_office365", "tier": "NotSpecified" } }, "flowFailureAlertSubscribed": false, "isManaged": false } }
