I am trying to use Microsoft Fabric (Trial Lisence) Dataflow Gen2 to Get Data (a webscrape) but it either gives me a Catastrophic Error Failure or it complains that WebView2 is not installed even when it is. I have done this both via my local PC using Edge and an Azure VM to rule out it is not a local setting. I have done repairs to both WebView2 and Edge but nothing seems to work. I would like to see if others are getting the same issue as me? (Sidenote - I can do the below in Power BI desktop no issues so it is not the query or the site) 1. Log into https://app.fabric.microsoft.com go to the (Synapse) Data Engineering experience and create a Lakehouse (preview). Go into that Lakehouse and choose New Dataflow Gen2 (preview):  2.  Choose Get data > Blank query - replace the query text with the following code choose a gateway and hit Next: let     Source = Web.BrowserContents("https://www.parkrun.co.za/delta/results/latestresults/"),     #"Extracted Table From Html" = Html.Table(Source, {{"POSITION", ".Results-table-td\-\-position"}, {"PARKRUNNER", ".Results-table-td\-\-name > .compact"}, {"RUNNERDETAILURL", "[target=""_top""]", each [Attributes][href]?}}, [RowSelector=".Results-table-row"]),     #"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"POSITION", Int64.Type}, {"PARKRUNNER", type text}, {"RUNNERDETAILURL", type text}}),     #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [PARKRUNNER] <> "Unknown"),     #"Kept First Rows" = Table.FirstN(#"Filtered Rows",5) in     #"Kept First Rows" 3. It will pop up an alert "We could not evaluate this query due to invalid or missing credentials." Click on Configure Connection  4. Because it is public www and the Authentication kind defaults to Anonymous you can simply hit Connect:  5a. Error: "We encountered an error when initializing the web browser. Details Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) 5b. Other times it has shown me error message:  We were unable to find the WebView2 runtime. You can manually download the runtime installer here: https://go.microsoft.com/fwlink/p/?LinkId=2124703 When I go to the link and try install Webview2 it tells me that it is already installed.    All of this is very frustrating and means I cannot achieve what I need to using Fabric until this issue is fixed.     6. Show details: (text below):  ---------- Message ---------- We encountered an error when initializing the web browser. ---------- Session ID ---------- 339fd36e-bb5c-4ae2-900c-619c84e5dbd4 ---------- Request ID ---------- 82e828a5-f96d-493a-bbd9-2d2cbac390c4 ---------- Mashup script ---------- [DefaultOutputDestination = "DefaultDestination"] section Section1; shared DefaultDestination = Lakehouse.Contents(null){[workspaceId = "8401d000-b3c6-40e7-8ebf-b86c192e047b"]}[Data]{[lakehouseId = "be7ddef0-ae31-4ef5-9062-5543ad6fac70"]}[Data]; [BindToDefaultOutputDestination = true] shared Query = let Source = Web.BrowserContents(" https://www.parkrun.co.za/delta/results/latestresults/"), #"Extracted Table From Html" = Html.Table(Source, {{"POSITION", ".Results-table-td\-\-position"}, {"PARKRUNNER", ".Results-table-td\-\-name > .compact"}, {"RUNNERDETAILURL", "[target=""_top""]", each [Attributes][href]?}}, [RowSelector=".Results-table-row"]), #"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"POSITION", Int64.Type}, {"PARKRUNNER", type text}, {"RUNNERDETAILURL", type text}}), #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [PARKRUNNER] <> "Unknown"), #"Kept First Rows" = Table.FirstN(#"Filtered Rows",5) in #"Kept First Rows";  ... View more

