New Idea
0 Kudos

Scroll not working on New Slicer Dropdown

Status: New
by Zwakele Frequent Visitor on ‎12-01-2016 04:47 AM

With the new update giving an option to add a slicer as a dropdown, I found that the scrolling up or down on the slicer does not work on Dashboards or embedded reports. 

 

It works on PBI Desktop

0 Kudos

Problem:

Uploading a pbix file with custom function calls to a parameter.

 

Details:

Parameter: "12345//abcdefgh//klmnop"

Function: "Splits the parameter by "//", returns the correct part of the parameter based on an input value)

Query: "Source = Function("FirstValue")"

                     Returns: "12345"

 

It works great to refresh and have function calls either directly in the Query with position/split functions or by a custom function call ("Function") locally in the pbix file. When uploading the pbix to the service with function calls to control what part of the parameter should be fetched in the query it's not possible to either refresh nor schedule a refresh:

"You can't schedule refresh for this dataset because one or more sources currently don't support refresh."

 

I've seen a work around for this problem written by Chris Webb:

https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power...

 

In my case the work around did not work, it's a slightly different approach in Chris Webb's case (he uses Web.Contents, I'm using an odata call).

0 Kudos

Does anyone have a fix or workaround for this?   Is this a known bug?

Status: Needs Info
0 Kudos

Matrix/Table Bug

Status: Needs Info
by cproloff Frequent Visitor on ‎11-30-2016 07:22 AM

I noticed a possible bug with the table or matrix visuals.  I have a matrix that shows revenue by department for a selected month as well as YTD values thru the selected month. It appears that if the selected month has no values, then the YTD values don't show up in the table/matrix either. This should not happen. I tested in a tradition pivot table in excel and it works as expected. The value for the selected month is blank, but the YTD value is still displayed. Any solutions for this behavior?

 

Thanks!

Collin

 

Power BI Screenshot

Status: Needs Info
0 Kudos

All bar charts appear to be wrong in this case; X axis with numbers from negative to positive, X axis 'start' setup e.g. on '-1' (with data present less than -1).  All fine, until you use color saturation. Seems that the coloring loop doesn't take the 'start' into account, mixing up the indexing of the bars... Resulting in wrong X labels etc.

Status: Delivered
0 Kudos

Hello,

 

Preview.Error: The type of the current preview value is too complex to display.

 

Dynamics CRM 2016 update 1.

https://xxx.api.crm4.dynamics.com/api/data/v8.1

2.41.4581.361 64-bit

Table: SystemUsers (note: this i a relative small table).

 

Conform:

https://community.powerbi.com/t5/Desktop/Why-am-I-getting-the-following-error-quot-Preview-Error-The...

this problem should be fixed in PB October update, but I'm dealing with the same issue as we speak.

 

Anyone? Thanks!

 

Status: Accepted
0 Kudos

 

 

Detailed error message:

 

Unable to load report
Please try again later or contact support. If you contact support, please provide these details.

 

Activity ID066b6bf0-5a18-415d-9781-902571e20be3
Request ID2f0c1ed2-442f-7332-26c6-69babfc7491d
Correlation IDa3bcfba6-b93c-b29a-9f14-9ad3ae97c67b
TimeWed Nov 30 2016 17:25:00 GMT+1000 (E. Australia Standard Time)
Version13.0.1700.679
Status: Needs Info
0 Kudos

Ability to create zones in scatter plots

Status: Delivered
by dedmondson Frequent Visitor on ‎11-29-2016 02:01 PM

I can create defined constant lines in a scatter plot. For example an X line at .75, and a y Line at point 7. For a series lines, my chart might look like photo 1. But what I'd like is to be able to set a range or zone fo color defined by lines, so that you can easily identify items that fall into those zones, as in the drawing in photo 2.

 

Status: Delivered
0 Kudos

Existing visuals

My client has been using this report for months on PowerBI.com. and today reported 3 visualization could not be loaded.  these visualizations have been working for several months without fail.

the measures work with Power BI Desktop just will NOT render on PowerBI.com

All other reports with the same Enterprise Gateway are working.

 

RCA Steps:

1. delete and publish dataset

2. adjust dax formulas -- replace 'Divide' with '/'

3. fully qualify fields within measures "Table[Credit Limit]"

4. conducted a peer review who confirmed the measures no longer work on PowerBI.com

 

 

Details error:

Couldn't load the data for this visual

Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID33401b52-8063-91ea-f4c5-1b0e3ce961f5
Request ID1f51c9d7-4a62-1053-eac3-85cf6e4db325
Correlation ID2772c86f-8a55-c7a8-472d-9e9154b72343
TimeTue Nov 29 2016 11:33:23 GMT-0800 (Pacific Standard Time)
Version13.0.1700.740
Cluster URIhttps://df-msit-scus.analysis.windows.net

 

Direct Query: Azure Database

 

Measure displays the percentage of AR with Credit limit coveragePerwCL.png
% of Total = Sum(Table[ARofCL])/Sum(Table[Total_AR]) -- Divide AR with Credit limit by Total AR
ARofCL = Table[ISManaged]*Table[Total_AR] -- Calculate amount of AR with Credit limit
ISManaged = IF(Table[CreditLimit]>0,1,0) -- flag records with Credit Limit > 0

 

 

Status: Delivered
0 Kudos

Connecting ODATA source

Status: New
by Brigit New Member on ‎11-29-2016 09:14 AM

e are trying to connect to an ODATA source but get the following error message:

 

"We were unable to resolve type name 'Collection(ODATA query)' to an EdmType"

 

Any idea what the reason could be? The ODATA query works fine in Chrome.

0 Kudos

Hi All,

I am working on a power bi project and I want to publish my dashboard on clients power bi account. When i try to login in to his account i got error that "We don't recognize this user ID or password Be sure to type the password for your work or school account."

though the user id and password provided by me are correct I am unable to login. So, can any one please suggest me any solution on this..??

Image2.png

 

 

 

0 Kudos

Gettig Debug error in Embedded PBI

Status: New
by meenakshi_bhati New Member on ‎11-29-2016 07:35 AM

We are getting debug assert failed: unsupported filter type, while exporting data directly to Power BI, but in some reports. However, the texture for all the reports are same and no new code has been applied yet.

 

 

0 Kudos

The histogram visual (https://visuals.azureedge.net/powerbi-visuals/Histogram1445664487616/gallery/report/Histogram.pbix) is cutting off data and not showing the max appropriately. It seems to be fine on a smaller dataset but when the # of rows is > 5000~ it does not show it correctly.

 

 

 

min.jpghistvsbar.jpgmax.jpg

0 Kudos

Power BI Desktop Visual Coordinates

Status: New
by Jazza Visitor on ‎11-29-2016 06:50 AM

Hi,

 

I believe there is a minor bug with the X,Y co-ordinates of visuals in Power BI Desktop. Here are the steps to reproduce the issue: 

 

1. Launch Power BI Desktop.

2. Connect to a data source and import some sample data

3. Go to a blank page (e.g. Page 1)

4. Add a visual to the page and add some data to the visual

5. Whilst the visual is selected, select the format icon in the Visualizations pane. Set the X position of the visual to 10 and the Y position to 10. Set the height to 200 and the width to 200.

6. Add a second visual to the page and set the X position to 10 and the Y position to 220, so that the top is spaced 10 from the bottom edge of the first visual.

 

If you select the second visual, you will see that the top of the visual (including the bar containing the Focus Mode and Export/Remove buttons) overlaps the bottom of the first visual, there is no space between them. To get the spacing I desire, I need to add another 15 to the Y position i.e. 235. When you click outside the visual, the bar goes away, and the overlap is not apparent.  It seems as if the height of the bar containing the Focus Mode and Export/Remove buttons is not counted when taking into account the Y position of the visual - it's as if the actual Y position is (specified Y value - height of bar). This may be by design, but I think it is counter-intuitive. I would class the bar as part of the visual container and would expect the position of the visual to match the value I entered.

 

I'm using the October 2016 release (Version: 2.40.4554.421 64-bit)

 

 

 

 

0 Kudos

Timeline Latest date selection issue

Status: New
by sujitgavhane New Member on ‎11-29-2016 06:01 AM

Hi,

We have timeline visual. Its default selection is showing value selected at time of publish. But we have scheduled refresh enabled for report and want default date to be latest date after refresh. Please suggest.

0 Kudos

As of recently (worked in September), the data labels for SOME of the bars on a bar chart are not showing up any longer. This is seen in both the designer and on the website. The data labels used to appear on all the bars, but now a few are missing. This occurs on data that has not changed at all and used to work as well as any new data I may include in the report. NO changes have been made to the report.

MGDT_0027.png

 

 

MGDT_0028.png

 

 

 

0 Kudos

Data Refresh error

Status: New
by acefull Frequent Visitor on ‎11-28-2016 03:18 PM

Having a same data refresh issue for last three weeks. Can you please help asap? I'm a PRO user @ Nike.  If you please provide support number where I can call and address the issue immedately?

 

OneDrive refresh for StageReport.csv has been disabled. You can learn about common reasons refresh fails in our help topics or reach out to our Community for help. As always, you can also contact support.

If you contact support for this issue, please provide them with the following information:

Activity Id: b6a57d09-771d-4276-b54e-2f9643d6dcbb

Request Id: a3c31ad7-1c70-48a0-86c6-31c6d479fb23

Cluster Name: WABI-WEST-US-redirect.analysis.windows.net

Refresh Start Time: 11/28/2016 22:38:09Z

Refresh End Time: 11/28/2016 22:38:10Z

0 Kudos

This problem was originally posted in "ideas" forum on 11-4-2016. Reposting in "issues" forum.

I have the latest version of the Oct. release.

‎When editing interactions in Desktop, Oct. 2016 update (64bit), it appears that if you change the interaction on one visual, it applies to all the other visuals. (e.g. no more independant interactions between different slicers).
This seems to be a screen update problem - if you move to another page then back again, the interactions are correct.
(this is not a problem in September 2016 release). This is cumbersome and confusing when trying to set up interactions between visuals.

Status: Delivered
0 Kudos

Drilldown not working

Status: New
by david_kwok New Member on ‎11-27-2016 07:23 PM

I have found issues with the Drilldown in the online published reports. The issue lie with the X asis of the bar charts not showing the correct information whenever I drill down.

 

Please note that the issue is dervied from drilling down via the drilldown button. The "Drill all to next level" button works fine and the correct information is shown on my charts.

 

The online reports have this problem but not the desktop version where everything works just fine. 

 

Please hurry and fix this issue. How is it that it was working fine 3 days ago and now it is broken? Management needs to use these dashboards and reports for meetings!

0 Kudos

When I pass a dataframe to R from Power Query I run into a problem with dates. For instance if I pass a dataframe that represents a Date table to R using the following script:

 

    new_dataset <- dataset

 

The date field is returned as follows:

 

 

ScreenCapture.PNG

 

My goal was to pass a Date table to R and add some attributes to the Date table using R. But when I pass a Date table to R the dates are replaced with "Microsoft.OleDB.Date". Any idea what's causing this problem? What are the known issues with the R integration in Power Query?

 

Status: Delivered