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?
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:
- Create a report and publish it to a group
- Create a dashboard for the report and share it with a user who is not a Pro user yet
- Have your user sign up for the Power BI Pro Trial
- User will get "Sorry, we couldn't find that report" error
- After your user signs up for a Power BI Pro Trial (step 3 in the above), go to your dashboard and click "Cancel Invite"
- 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.
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
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
I am struggling to get a pubnub stream working . I have data and can see it from a HTTP request in my chrome
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"
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
Published link (web) - Dark grey & black -> wrong
How can i solve this? Even better, when will we all be able to set colors for background and foreground (selected slices)?
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.
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.
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]., [0FISCYEAR].[K12016])
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]., [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.
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.
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 ? ?
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.
2.46.4732.721 (PBIDesktop) (x64)
Microsoft Windows NT 10.0.15063.0 (x64 pt-PT)
4.6.2. or later [Release Number = 460798]
Workbook Package Info:
Peak Working Set:
Peak Virtual Memory:
Arithmetic operation resulted in an overflow.
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 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.FeatureSwitch..ctor(Guid id, Boolean defaultValue, Boolean changeRequiresRestart)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
Invocation Stack Trace:
at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
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)
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.
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
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.
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?
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?
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!
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 ;-)