New Idea

Query Editor Window Bug

Status: New
by jameslo30 Member yesterday

Bug in PowerBI Desktop Version: 2.51.4885.701 64-bit (October 2017)

 

When you single click a query in the "Queries" selector on the left hand side, it thinks you want to move the query up or down to re-order.

This did not happen in the previous version.

 

Issue.png

Hi everyone,

 

Since the latest PBI service update the Chiclet visual is not working within published reports. The issue has been raised in the Community forum but yet to be resolved:

 

https://community.powerbi.com/t5/Service/Slicer-works-on-Desktop-but-not-well-Online/m-p/242274/high...

 

From initial testig this is what we have found:

 - various versions of the visual work within PBI Desktop (also variety of versions) but whenever published doesn't work as it should

 - when published online the visual doesn't refresh the other affected visuals (instead it either does nothing, displays the wrong information, or requires a different visual to be clicked before it is refreshed)

 - only under one circumstance were we able to get it published correctly (that was to an account we created years ago in O365 - all other accounts, including new accounts created in O365 today, fail to load the visual properly)

 - the visual works fine within the Windows 10 PBI App

 - the issue (that we have kown about) has been ongoing for the past few days - corresponding with the latets PBI Service update

 

Any help would be much appreciated as we have over 50+ reports using this visual and it's quite an embarassing to have to explain to users/customers we're not sure why or when the issue can be fixed.

 

Thanks

 

Jarrod

Emails Invitations - Dashboard Security Check - Email address not shown

Status: New
by mjohnson Frequent Visitor ‎09-28-2017 03:09 PM - edited ‎09-28-2017 03:12 PM

I created 5 new dashboards in Power BI Pro and shared them with individual users, most of which had never used Power BI before. 

 

When these users navigate to the report, but they received an error, "Dashboard Security Check - It looks like you don't have access to this dashboard. You can request access from the owner." So somewhere between signing up for a Pro License and arriving at the /dashboard/ page, their access privileges get lost.

 

If they Request Access, and I approve it through the Share Dashboard feature, I will receive their request, but it comes as a separate user (email address not shown, just the person's first and last name) and the email address that was used to send the invite is shown as unopened (cancel invitation link is visible) even though they are using the same email address to request access.

 

I fear that this is a security risk, if I approved a request to see a dashboard because I see a familiar name, how do I know that this request is coming from within my organization if I cannot see their email address?

 

Can you test this process a bit and see if there may be a bug in the system? I am unable to send a screenshot because I already approved all the users!

 

Thank you!

Mike Johnson

NoAccess_PBI.PNG

PowerPoint Export - Bugs / Issues

Status: New
by andrewporter Frequent Visitor on ‎09-28-2017 04:52 PM

Hello - 

 

I am listing some bugs / issues I have found with Power Point files that are generated by Power BI. Please let me know if I need to provide more detail, thanks! Otherwise very happy with PBI, it just needs some fine tuning.

 

On Power BI Export to PowerPoint...

 

  • Text boxes lose text alignment and background color (font-family and sizing are OK)
  • Text boxes, shapes, and cards all "superimpose" themselves (with styles applied) onto each other if they overlap
    • Even elements that are 'lower" / "behind" other objects in terms of arrangement, still superimpose on other objects
    • This is probably by design to fuse together nearby objects but it's not figuring out layering priority correctly
  • KPI type visuals lose font format and sizing (they do keep styles like color and background color)
    • Note: you can't change or control font format / style for KPI visuals anyways
  • All objects have hyperlinks to Power BI which is very busy, these open your web browser when you go into presentation mode which is annoying
  • Background images only show up when there is a Power BI element layered above it, otherwise blank
    • HACK: Add a full-sheet Power BI "square shape" that is 100% transparent, 0pt border but beware of superimposing issue and hyperlink issues above)
  • PBI Reports cannot be exported to PowerBI with "interactivity" meaning if you update a slicer or filter in the web browser without saving (very common...), your export to PowerPoint will be the "original" version
    • I realize this is documented as how PowerBI currently exports PPT from back in March 2017 but it should be fixed to at least give the user an option to export with modifications or original.

We deal with results that are small values less than 1.  They are not negative numbers.  But they are often in the range of 1x10^-2 to 1x10^-12 values.  We have been using PowerBI for the last year.  Recently in the last month it was noticed that our charts of these numbers create a false negative axis.  This makes the charts unreadable.  see figure "example of initial problem".  negative axis problem.PNG

 

 

 

 

 

 

 

 

 

 

