New Idea

Dashboard Tile Content Can't Load

Status: New
by Andreia Visitor 21 hours ago - last edited 21 hours ago

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

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

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

  

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 

 

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"

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

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

Unexpected Error launching Power BI Desktop

Status: New
by elttec Occasional Visitor on ‎06-08-2017 08:14 AM

Hi!

 

I get the attached error message when trying to launch Power BI Desktop. I've been using it over the last weeks with no problems.

Uninstalled/installed already and the problem persists. Already tried to Send a Frown but that option isn't working.

Any help would be appreciated. Thanks.

Capturar.PNG

Detailed Log: 

 

Feedback Type:
Frown (Error)

Product Version:
2.46.4732.721 (PBIDesktop) (x64)

Release:
May 2017

IE Version:
11.332.15063.0

OS Version:
Microsoft Windows NT 10.0.15063.0 (x64 pt-PT)

CLR Version:
4.6.2. or later [Release Number = 460798]

Workbook Package Info:
None

Peak Working Set:
139 MB

Private Memory:
77.2 MB

Peak Virtual Memory:
33 GB

Error Message:
Arithmetic operation resulted in an overflow.

Stack Trace:
System.OverflowException: Arithmetic operation resulted in an overflow.
at MS.Internal.IO.Zip.ZipIOExtraField.ParseRecord(BinaryReader reader, ZipIOZip64ExtraFieldUsage zip64extraFieldUsage, UInt16 expectedExtraFieldSize)
at MS.Internal.IO.Zip.ZipIOLocalFileHeader.ParseRecord(BinaryReader reader, Encoding encoding)
at MS.Internal.IO.Zip.ZipIOLocalFileBlock.ParseRecord(BinaryReader reader, String fileName, Int64 position, ZipIOCentralDirectoryBlock centralDir, ZipIOCentralDirectoryFileHeader centralDirFileHeader)
at MS.Internal.IO.Zip.ZipIOLocalFileBlock.SeekableLoad(ZipIOBlockManager blockManager, String fileName)
at MS.Internal.IO.Zip.ZipIOBlockManager.LoadLocalFileBlock(String zipFileName)
at MS.Internal.IO.Zip.ZipArchive.GetFile(String zipFileName)
at MS.Internal.IO.Zip.ZipArchive.GetFiles()
at System.IO.Packaging.ZipPackage.ContentTypeHelper..ctor(ZipArchive zipArchive, IgnoredItemHelper ignoredItemHelper)
at System.IO.Packaging.ZipPackage..ctor(Stream s, FileMode mode, FileAccess access, Boolean streaming)
at System.IO.Packaging.Package.Open(Stream stream, FileMode packageMode, FileAccess packageAccess, Boolean streaming)
at Microsoft.Mashup.Storage.Local.ZipLocalStorage..ctor(Stream stream, Boolean isReadonly)
at Microsoft.Mashup.Host.Document.Storage.Local.SharedLocalStorageAccessor.LoadCachedStorage()
at Microsoft.Mashup.Host.Document.Storage.Local.SharedLocalStorageAccessor.Access()
at Microsoft.Mashup.Host.Document.Storage.Local.LocalFeatureSwitchStorage.GetFeatureSwitches()
at Microsoft.Mashup.Host.Document.Storage.TracingFeatureSwitchStorage.GetFeatureSwitches()
at Microsoft.Mashup.Host.Document.DirectQueryFeatureSwitch.LoadEnabled()
at Microsoft.Mashup.Host.Document.FeatureSwitch..ctor(Guid id, Boolean defaultValue, Boolean changeRequiresRestart)
at Microsoft.PowerBI.Client.Windows.Services.FeatureSwitchManager.RegisterKnownSwitches()
at Microsoft.PowerBI.Client.Program.<>c__DisplayClassd.<Main>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)


User ID:
d6114b00-7037-401b-beb6-743aa2931425

Session ID:
ab6febc1-02aa-42cf-b8a1-497c362cdd1f

