New Idea
0 Kudos

Enterprise Gateway

Status: New
by jenb1 Frequent Visitor yesterday
The gateway is up and online, I have been added as an admin, but when I try to apply the gateway I receive the following error.  It is extremely unhelpful. Need to understand what the issue is.
 
 
Something went wrong
 
Failed to use the selected gateway. Please make sure the gateway is up and running and try again.
Please try again later or contact support. If you contact support, please provide these details.

 

Activity ID3efa17a9-20db-4b0d-87d3-bb700bd17604
Request ID7ee13545-31c4-1678-def5-e1edf812ac2a
Correlation IDbd333f1e-f697-e899-5f56-dfcaf647b725
Status code400
TimeMon Jun 26 2017 15:47:56 GMT-0700 (Pacific Standard Time)
Version13.0.1781.186

 

0 Kudos

Hi, I am not able to increase the size of the search bar in attribute slicer, previously it used to scale as per the text size. did anything changed recently ?? 

 

Hi, 

 

I am having trouble getting a plotly to work in my custom R script, although it runs in R studio. Many hours of searching has yielded no help. Can we get a tutorial on how to implement a plotly graph in powerbi? 

 

-Sean

0 Kudos

I am having an issue when clicking on the tabs to the left in Power BI Desktop. The Reports and Data tabs generate the information in the view, but when I click on Relationships, nothing is generated in the window.

Relationships tab.JPG

Any ideas as to what the problem is and how to fix it? Thank you for your time!

 

Best regards,

Dan

 

0 Kudos

Hi,

 

I'm experiencing an issue where my measures are inconsistent between the table view and the visual view. I created two measures for beginning and end dates, RD1 and RD2. Below shows them with different values depending on where I look. Is this the expected behaviour?

 

RD1.PNGRD2.PNGRD Table View.PNG

0 Kudos

Cities are placed wrongly on US Map

 

Map Error.png

0 Kudos

 

The concatenation feature in line chart, as suggested in the June update, doesn't seem to be working.

 

Capture2.PNG

0 Kudos

I have just experienced a bad weekend return. All users complaining that their reports/dashboards were not operating anymore.

I quickly discovered that both On Premises Gateways (DEV and PROD)  were "down", "Unable to connect: The gateway is either offline or could not be reached".

 

Microsoft support did not provide a reason, but instead suggested frequent update of the OPG, as well restart of the associated Services on the machines when something is going wrong.

 

I asked why should we wait for end users to complain, prior taking action, as PowerBI service knows there are some refresh issues, as this is shown to me immediately on the Manage Gateways portal?

 

I was suggested to raise idea... Great so here I am.

 

So for Microsoft sake and I believe every IT organization that wants to keep trust from end users, we need:

-Capability to set alerts on any dataset refresh failure. I say ANY because I discovered few hours after the start of my investigations that I got some Failure to refresh notifications in my Outlook Clutter folder..... Clutter: not good. I need to fix that. But I also realized that only few datasets were sending such. Investigating a bit more, it seems my datasets "Live Connected", "Direct Query" not needed a refresh setup per se, won't allow to setup such alert. On the opposite, Excel based, Folder based dataset are allowing me to setup the "Send refresh failure notification email to me".

-Capability to add multiple recipients for that notifications, including Active Directory distribution groups to ensure such issues are addressed asap.

 

0 Kudos

Hi Experts,

 

We, as a company are maintaining a OLAP cube in MS Analytical Services. We use MS SQL Server Management Services. I am trying to connect Excel 365 online to the OLAP cube. I should be able to refresh connection from Excel 365.

 

Things I have tried:

1. Connecting Excel 2016 desktop to OLAP cube (Successful) and opening the same file in Excel 365(Failed)

2. Using power BI:

a. Created an organization gateway.

b. Connected power BI to organization gateway(Success)

c. Connect Excel 2016 Desktop to power BI dataset (Sucess)

d. Upload same excel file online and refreshing the connection. (Failed)

 

 

PS: I am using the same user account everywhere. Also, I am added as a user to all gateways and OLAP cube.

 

