We are running out of memory when using the aggregation function on the data query editor. It has been working for the last 6 months with no issue.
From the refresh
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Yesterday, all my datasets were refreshing just fine but today nothing happens.
- The automatic refresh hasn't done anything.
- When I press "Refresh now", I get a "popup" saying "preparing refresh" for a split second and then nothing happens.
The only way to update the data is to refresh the Desktop version and then upload it.
I have datasets connection to an on-premises database and one connecting to a sharepoint site.
- The on-premises connection usually works perfect, but now nothing happens.
- The sharepoint connection usually brings up an error, if I try to refresh, but now nothing happens (I just tried it this time as a test, as it usually doesn't work automatically).
Can you please help troublefinding - It seems like an issue on you online portal somehow.
Thanks in advance.
Our report - which is based on MY SQL Queries - seems to experience difficulties regarding the scheduled refresh. This is the error that we got back:
If anyone can offer any advice or provide further information that would be highly appreciated
I have two accounts, one paid pro, the other a trial pro account. Come June 1st and my gateway is offline and not able to reconnect ot the service?
Here is the message I get in my gateway: "Please wait while the gateway connects to the serivce"
I'm getting this error since yesterday on a new dataset. It is a simple excel file table. I've done the following.
Signed out of Power BI Desktop and back in
Got the latest personal gateway
turned the gateway service off / on
republished multiple times during this process.
Others seem to be having the same issue. see thread here
There is a current support site error message, but it is specific to SharePoint as a data source only.
I'm having trouble loading my report measures when using DirectQuery for SAP BW on Power BI cloud service.
Here is the error message:
"Couldn't load the data for this visual
Please try again later or contact support. If you contact support, please provide these details.
- I'm loading dimensions and measures (key figures) from Bex Query perfectly well in Power BI Desktop;
- The issue happens only with Measures on the Power Bi Service after publishing the report;
- Dimensions and Hierarchies are loading seamlessly on Power BI service;
- The Data Gateway is up and running;
- I've tried to convert the measures into currency format but to no avail;
- "Send a Frown (Error)" is not available in the error message window to report the technical issue;
Has anyone run into the same problem using DirectQuery (beta) and Data Gateway connecting to a Bex Query? (SAP BW)
Since yesterday I'm having an issue connecting to an excel file in a Sharepoint folder. It was already working, but I made some changes and republished it. Refresh works fine in Power BI Desktop, but online. It seem it's trying to connect to a Sharepoint list, instead of folder. I have an other report connecting to an other excel file in the same folder and it works fine. Could this be connected to the issue in North Europe? I'm in that datacenter.
The gateways seem to disconnect from the cloud account , trying to re insert them gives an error
"personal gateway sign in error: an unknown state error occurred Initial Response"
Could someone please advise ? ?
This morning, when I started Power BI Gateway - Personal, it failed with the error, "GWConf has stopped working A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available." I uninstalled and re-installed the application but am still getting the same error. The Personal gateway as worked flawlessly for weeks prior to today. I'm not aware of any changes being made to my PC but I'm using a company computer and sometimes our IT department pushes out updates without prior notification. Where do I begin looking for the cause of the failure? (I'm just a Power BI user, not a developer.)
After upgrading the Personal gateway to the june version blank date fields gets imported as 1899 dates rendering my reports broken (since I filter on e.g deleted_at = blank).
Swithced back to older version (Apr release) returns import to normal behaviour.
This is an on premises scheduled refresh from an AWS RDS ProstgreSQL DB.
Any idea on how to correct this?
I've published a report from my work account.
Under Dataset Settings it shows Datagateway error and shows:
This data set has been configured by *firstname.lastname@example.org .
I've tripple checked my credential, sign-out and in ...
I see my WORK environment, but it somehow connects the Dataset to gmail....
And doesn't allow me to set up Enterprise Gatway for Dataset or Refresh
I know others are experiencing same issue here:
Starting at around 4:00 AM CST on 4/21/2017 the automated PBI refreshes from Azure Analysis Services has stopped working. I had to manually refresh all of my reports data sources at 7:20AM CST.
My cube processes every hour, and the PBI datasets are scheduled to automatically refresh every 15 minutes refresh. I have already waited over an hour for the automated refresh to occur, and it has not yet happened.
Please see screenshot below.
Here are the details from "About Power BI"
TimeFri Apr 21 2017 08:39:55 GMT-0500 (Central Daylight Time)
Your data is stored inNorth Central US (Illinois)
Our organization as of today is receving a generic error "Oops, something went wrong" on all of our scheduled jobs. When we refresh powerbi solutions through the enterprise data gateway manually (clicking each dataset and telling them to refresh) they run fine. But when they run via the schedule on the web service, we get this error. Example of the technical info is below. Anyone have any ideas why this is occuring?
Activity Id: (removed)
Request Id: (removed)
Cluster Name: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Refresh Start Time: 05/30/2017 14:01:25Z
Refresh End Time: 05/30/2017 14:02:07Z
Unable to sign in from Power BI Desktop and Enterprise Gateway after implementing Conditional AccessStatus: Investigating
We have a production implementation of Power BI for which we turned on device based Conditional Access (CA), and added relevant AD groups. After turning on CA, users in the device based AD group are unable to sign in from Power BI desktop and also cannot sign in upon installation of a new Enterprise Gateway.
We get the following message: Unable to sign in. Sorry we encountered an error while trying to sign you in. Details: AADSTS50000. Device platform Unknown used by the user is an unsupported device platform. Supported device platforms are iOS, Android, and Windows flavors.
We are on a Windows platform and tested from Windows 8 and Windows 7 machines, and encountered the same error on both. This issue applies to October 2016 and September 2016 versions of desktop. To prove that CA triggered this issue, we used a test user not in the device based AD group. The test user was able to sign in successfully.
This issue is critical as it prevents us from being able to publish directly from Power BI desktop and prevents users from installing a new Enterprise Gateway.
Please let me know if you need any additional information. If you need Trace ID, Correlation ID or Timestamp, I can provide it via email.
Power BI Desktop seems to be signing me out of my Power BI account. When I go to publish a report while not signed in it asks me for my credentials, but doesn't allow me to type anything in. I have to open Task Manager and Force Close Power BI, reopen, Sign In, then publish.
I have published one report to my own workspace and to shared workspace. I get update schedule working in my own workspace but in shared workspace I cannot set up credentials because of the following error:
Is there anything that I'm doing incorrect or what is this sorcery?
Still unable to refresh on Power BI Service (Online), where we have a numbe of reports that employees rely on for daily data.
Do we have an idea when this is going to be fixed? I am a user in the UK
We are uploading .pbix files to OneDrive for Business and connecting to them through PowerBI web.
The .pbix files use custom-build OData-feeds (with HTTP Basic-Auth) as data-sources. We've been succesfully utilizing these OData-Feeds for about a year now.
However, since about 2 weeks ago, all scheduled refreshes started failing due to authentication errors. Here's an example:
Last refresh failed: Wed Dec 21 2016 16:23:53 GMT+0100 (W. Europe Standard Time)
There was an error when processing the data in the dataset.
|Data source type:|
|Processing error:||The credentials provided for the OData source are invalid. (Source at https://<<confidential>>)|
When looking at the server-logs, I can confirm that PowerBI sends the wrong credentials in the "Authorization" HTTP-header.
I'm unable to determine the exact nature of the authentication payload, but it looks like a OneDrive authentication-flow.
Furthermore, PowerBI consistantly sends invalid credentials for a certain type of feed and always on the request after the pagination of the feed has been exhausted, therefore making it quite clear that this is a bug.
If the support for PowerBI Web gets in touch, I can provide exact steps to reproduce the Issue, including the offending sources, credentials and server logs.