We have tried setting the min value to 0 but that does not solve it.  We have found that increasing the significant figures of the value to 4 or 5 helps temporarily.  see figure "example of fix when increase decimals displayed...". 

However this only works initially.  If the user then selects a filter that reduces the dataset, then the problem returns - see figure "example of problem return..."

 

We have a large range of values (all less than 1) to display so we cannot increase the decimals of the scientific notation further - 4 or 5 digits are already too many to display anyway given the uncertainty of the values to begin with.  

We are not sure when this problem started; we did not notice it in the spring or early summer.  So it must be a new issue that started sometime in the summer.  Sorry we cannot comment on which version.  negative axis problem fix.PNGnegative axis problem fix2.PNG

 

 

 

 

HI,

 

I recently had to re write some reports due to changes made to our data warehouse, initiall i made the changes and attempted to republish the data, however the file would not publish, and just kept spinning.   I unistalled and reinstalled the gateway and powerbi and tried again, and this time recieved an error stating powerbi unable to write data to the transport connection.

 

I removed all data sets and reports from the web app, saved my pbix file in desktop using a different name, and tried publishing through desktop again, and recieved the following error:  An Error occurred while attempting to publish 'sales information.pbix': Exception of type 'microsoft.powerbi.client.windows.services.powerbiwebexception' was thrown.

 

I then tried to import the pbix file from the web and recieved this error:

 

Something went wrong
 
Failed to publish Power BI Desktop file
Please try again later or contact support. If you contact support, please provide these details.

 

Activity IDb08c123f-1bae-4f47-8098-44ec00537aee
Request ID67c1d93d-f94c-886f-b968-a556f558a7a2
Correlation ID921421f7-5d8c-df69-5505-d632a4dc1525
Status code-1
TimeThu Sep 07 2017 16:21:26 GMT+0100 (GMT Standard Time)
Version13.0.2278.219

 

i notice on the service status page there is an awareness flag stating:

 

We are experiencing a temporary issue where some users may not be able to update their Apps or Content packs. Engineers are aware of the issue and are working on a fix. Next Update by 09/08/2017 11:00 PST

 

Is this what is causing my problem, of is there another reason?   If this is the issue, is there a work around?

 

Thanks Dan.

 

 

Card with states visual - Data label issue

Status: New
by Sivasuba1 Frequent Visitor on ‎09-19-2017 06:28 PM

Does anyone facing the problem when using Card with States by OKViz?

 

The date label is not working after the cube refresh this morning. The color of data label should be red but it shows as green. This was working fine since Monday. I have read thru various issues report about this visual - we dont have text display issues for this but the data label color is mixed up

 

Do we need to change any settingStates setting.png

 

I am not sure what is causing this problem. Please do let me know as it's impact lot of users. 

 

Thansk,
Siva

Embedded report(javascript app owns data) is not showing images

Status: New
by dhagan Visitor ‎09-19-2017 07:40 AM - edited ‎09-19-2017 07:46 AM

I've embedded a report on a web app(javascript app owns data), the report works fine and i'm able to apply filters etc, but i'm getting 403 forbidden errors on all the images used by the report. I have no issues with the images when viewed directly on the power bi service, this is specific to embedded reports. I even created a new app(new clientId), and gave it more permissions, but that didn't help. Any ideas on how to fix this? 

 

Screen Shot 2017-09-15 at 12.18.11 PM.png

When combined with non-SQL-datasources query-folding will often not work: http://www.thebiccountant.com/2017/07/20/sql-query-folding-bug-still-alive-sucking-powerbi-powerquer... 

 

This is really nasty. As performance optimizations is such a black art still unfortunately, many people will probably just throw the towel here, so I expect a high number of unreported cases here, so please fix.

I have been trying to roll out Power BI to my organisation (it is a rather large organisation with many users all over the country) whilst our Central IT department is working through upgrading us to Power BI Premium and I have discovered a bug that the Microsoft Customer Service person who is helping me claims is by design.

 