Telemetry Enabled:
True

DPI Scale:
100%

Supported Services:
Power BI

 

 

Unable to cast object of type 'ComDataConvert' to type 'ComDataConvert'. The exception was raised by the IDataReader interface. The sync works perfectly on power bi desktop. Any help in this would be greatly appreciated.

Hello

I am trying to leverage new Power BI Service Live connection function in Power BI Desktop.

I am hoping this feature can facilitate the development and sharing of set of report pages to different groups of users.

 

I had developed a .pbix containing both dataset and a certain number of report pages.

Now I would like to segment this big .pbix in different set of reports each one to be dedicated to a specific audience according to the following strategy:

- Publish the "core" of the .pbix including The Dataset and a set of general reports

- make copies of the orginial .pbix, keep only the pages for a subset of users, delete rest of the pages, publish

- then assign these reports to different groups

 

In doing this I got in trouble when cleaning up my .pbix copies as I need to "redirect" such copies to the already published dataset if I want to avoid creating multiple dataset on the Power BI service side.

Is there any way to do this? i.e. to get rid of the tables defined in the .pbix and redirect graphics to the Power BI Service Live connection?

Or simply this is not the strategy I should follow and there is an alternative still allowing not to redraw the report pages?

Thanks in advance

I have a report embedded in a website using Power BI Embedded (ie. published to an Azure collection and presented with the Javascript client).  It uses a direct query connection to an Azure SQL database.  The report has a filter slider on a transaction date variable.  

 

The issue is the date range of the filter slider is not updating to reflect new dates that are being added to the database.  The maximum end of the slider still reflects that maximum date that was available when the report was published to the Azure collection.  A couple of weeks of newer data has been added since then.  I can see the newer data on other pages of the report which do not have date sliders on them.

 

capture1.PNG

The maximum ActivityDate available right now is 23/04/2017 rather than 12/04/2017.

 

The only way I have found to force the date range to update is to open the source PBIX file, press the refresh button, save the file, and overwrite the existing file in the Azure collection with this new one.

 

Has anyone run into this issue before?

 

Thanks,

Chris

Timeline Slicer Issue

Status: New
by maddy Frequent Visitor on ‎12-18-2016 07:21 AM

Hi,

 

Between option on dates is not working on timeline custom visual nor in timeline slicer once we import data from direct query. 

 

Regards,

Maddy

Bug in slicer displaying images horizontally

Status: New
by pmdci Member on ‎11-10-2016 03:14 PM

Adding an image URL field for a slicer works if the slicer orientation is vertical. However, if the orientation is set to horizontal, the URL of the image is shown instead of the image.

wrap column headers

Status: New
by David4F Frequent Visitor on ‎01-11-2017 08:21 AM

Hi ,

 

I was very excited when wrap column headers was introduced in the January 17 update. Then very dismayed to find once published it was not supported.

Please tell me I am missing a trick, or alternatively when I can expect it to be supported?

 

Kind Regards

 

David

Web Data Refresh Error

Status: New
by rdoughty Occasional Visitor on ‎11-15-2016 12:23 PM

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!

Thanks, Ryan.

After updating to October build#2.40.4554.463 64-bit Slicer failed to have Monthly data hierarchy. I tried with all the options of setting a new date column with only Month names and also with only date (without time information) and nothing worked. To make the slicer available in my report, I had to use a customer from https://app.powerbi.com/visuals/. 

 

Not sure if it is a bug and everyone else have similar issue?

If we have one object (e.g. a visual, text box, etc) selected, we can nudge them with the keyboard. However if we have more than one object selected, that won't work.

 

Seems like someone forgot how the ForEach loop works ;-)

 

Sharing from Groups to non pro users

Status: New
by vsagan Frequent Visitor on ‎01-19-2017 10:26 PM

As of yesterday all of our dashboards in groups which were shared directly with other non-pro users are no longer accessible by non-pro users.

 

Is this intentional?

Idea Statuses