New Idea

I am having issues installing the Power BI Gateway (powerbigatewayinstaller.exe). It seems the installer doesn't initiate/run.

I think there might be an issue with the application itself, since I am having the same issues on three different computers.

 

I have tried: 

  • Run as administrator
  • Start the installer from Run
  • Check the Task Manager if the process is actually running, with no trace of the gateway.

So I figured I check the Event viewer, and found a .net runtime error with event id 1026. There's also an application error, but I presume this is down to the .net runtime error. The information from the event viewer is as follows:

 

Tillämpningsprogram: PowerBIGatewayInstaller.exe
Framework-version: v4.0.30319
Beskrivning: Processen avslutades på grund av ett ohanterat undantag.
Undantagsinformation: System.IO.FileNotFoundException
   vid Microsoft.DataProxy.PowerBIInstallDownloader.LandingPageViewModel..ctor(Microsoft.DataProxy.PowerBIInstallDownloader.MainViewModel)
   vid Microsoft.DataProxy.PowerBIInstallDownloader.MainViewModel..ctor()
   vid Microsoft.DataProxy.PowerBIInstallDownloader.MainWindow..ctor()

Undantagsinformation: System.Windows.Markup.XamlParseException
   vid System.Windows.Markup.XamlReader.RewrapException(System.Exception, System.Xaml.IXamlLineInfo, System.Uri)
   vid System.Windows.Markup.WpfXamlLoader.Load(System.Xaml.XamlReader, System.Xaml.IXamlObjectWriterFactory, Boolean, System.Object, System.Xaml.XamlObjectWriterSettings, System.Uri)
   vid System.Windows.Markup.WpfXamlLoader.LoadBaml(System.Xaml.XamlReader, Boolean, System.Object, System.Xaml.Permissions.XamlAccessLevel, System.Uri)
   vid System.Windows.Markup.XamlReader.LoadBaml(System.IO.Stream, System.Windows.Markup.ParserContext, System.Object, Boolean)
   vid System.Windows.Application.LoadBamlStreamWithSyncInfo(System.IO.Stream, System.Windows.Markup.ParserContext)
   vid System.Windows.Application.DoStartup()
   vid System.Windows.Application.<.ctor>b__1_0(System.Object)
   vid System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)
   vid System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)
   vid System.Windows.Threading.DispatcherOperation.InvokeImpl()
   vid System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   vid System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   vid System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
   vid MS.Internal.CulturePreservingExecutionContext.Run(MS.Internal.CulturePreservingExecutionContext, System.Threading.ContextCallback, System.Object)
   vid System.Windows.Threading.DispatcherOperation.Invoke()
   vid System.Windows.Threading.Dispatcher.ProcessQueue()
   vid System.Windows.Threading.Dispatcher.WndProcHook(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)
   vid MS.Win32.HwndWrapper.WndProc(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)
   vid MS.Win32.HwndSubclass.DispatcherCallbackOperation(System.Object)
   vid System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)
   vid System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)
   vid System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32)
   vid MS.Win32.HwndSubclass.SubclassWndProc(IntPtr, Int32, IntPtr, IntPtr)
   vid MS.Win32.UnsafeNativeMethods.DispatchMessage(System.Windows.Interop.MSG ByRef)
   vid System.Windows.Threading.Dispatcher.PushFrameImpl(System.Windows.Threading.DispatcherFrame)
   vid System.Windows.Application.RunDispatcher(System.Object)
   vid System.Windows.Application.RunInternal(System.Windows.Window)
   vid Microsoft.DataProxy.PowerBIInstallDownloader.App.Main()

 

Status: Accepted

As of midday 9/18/2017, the card with states custom visual from OKViz stopped displaying text as specified in the 'Measure' field of the visuals pane. This is causing major headaches.

 

I've spoken with the visual creator who said the issue is in the Power BI code as opposed to the custom visual code. Can this be resolved? When switching the visual to the 'Table' visual, all the data remains as expected, but the Card With States visual isn't showing the text specified in the Measure field any longer. This is clearly an error. Are you working to correct this issue? Any feedback would be appreciated as we've used this visual around 1,000 times for a variety of different cases and having no text renders them useless. Thanks in advance!

Status: Accepted

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

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

Don't see the "Analyze - Explain the decrease" option after September update

Status: Delivered
by mshparber Established Member ‎09-09-2017 08:23 PM - edited ‎09-09-2017 08:24 PM

Hello friends,

In September's update there supposed to be a nice feature of explaining decrease/increase.

It is described here:

https://www.youtube.com/watch?time_continue=817&v=moTQJlnClJw

The problem is that I don't see this option when right clicking a chart column.

I did use a date column from a time dimension and a stacked column chart as described.

But no "Analyze" option....

Please help.

Thank you

Michael

Status: Delivered

When I use the drillthrough functionality to drill into a detailed report, it properly filters my detailed report.  However, the slicer for the same field does not display the value that I selected and shows 'All'.  The only way to clear the filter is to open up the filter pane and deselect the value I drilled on.  Typically, the users will see the filtered values in the slicers and they don't have to expand the filters pane.  

 

Please let me know if this is a bug or if this is the intended functionality.  If it's intended, I think it should be updated.  

Status: Delivered

I tried the java script sample from github inwhich i tried to embed the dashboad into webpage but the problem is i coudent able to see the filter option when embeding into dashboard where as i could see the filter option while coming to embeding reports,is there any way to see the filter in embeding dashboard. i have attached the screen shots of the problem

  Embedded dashboard.pngEmbedded reports.png

Status: Accepted

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.

 

 

Analyze in Excel / CubeValue not working

