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 *email@example.com .
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:
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.)
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.
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.
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.
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.
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
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.
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.
Hello Power BI community,
I recently created a desktop file and with "Web" as the only data source. Everything was working great. After a week, the refresh failed. It appears Power BI thinks I am trying to use an on premise data source and as far as I know the "Web" feed can be refreshed without a gateway. (Like I said, it was working wonderfully for a week.) Could anyone offer some suggestions? I have tried renaming, republishing, deleteing... I have made a new .pbix and published it from scratch with the same result. Any help is much appreciated!
I think there may be a fundamental problem with the enteprise gateway. I have setup a brand new gateway and tried to create a datasource for the following URL's
I can only create a datasource for one of these, not both. When I try to do both I get a duplicate data source error. It looks like the enterprise gateway is stripping off the query string when checking for duplicates.
Unfortunately, this is a fairly serious limitation as when using Reporting Services (and most likely other web applications) much of the unique information is contained in the query string.
This has not been a problem in the past so looks like something that has recently been introduced.
I want to publish a report created in PowerBI Desktop with a datasource pointing to a Sharepoint Online List.
I'm using the same credentials for Sharepoint Online (administrator) and PowerBI.
In PowerBI Desktop I am able to refresh.
I publish the file to PowerBI Online.
When I check the credentials of the DataSet created in PBI Online I see this message:
Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.Your data source can't be queried because the credentials are not provided. Please provide your credentials and try again.Hide details
I try to reenter credentials but the Authentication method is limited to Anonymous, Windows or Undefined. Choosing Undefined will result in the spinning wheel rolling endlessly.
How can I preserve the credentials from PowerBI Desktop to be able to use them in PBI Online?
I installed Power BI Gateway in order to use SQL directly in my Dashboard. I published the report and found that none of my colleagues could view it without a Pro License. I tried everything but can't get rid of the so called "power BI pro content" in my dashboard.
So I uninstalled the gateway software and reinstalled Power BI.
I tested by creating a very basic report with one line chart linking to excel. Even this report can't be viewed by my colleagues because "it contains pro content".
This is driving me nuts. Please can someone help.
from the monday we have a problem with the actualization of our reports. We are using the BI personal gateway for the actualization purposes. Everything seems ok, credentials are correct, gateway is online. Until sunday the reports were actualized correctly. But when we try to actualize our reports now we get this error:
We had already tryed to change everything what is on our side, reinstall Personal Gateway, change credentials, reconfigure reports, delete all reports and upload them again, even recreate a workspace. Unfortunately with no success. Can anyone please advice?
• I have a report with a direct connection to a cube and one visualization using a matrix.
• The data source size is not large (< 45mb on Analysis Server).
• The response of the system is very slow when you add dimensions and measures.
• The cube has no issue since the same report is working extremely fast with other products (used excel & a competitive product to compare performance)
• Using other available visualizations from PowerBI the results are also fast.
• The problem is with the matrix (and table) visualization. When I add 4-5 dimensions and 3-4 measures the system drains CPU and RAM of analysis server to its limits.
• I tried the same to an azure environment using 128GB RAM and 8 cores and I had also same result (out of memory exception) which I believe is unacceptable for such a small dataset.
• There is no difference with PBI client or online service in the behavior.
Is there a limit to the number of rows a matrix can display? I cannot find any documentation on that.
Any other ideas?
Having both installed at the same time causes Personal Gateway to stop working. This means that users will have to divide 'gateway ownershi' to multiple people which increases the scope and head count needed for any data project.
Today, when I refreshed my dataset using a data gateway, I got this error:
It's the first time I got such error, could it be possible to auto-restart the update in case of errors?
If I hadn't took a look, my coworkers wouldn't have any datas till the next scheduled update.