Please let me know if there is a solution for this within the existing infrastructure.

 

Thanks.

0 Kudos

CHISQ.INV.RT results are different between Excel 2010, Google Spreadsheet and Power BI...

 

Is this a bug in Power BI?

0 Kudos

Hi!

 

It seems that this bug is back.

I am using the PBI version 2.47.4766.801 64-bit (June 2017) on two dashboards.

Today, i just wanted to publish them again (no change on the data model or measures compared to last week) and then got the following error "Object reference not set to an instance of an object".

The only one difference, is that i had before the first release of June and now the second one.

The data source is a local Excel file.

 

From some previous posts where this bug already happened in the previous version, I got the hint to try to roll back the version. I will give it a try.

 

Cheers. G.

0 Kudos

CORRUPT PBIX FILE

Status: New
by mattia92 Visitor yesterday

When i open my pbix file, power bi return to me an error:

 

FILE DAMAGED OR NOT VALID REPORT FILE

How can i fix that??

Thanks

0 Kudos
Couldn't load the data for this visual
 
The query referenced calculated column 'Open Tickets'[Less Than 1 Day] which does not hold any data because evaluation of one of the rows caused an error.
Please try again later or contact support. If you contact support, please provide these details.

 

Activity IDced528cb-3fdd-45d1-9ad4-1cb91c7c0494
Request ID2e5b0f50-1767-d1ea-037a-2308711cb578
Correlation ID34494b21-9c12-5559-9b1f-c5353c00d857
TimeMon Jun 26 2017 11:38:02 GMT+1000 (AUS Eastern Standard Time)
Version13.0.1721.165
0 Kudos

It seems it is not possible to change the color of the bottom y-axis line in a stacked column chart.

 

stackedcolumnchart.png 

Status: Delivered
0 Kudos

I am very new to PowerBI, I want to add REST API like /API/{TicketId}/audit.json  here {Ticketid} should be dynamic and filled from another API  /API/Ticket.json

is this type of integration possible in Power BI, if yes please let guide me on this

0 Kudos

data refrsh issue

Status: New
by aka Regular Visitor Friday

Hi guys,

Am a Pro user and i have schedule refresh on few reports on poer Bi services Online, My schedule refresh always shows that is has succedded but when i croass check my data its seems it hasnt load all the data correctly.

Then i force refesh my dataset and then my data accuratley matches.

Can any one guide me through this problem why is this happening.Help will be really appreciated.

 

Thanks

 

0 Kudos

Hi Everyone,

 

All of the sudden, the reports that we had running for months stopped working.  I isolated the problem down to this simple query.  The table.ExpandRecordColumn is causing the issue.  The source data is Dynamcis CRM online using Odata 4.

 

let	
        Source = OData.Feed(CRMServiceUrl, null, [Concurrent = true, ODataVersion = 4]),
        opportunities_table = Source{[Name="opportunities",Signature="table"]}[Data],
    #"Expanded haw_Dealer" = Table.ExpandRecordColumn(opportunities_table, "haw_Dealer", {"address1_city", "name"}, {"haw_Dealer.address1_city", "haw_Dealer.name"})
in
    #"Expanded haw_Dealer"