Status: Needs Info
by nbailey Frequent Visitor on ‎09-07-2017 01:05 PM

Starting yesterday, none of my Excel reports that I setup using CubeValue formulas are able to refresh.  Occasionally some of the cells will return values, but most of the time all of the cells just [eventually] come back with a #N/A error.  I have some Pivot Tables in the same reports using the same ODC connection and those refresh/update without any issues, it is just the CubeValue formulas that are impacted.  If I edit the formula in an individual cell (i.e. start adding a new filter variable), it reads the data model without issue (suggesting fields to complete what I am typing), and most of the time after editing that individual cell will return an actual value.  Same thing happens if I create a second ODC connection (to the same model) - if I repoint an individual cell to the new ODC connection, I get a value.  However if I try to do a find/replace on the Worksheet with the new ODC Connection, the same issue occurs - long amount of spinning with no values being returned.

 

Since it's clearly not a connection issue, I'm not even sure where to start troubleshooting?  I found a short thread in the Community forum referencing the same issue from a couple of other users, but no resolution.  It appears to be random and intermittent based on what the other users have written.

 

Community Thread:

https://community.powerbi.com/t5/Issues/Analyze-In-Excel-N-A-Values/idi-p/187339

Status: Needs Info

Issues in connecting to tabular model

Status: Needs Info
by Wybie_TPG Visitor on ‎09-05-2017 07:51 AM

I'm encountering issues when I try to connect PBIDesktop(2.49.4831.521(x64)) or import data from our Tabular SSAS model (SQL server 2016 standard edition).

When I connect live to the model the project works fine for a little while, but after a few clicks it start giving the following error:


Error Message:
An unexpected exception occurred.

OData Error Message:
Failed to execute the DAX query.

When I want to import data it works fine for most measures and dimensions, but for some measures I get an error:

 

DataSource.Error: AnalysisServices: An unexpected exception occurred.
Details:
    DataSourceKind=AnalysisServices
    DataSourcePath=172.xxx.xxx.xx;CubeNameXX

 

The query that it tries to execute is = Cube.Transform(#"CubeNameXX",
        {
            {Cube.AddMeasureColumn, "Amount", "[Measures].[Amount]"}
        })

 

The srange thing is that we also use this measures in SSRS, without any issues, but after the PBI connection SSR Sdoesn't work either until we delete and recreate the measures. Than SSRS work fine, untill we again use PBI and the issue starts again.

 

I'm out of ideas how to solve this issue, does anyone encountered such issues befor or have ideas to solve it?

 

Many thanks!

Status: Needs Info

Filled Maps Give Different Results

Status: Needs Info
by mmulder Occasional Visitor on ‎09-04-2017 02:18 AM

We have created a filled map using the names of some places in The Netherlands. My collegua created this filled map and then it worked fine in Power BI Destop (June). Then we published it to our SSRS portal and the filled areas on the map were only patially loaded. When I open the map in different versions op Power BI desktop I also get a fastly different result then my collegue.

 

We already set our system language to "English" USA. This solved some of the misplacements but definitly not all.
Result Filled Map.PNG

Status: Needs Info

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.

Pin live page interactivity in iOS app

Status: Accepted
by greggyb New Contributor on ‎08-01-2017 12:03 PM

Allow pinned live pages to remain interactive in mobile apps. Live page interactivity is a large draw of this feature, but this limits a complete dashboard experience to the browser, and prevents end users consuming reports on mobile devices from having the same rich experience.

 

Per the forum thread linked below, this functionality was working in the past, but we have recently seen with a customer that pinned live pages are not interactive on the iOS app on iPads. Per an email from the Power BI support team, this lack of interactivity is by design.

 

https://community.powerbi.com/t5/Mobile-Apps/Pin-Live-page-slicer-in-ios-App-is-not-working/m-p/1605...

Status: Accepted

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: Table.ReplaceValue kills all column types

Status: Accepted
by ImkeF Super Contributor on ‎08-03-2017 11:01 AM

When used in combination with "each" in the second argument, Table.ReplaceValue kills all existing column types (sets them back to any). Please fix:

 

https://social.technet.microsoft.com/Forums/en-US/c3f118eb-acb2-4e36-a398-d6c3759e795f/tablereplacev...

Status: Accepted

Dashboard sharing Disabled for non-PRO users ?

Status: Delivered
by djnww Established Member ‎04-27-2017 05:28 AM - edited ‎04-27-2017 05:34 AM

We can no longer share a dashboard with users from our own workspace. I received the message:

"This dashboard contains Power BI Pro content. Only users that have Power BI Pro will have access to it"

 

I confirmed my fears by publishing the simplest of reports which is 100% non-pro content. There have been a few other mentions of it on the forum in the past couple of hours, but I thought I'd create an official post. 

 

1st sharing was disabled from Group Workspaces to non-pro users. Surely Microsoft has accidentally disabled ALL sharing for non-pro users ? If not, you can imagine the uproar.

 

Is anybody else facing the same problem ? 

 

Power BI clearly states that we are able to share personal dashboards with non-pro users. 

Error.PNG

 

 

Status: Delivered

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)

 

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.

 

// Tommy

Status: Delivered

Hi all,

 

I have a client who is on the latest release of Power Bi Desktop (v 2.46.4732.721), although this issue also occurs on the previous version (2.46.4732.581). When they create a new measure on top of a live tabular model connection and set the formatting, the formatting only persists for that Power BI Desktop session. When they save the file and close and reopen, the formatting reverts back to the default, which is especially unreadable for percentages and currency. Is this fixable? Thanks!

Status: Accepted

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