I'm having a problem with a dataflow that seems to reoccur every morning after functioning correctly the previous afternoon. In the refresh history log it gives the following error:   Error: Encountered user gateway exception: '<ccon>The credentials provided for the PowerBI source are invalid. (Source at PowerBI.)</ccon> [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingErrorMessage]=<ccon>The credentials provided for the PowerBI source are invalid. (Source at PowerBI.)</ccon> [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.CredentialError.DataSourceKind]=PowerBI [Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind]=Web [Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath]=https://api.powerbi.com/powerbi/globalservice/v201606/clusterdetails [Microsoft.Data.Mashup.CredentialError.DataSourcePath]=PowerBI [Microsoft.Data.Mashup.CredentialError.Reason]=AccessForbidden [Microsoft.Data.Mashup.MashupSecurityException.DataSources]=[{"kind":"PowerBI" "path":"PowerBI"}] [Microsoft.Data.Mashup.MashupSecurityException.Reason]=AccessForbidden [InnerType]=MashupCredentialException The credentials provided for the PowerBI source are invalid. (Source at PowerBI.) [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_InvalidConnectionCredentials [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=830927]/MashupDataAccessCredentialException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupCredentialException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=830927]'. RootActivityId = b7685438-32e7-4086-a129-0e9d5ec4ac91.Param1 = <ccon>The credentials provided for the PowerBI source are invalid. (Source at PowerBI.)</ccon> [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingErrorMessage]=<ccon>The credentials provided for the PowerBI source are invalid. (Source at PowerBI.)</ccon> [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.CredentialError.DataSourceKind]=PowerBI [Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind]=Web [Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath]=https://api.powerbi.com/powerbi/globalservice/v201606/clusterdetails [Microsoft.Data.Mashup.CredentialError.DataSourcePath]=PowerBI [Microsoft.Data.Mashup.CredentialError.Reason]=AccessForbidden [Microsoft.Data.Mashup.MashupSecurityException.DataSources]=[{"kind":"PowerBI" "path":"PowerBI"}] [Microsoft.Data.Mashup.MashupSecurityException.Reason]=AccessForbidden [InnerType]=MashupCredentialException The credentials provided for the PowerBI source are invalid. (Source at PowerBI.) [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_InvalidConnectionCredentials [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=830927]/MashupDataAccessCredentialException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupCredentialException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=830927] Request ID: ad7bb2b3-f898-43f7-9788-7fab4416aa79.   I've checked all connections in 'Manage connections and gateways' and reauthenticated everything. I've also checked the dataset for this dataflow to make sure it is all set up correctly. It's becoming really frustrating as it seems to break overnight every day and I have to spend time every day trying different things to get it to work. ... View more

Since yesterday, we experience a caching problem with some of our customers. The first opened report works without any issues while the next reports give the underneath error.   The data set is created in SSAS cubes and we use the on premise data gateway to connect.   Anyone else experiencing this? Did Microsoft do an update?     ... View more

Our dataflows have jumped from 5 minutes to sometimes timing out at 3 hour limit. The gateways involved have all been updated to the latest version, and one dataflow doesn't even connect through a gateway because all sources are web.   Around the same time this started happening, publishing reports with exisiting datasets have started taking forever (30+ mins).  Twice now I've received a 500 error while trying to publish. Previously they took under 30s (8mb report), and if I delete the existing report and dataset pubishing speed is restored to this.   Even navigating PowerBI.com through the workspace settings has gotten slow and unreliable. Just now I got an error with a picture of an owl and the following message:   TECHNICAL DETAILS Power BI was unable to read the application metadata. Please check the Power BI service status in the below support page and try again later. Date and Time: 2020-10-14 18:54:41Z ActivityId: e13c3676-e36c-4be5-9fb5-0a1ebf8ec6ca   Any help would be greatly appreciated! ... View more

Yesterday my security was working.  But it stopped working once the December Power BI desktop update was pushed out.  I can no longer click on the Apply security filter in both directions checkbox any more.  I opened the pbix on a different system running the November release with and can click the checkbox with no issues.         ... View more

I'm having the problem below, I've put the credentials again, but the error continues.   ... View more

Currently running into some difficulties editing dataflows within the PBI Service that connect to SAP BW: Partitioning the data pull due to SAP BW memory issues  Able to set it all up within PBI Desktop and refresh it manually, however unioning the data can sometimes fail due to memory issues Moved all of the above to be dataflows Able to create the dataflow initially and refresh it via PBI Gateway - seems to work so far Started to receive an error when pulling this data into PBI desktop around "there were more columns in the result than expected" - unsure why so following advice from a different post: https://community.powerbi.com/t5/Service/DataFlow-Refresh-Error-and-Fix-for-added-Fields-in-Dynamics-365/m-p/615147   However, I've found that I am unable to edit the entities within the dataflow due to the following error and unclear why (especially since I am able to create the dataflow and refresh in the first place):   DataSource.MissingClientLibrary: This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'SAP .NET Connector 3.0.0.42': https://go.microsoft.com/fwlink/?linkid=872300 Details ClientLibraryName = SAP .NET Connector 3.0.0.42 DownloadLink = https://go.microsoft.com/fwlink/?linkid=872300   Should also point out, the dataflow still appears to refresh.   ... View more

We are experiencing long response times for reports hosted on power BI platform. Paginated reports are rendered in run over 15s. The same report, when run from PowerBI Report Builder executed on PowerBIGateway machine, is rendered below 2s. We checked network performance.Tracert times are below 50ms between Azure Power BI cloud (app.powerbi.com) and our Power BI Gateways installed on our on-premise environment. ... View more

Hello, Im unable to refresh one of my reports, the gateway is ok, and in power BI destkop refreshes properly. can you help me out, I get this message: Last refresh failed: Thu Jan 11 2018 16:29:15 GMT+0100 (Romance Standard Time)  Cancellation occurred when sending or receiving a request Cluster URI: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net Activity ID: c21669ce-c606-4dc0-93d6-66fc6578519d Request ID: 3a01ab7b-abe3-e1d6-dbf1-2fc09cde3c1c Time: 2018-01-11 15:29:15Z   ... View more