Error Message:
Specified method is not supported.

Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified method is not supported. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified method is not supported. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified method is not supported. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified method is not supported. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified method is not supported. ---> System.NotSupportedException: Specified method is not supported. ---> System.NotSupportedException: Specified method is not supported.
at Microsoft.Mashup.Engine1.Library.OData.V4.ODataExpression.VisitColumnAccess(ColumnAccessQueryExpression expression)
at Microsoft.Mashup.Engine1.Library.OData.V4.ODataColumns..ctor(RecordTypeValue recordTypeValue, Capabilities capability, IEdmEntityType entityType, ODataEnvironment environment)
at Microsoft.Mashup.Engine1.Library.OData.V4.ODataQuery..ctor(ODataEnvironment environment, IEdmNavigationSource navigationSource, ODataPath path, IEdmNamedElement namedElement, IEdmEntityType entityType, RecordTypeValue recordTypeValue, Boolean isComposable, Boolean allColumnsSelected, Uri baseUri)
at Microsoft.Mashup.Engine1.Library.OData.V4.ODataQuery..ctor(ODataEnvironment environment, IEdmNavigationProperty navigationProperty, IEdmNavigationSource navigationSource, RecordTypeValue recordTypeValue, Uri baseUri)
at Microsoft.Mashup.Engine1.Library.OData.V4.ODataReaderEnumerator.CreateEntryLinkValue(NavigationLinkWrapperPropertyLookupValue lookupValue, TypeValue fieldType, Int32 column)
at Microsoft.Mashup.Engine1.Library.OData.ODataStructuralValueConverter.<>c__DisplayClass1f`1.<CreateEntryValue>b__1b(String key, Int32 i)
at System.Linq.Enumerable.<SelectIterator>d__5`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Microsoft.Mashup.Engine1.Library.OData.ODataStructuralValueConverter.CreateEntryValue[TODataException](ODataEnvironmentBase environment, TypeValue type, IEnumerable`1 properties, Dictionary`2 links, Func`4 createEntryLinkValueReference, Func`2 marshalFromClr, ODataEntry entry, IEdmEntitySetBase entryEntitySet)
at Microsoft.Mashup.Engine1.Library.OData.V4.ODataReaderEnumerator.CreateEntryValue(TypeValue type, ODataEntry entry, IEdmNavigationSource entryEntitySet, Dictionary`2 links)
at Microsoft.Mashup.Engine1.Library.OData.V4.ODataReaderEnumerator.<>c__DisplayClassc.<ReadEntryFromLink>b__8(TypeValue type)
at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Microsoft.Mashup.Engine1.Library.OData.V4.ODataReaderEnumerator.CreateEntryLinkValue(NavigationLinkWrapperPropertyLookupValue lookupValue, TypeValue fieldType, Int32 column)
at Microsoft.Mashup.Engine1.Library.OData.ODataStructuralValueConverter.<>c__DisplayClass1f`1.<CreateEntryValue>b__1b(String key, Int32 i)
at System.Linq.Enumerable.<SelectIterator>d__5`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Microsoft.Mashup.Engine1.Library.OData.ODataStructuralValueConverter.CreateEntryValue[TODataException](ODataEnvironmentBase environment, TypeValue type, IEnumerable`1 properties, Dictionary`2 links, Func`4 createEntryLinkValueReference, Func`2 marshalFromClr, ODataEntry entry, IEdmEntitySetBase entryEntitySet)
at Microsoft.Mashup.Engine1.Library.OData.V4.ODataReaderEnumerator.CreateEntryValue(TypeValue type, ODataEntry entry, IEdmNavigationSource entryEntitySet, Dictionary`2 links)
at Microsoft.Mashup.Engine1.Library.OData.V4.ODataReaderEnumerator.MoveNext()
at Microsoft.Mashup.Engine1.Library.OData.V4.BatchEnumerator.ReadPage()
at Microsoft.Mashup.Engine1.Library.OData.V4.BatchEnumerator.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.Query.get_RowCount()

0 Kudos

Hi,

 

I have tested the new conditional formatting - data bars... the data bars for the positive values are always drawn from zero (from the axis), regardless setting the numeric minimum value or use of lower value, see figure below...
Minimum has an effect on visualization only for negative values and maximum for positive values ... I do not know if it was the intention ...
In my example, I would like to use a bar in the range of 15 - 19, as allowed by MS Excel... Is / will be this possible?

 

Thanks

Petr

 

Conditional_Formatting_Bars.JPG

Status: Accepted
0 Kudos

A report that has one page can be exported to power point by users within the domain easily . External users are unable to export. The in progress message box keeps spinning and nothing happens . User stopped after 30 mins. I have opened a ticket with support

Status: Accepted
0 Kudos

Hi,

 

I'm trying to export data using the option underlying, starts as exporting and then it gives error.

 

 "Error Exporting data

Sorry, we couldn't export your visual data right now.

Please try again later."

 

but if I use the summarize version it works fine!

 

Please check this.

 

Thanks.