Bug that was discovered: When I share a report via a dashboard to a new Power BI user (doesn't already have a Pro Licenses) and the user signs up for a Pro Trial to see my report, I need to cancel the invite and resend it.

 

Steps to reproduce:

  1. Create a report and publish it to a group
  2. Create a dashboard for the report and share it with a user who is not a Pro user yet
  3. Have your user sign up for the Power BI Pro Trial
  4. User will get "Sorry, we couldn't find that report" error

 

The workaround:

  1. After your user signs up for a Power BI Pro Trial (step 3 in the above), go to your dashboard and click "Cancel Invite"
  2. Resend the invite to your user

 

This works, however, it is a bug and it is creating a lot of extra work for the people who are producing / sharing reports as well as frustrations from our end users.

 

If you could fix this or assure that this will be fixed when we move to Premium, that would be really helpful in getting our users to adapt to Power BI as their new reporting tool.

 

Thank you,

-Winnie

Hello!

 

I raised a bug that I thought was fixed in the new version of Power Query, but it has since reoccurred.

http://community.powerbi.com/t5/Issues/Bug-Power-Query-filter-rows-does-not-show-all-the-items-in/id...

 

Do you know what could be the cause of or solution to this?

Justin

Bug: Power BI Dashboard navigation

Status: New
by JamesBI Visitor on ‎08-28-2017 01:26 PM

Here are a couple ways to get the error:

 

  1. Open the dashboard via the initial login screen
  2. Open the dashboard via the workspace

 

 

When the dashboard is clicked I experience the following behaviors:

 

The first option you get this (a) error message and once you click through it several times you finally get to the dashboard and it does not have correct color scheme - should be #A6093D (b), also the name in the IE tab does not match the dashboard name (c). See images

Bwrong color.JPG

 

Cwrong tab name.JPG

 

Aerror message.JPG

 

When I go through the workspace to get to the dashboard, I don’t get (a) or (c) from above but I get (b)

 

We are trying to use Power BI to pull data from SAP BW leveraging both BEx queries and cube connections. With each scenario we are running into different issues and were trying to figure out if this is a Power BI Limitation/Issue with 1. Connecting to a Warehouse 2. They way that Power BI is communicating with SAP BW to pull its data or is this a SAP BW Limitation/Issue based on how SAP BW servers up data.

 

Tested With Cube:

0FIGL_C10 -General Ledger (New) Transaction Figures

 

Data Load is very slow

Adding new columns and refreshing data seems to take a very long time. I don't know if this is a sap warehouse issue, an OLAP issue, or a power bi Issue. I had our basis team monitor our BW environment when connecting to a cube where I selected all the columns. The cube contains 349,628 records which is based on generating the SQL Statement from the cube (In SAP BW RSA1) and executing that in SQL Server Management Studio. This call eventually failed with the following ‘RFC_ABAP_RUNTIME_FAILURE: TSV_TNEW_PAGE_ALLOC_FAILED which I was told was due to running out of memory. Prior to testing this I had Basis increase our memory footprint on the server in an attempt to rule out memory issues.

 

Column limitation (selecting to many columns) or possibly and combination of Columns + Rows

When I connect to a cube and select 1-4 fields everything is pretty responsive. But as you start adding more and more fields the performance starts to suffer. In testing it looks like we can add 12 fields without any issue (Super Slow Refresh Times) but once we hit the 13th field we get an RFC_ABAP_RUNTIME_FAILURE – TIME_OUT.

 

MDX

I don’t write a lot of MDX statements so my statement could be the cause of the issue but I run into the same issues remain. Which makes sense because I believe Power BI is connecting to SAP BW through the BW Open Analysis Interface OLBAP BAPIs regarless of if you going againt a Cube, BEx Query, or MDX.

 

This works:

Select   NON EMPTY [Measures].MEMBERS ON COLUMNS,   NON EMPTY   [0FISCYEAR].Members *   [0CO_AREA].Members *   [0COMP_CODE].[LEVEL01].Members   PROPERTIES     [0COMP_CODE].[20COMP_CODE]   on rows   from [$0FIGL_C10]   WHERE ([0COMP_CODE].[1100], [0FISCYEAR].[K12016])

 

Doesn’t Work

Select   NON EMPTY [Measures].MEMBERS ON COLUMNS,   NON EMPTY   [0FISCYEAR].Members *   [0CO_AREA].Members *   [0COSTCENTER].Members *   [0CHRT_ACCTS].Members *   [0CO_AREA].Members *   [0CURTYPE].Members *   [0FUNC_AREA].Members *   [0GL_ACCOUNT].Members *   [0PROFIT_CTR].Members *   [0SEGMENT].Members *   [0VALUATION].Members *   [0VERSION].Members *   [0FISCPER].Members *   [0FISCPER3].Members *   [0FISCVARNT].Members *   [0FISCYEAR].Members *   [0COMP_CODE].[LEVEL01].Members   PROPERTIES     [0COMP_CODE].[20COMP_CODE]   on rows   from [$0FIGL_C10]   WHERE ([0COMP_CODE].[1100], [0FISCYEAR].[K12016])

 

Key and Text Values

The last think I want to touch on is the key values. Power BI does not appear to give you the ability to select or toggle between the text and key values. Though MDX I was able to include the properties section and include the key value (Which was nice) but this should be standard functionality.

 

Tableau

I wanted to try and cover all my bases and rule out as much as I could to try and pin point the issue. As such I used Tableau to connect to the same structure as it’s my understanding that it also utilizing the BW Open Analysis Interface OLBAP BAPIs to query SAP BW. I’ll point out that I don’t really use Tableau but it was a tool that was available to use a test. Once again I had Basis monitor the SAP Environment to help track down any issues. Within seconds tableau had pulled in the Metadata and I was able to create a sheet. Tableau appears to provide a live query connection to the cube whereas Power BI appears to try and load the data first which may also be contributing to the performance issues. Again I just wanted to test with another tool to try and rule out the SAP environment.

 

 

 

With SAP being our ERP system we need the ability to effectively be able to query our data warehouse and provide the user community with self-service reporting/analytics. With the issues listed above its making this a very difficult process to move forward with. Any ideas or suggestions would be greatly appreciated. We love Power BI and the users who have seen our demos love what it can do and I feel like we are always installing this on someone’s machine.

 

Thoughts?

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"

When calling Stored Procedures in a SQL Server database in Power BI Desktop (latest version), we get ab error "This query contins transformations that can't be used for a live connection"

 

bug-storedproc.png

Dashboard Tile Content Can't Load

Status: New
by Andreia Visitor ‎08-16-2017 01:57 AM - edited ‎08-16-2017 02:14 AM

Hi,

 

When I open the dashboard I get prompt with this errors in only some of the tiles. After repinning the same tile from the report the error disappears. However, after a few hours the same error in the same tiles reappears. I send some snapshots of the error in question. Can you give us an ETA on this matter?

 

Thank you

 

 

 error3.PNG

Erro2.PNG

Slicer font color bug (for selected slice)

Status: New
by cmauricio Occasional Visitor on ‎05-20-2017 09:54 AM

A few days ago, my slicers layout got ruined: because its not possible to configure font and background color for either selected and unselected slices, we can only use force "default" colors for slicers.

 

I have a couple of horizontal orientation slicers. Dark grey as background color and white as foreground, right? Nope. Dark grey as background color, black as foreground color...

 

PowerBI Desktop - Dark Grey & white -> perfect

1.png

 

 

 

Published link (web) - Dark grey & black -> wrong

2.png

 

How can i solve this? Even better, when will we all be able to set colors for background and foreground (selected slices)?

 

Thanks!

 

 

 

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

Processing error:

Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.

Cluster URI:

DF-MSIT-SCUS-redirect.analysis.windows.net

Activity ID:

af3be4d7-3ecf-4362-92fa-e388b67e7f56

Request ID:

1ae579e5-2dea-6a64-309d-9e14aa55882c

Time:

2017-07-31 18:32:30Z

  

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 ? ?

Get Data using Streaming Data API - PUBNUB

Status: New
by alisonhughes Occasional Visitor on ‎07-19-2017 02:28 AM

I am struggling to get a pubnub stream working . I have data and can see it from a HTTP request in my chrome

 

http://pubsub.pubnub.com/history/sub-c-e*******/test/0/10

 

[[{"Customer":"AAAAA555555","Value":98.6,"Orders":98.6}],[{"Customer":"AAAAA555556","Value":98.6,"Orders":98.6}]]

 

 

but when I try and add this data stream as a streaming data set , I get the error ...

 

 "We didn't detect any data in the channel. Please ensure that the info you entered on the previous screen is correct. If so, provide info for the dataset on this screen".

 

and the fields are not brought in which is what happens when I link to a sample. Is there something else that is required 

 

Idea Statuses