Receiving an error message of Failed to take over dataset. Please try again later.   This error is not occuring with all datasets even in the same workspace, only a select few. The owner has the same permission level as me and we have not had this issue in the past. Has anyone else had this issue?       ... View more

Datasets that include a query that merges data coming from a web data source on one side and another set of data coming from an on-Premises data source can't be refreshed using the On-Premises data gateway. Error messages depend on the kind of the web data source. For example: Sharepoint Online List: "The credentials provided for the SharePoint source are invalid" Excel in Sharepoint Online (Web Connector): "SharePoint: Request failed: https://[...]" I tried to merge data from On-Prem Oracle with SPO List from On-Prem Excel with SPO List from On-Prem Excel with Excel in Sharepoint Online (Web Connector) Every attempt failed. Tested with On-Prem Data Gateway 12-2018. I followed this documentation. According to this announcement this should work.   However, refreshes succeed when I access the identical data sources with reports that do NOT merge the data in a query:   ... View more

I'm trying the new Datamart functionality, by rebuilding some of my dataflows/datasets.  Allthough I'm able to fetch data from an on premise SQL database via the gateway in Dataflows, the exact same thing in Datamarts failes. It recognize the source, and fills my the stored credentials, but on connect it trows an error. No permission/access to the gateway.   ... View more

I have been working on a series of ETL dataflows in a PPU workspace. The source is a cloud SQL server concted through an on premises gateway. Until yesterday I did not have any issues with computed entities; today I tried to edit one and got the error "Computed tables require Premium to refresh. To enable refresh, upgrade this workspace to Premium capacity, or remove this table." I asked for the gateway server to be rebooted and this did not resolve the issue. I created a new PPU workspace, added a new dataflow sourced to the same gateway connection with 2 tables, saved, refreshed, then tried to merge and get the same error; I tried with an onsite SQL server connected through the gateway, and get the same error. I tried connecting to the onsite SQL server without the gateway (Create new connection) and got an "Unexpected error (Session ID: 30ed5e9f-2b87-4954-a402-f69d5e203921, Region: us)". In the meantime, the original dataflows that have scheduled refreshes that include computed entities are working fine. I checked with IT and our only change control since that time was network resiliency / failover testing.  ... View more

I am trying to set up a Data Mart in Power BI for our database. I keep getting the following error while trying to connect: An exception occurred: An error occurred while communicating with another service, please try again later. If this problem recurs, please contact support with this message. (Request ID: 1d27d4f1-9ef4-4404-a4d6-aad2428161e1) (Session ID: ce9ad571-3f42-4299-bc80-71b548a5a4dd, Region: us) ... View more

With the debut of the new UX there seems to be some problem with the "Manage Connections and Gateways" experience's interaction with the users component. When you I view the Connections tab, the entire "Users" column is blank. When I go into "Manage Users" for a particular connection, the users list stays stuck on "Loading" and searching for known users returns no results, even if you provide the full user email address. This is true despite a fresh browser session in Edge or testing with an InPrivate window. Interestingly this is a problem only for the Gateways management UX, it's not a problem for Workspace Access for example.         This kind of issue seems to have happened before and the workaround was going to the old UX. It worked for me in a pinch today but hopefully this issue will be resolved quickly. Cannot access Manage users setting in Gateway - Microsoft Fabric Community   ... View more

I am not able to login in to power BI Desktop app after Nov 2020 update installed but i can able to sign in into Oct 2020  setup file afte installed   Please help ... View more

This has seemed to just start this morning, anyone else experiencing this in the Po BI admin section >Manage Gateways   ... View more

I'm currently trying to schedule a refresh for a Power BI report which uses python to transform the loaded data.   I can get the python script to run on my local machine in powerbi desktop, but when I publish it and attempt to schedule the refresh, I get an error concerning invalid credentials (Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.). The other data sources connect fine through the personal gateway. When I click on 'Edit Credentials' for Python, I get the following specifics:       Failed to update data source credentials: ADO.NET: Python script error. Traceback (most recent call last): File "PythonScriptWrapper.PY", line 2, in <module> import os, pandas, matplotlib File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\__init__.py", line 19, in <module> "Missing required dependencies {0}".format(missing_dependencies)) ImportError: Missing required dependencies ['numpy']       Activity ID: 177ce143-63b1-422a-8852-ca1bef96a846 Request ID: 9f20ee17-91cb-ab92-75d9-7688929f6157 Status code: 400 Time: Fri Feb 28 2020 11:07:32 GMT+0000 (Greenwich Mean Time) Service version: 13.0.12439.190 Client version: 2002.3.018 Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/         I can't see any way to select the python installation to run the script with, but all of my local environments should be able to run the script (notably, they all have numpy installed)   Thanks in advance for your help. George Kinnell (Altius) ... View more