New Idea

I seem to be having issues with the recent Power BI update (December 2017), whereby when invlaid relationships are trying to be established between two tables Power BI exits with no warning.

Data Source Credentials Not Updating

Status: Needs Info
by Topgunz786123 Occasional Visitor on ‎12-07-2017 12:31 PM

All of a sudden all of my automatic refreshes have been failing due a message "Your data source can't be refreshed because the credentials are invalid." Nothing has changed and I don't know why I am receiving this message. 

 

I click on Edit Credentials (Salesforce credentials) and unable to do so because now I'm receiving this message "Failed to update data source credentials: We're sorry, an error occurred during evaluation".

 

This was all working fine a couple of days ago and yesterday, I started running into the refresh issue. I have deleted my cache, cookies, etc. but I am unable to edit my Salesforce creditials.

 

Anyone have any ideas / thoughts?

 

Thank you!

 

 

Status: Needs Info

When I try to access the Relationships view of any dataset, I get this error message:

"Unhandled exception has occured in a component in your application.  If you click Continue, the application will ignore this error and attempt to continue.  The type initializer for 'System.Windows.Interop.OSVersionHelper' threw an exception."

 

After clicking continue or after just closing out of the error window, there are no further errors, but the Relationship view shows up as a blank page, showing none of the tables that I have imported. 

 

I tried uninstalling and reinstalling PowerBI and restarting my whole computer, but it did not help.  Suggestions for fixing this are most welcome!

 

 

Status: Needs Info

Relationship Display is not saving changes

Status: Needs Info
by DQuigg Frequent Visitor on ‎11-14-2017 11:11 AM

Is the relationships display in Desktop supposed to save the current position.  In other words, if I drag the hierarchy the way that I want, isn't it supposed to save it?  I seem to get constant issues where I clean up the display only to come back in and it is all hosed up.  Sometimes it seems to save it properly.  What am I missing? I had the one below all nicely laid out and then come back in later and it is all messed up per below.

 

Relationship Display.PNG

Status: Needs Info

Query Editor Window Bug

Status: Accepted
by jameslo30 Member on ‎10-16-2017 02:08 AM

Bug in PowerBI Desktop Version: 2.51.4885.701 64-bit (October 2017)

 

When you single click a query in the "Queries" selector on the left hand side, it thinks you want to move the query up or down to re-order.

This did not happen in the previous version.

 

Issue.png

Status: Accepted

Hey,

I'm getting the following error when using a variable and logical operator in a column (using direct query). 

 

"An unexpected error occurred (file 'tmmdmodeltm.cpp', line 5980, function 'MDModelTM::GenBaseTableQuery')."

 

DAX formula

createdChanged = var x = DATEDIFF(xxxxxx[createdDate];xxxxxx[changedDate];DAY) return if(x>1000;0;x)

 

This formula works fine in Import mode. Tried several scenarios, but it seems the error is thrown when the variable is used as part of the logical test (e.g. this works: createdChanged = var x = DATEDIFF(xxxxxx[createdDate];xxxxxx[changedDate];DAY) return if(1=1;x;1)

 

Any thoughts?

 

Cheers

Status: Accepted

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

Copy table malfunction

Status: Accepted
by szilardsz Frequent Visitor on ‎10-20-2017 02:38 AM

Hello all,

 

I think I found an issue in the to-date latest Power BI Desktop. The "Copy table" function works no more in Data view

in my environment after the latest update. Sometimes it throws an error like that:

 

PBI copytable issue.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Anybody else experiencing this problem?

 

thanks,

Sz.

Status: Accepted

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

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.

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

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?

I reset my O365 password yesterday and now my Power BI SharePoint connection won't refresh because there is nowhere to enter the new credentials. This support article says that the credentials must be updated when getting this error message but doesn't say how. I tried the OAuth2 connection method mentioned in similar posts, but it doesn't work. Here is the error:

 

temp.png 

 

Can someone please tell me how to update my credentials in Power BI for my Office 365 SharePoint connection?

Bug in "Don't include in Report Refresh"

Status: Delivered
by ImkeF Super Contributor on ‎01-10-2017 07:58 AM

There's a bug in "Don't include in report refresh" like described here: http://community.powerbi.com/t5/Desktop/Disabling-quot-Include-in-Report-Refresh-quot-works/m-p/1017...

unfortunately I didn't test correctly and this thread is closed, but the bug is still there and preventing solutions for problems like this:

http://community.powerbi.com/t5/Desktop/Big-file-needs-no-update/m-p/111341#U111341

 

If the query that shall not be refreshed is not referenced by any other query or part of a UNION-operation in DAX, then everything works fine, but if it is referenced as mentioned, then it will be loaded again.

A lot of the usecases for this features are of this kind, so this bugfix is really needed !!!

Status: Delivered

Bug: Section1 results not loaded to data model

Status: Accepted
by ImkeF Super Contributor on ‎08-03-2017 10:54 AM

The result of: Record.ToTable(#sections[Section1]) are returned correctly in the query editor, but not loaded to the data model. There, only the value of the current query will be returned.

 

In Excel, this works fine, so both results are the same: A table with all queries in the current file.

Status: Accepted

When we run PowerBI Version: 2.46.4732.581 64-bit (May 2017) and connect to a SAP Hana 2.0 everything works fine and you can see the Calculation Views listed in the Navigator.

 

When we run the latest download July it can connect to a Hana 2.0 database but we do not see the list of Calculation views in the Navigator.

 

Both builds are fine for Hana 1.x databases.

Using Hana 2.0 64 bit ODBC driver.

Status: Accepted

When in Power Query (Get Data), you can double click on a column heading and then rename the column.  If the column has a null value (eg the null string ""), then you cannot double click on the column to edit.  Instead you must right click on the column and select rename.  This is inconsistent with the way it otherwise works and I think it should be "fixed" so it works the same.  Double click on an unnamed column should allow you to edit the column name.

 

I have provided a sample query that you can use to validate.  This query will not allow you to double click on the first column.


Matt

 

 

// Table 2
let
Source = Web.Page(Web.Contents("http://www.abs.gov.au/ausstats/abs@.nsf/Lookup/by%20Subject/1301.0~2012~Main%20Features~Population%2...")),
Data2 = Source{2}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data2,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}}),
#"Removed Top Rows" = Table.Skip(#"Changed Type",1),
#"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"", type text}, {"NSW", type text}, {"Vic.", type text}, {"Qld", type text}, {"SA", type text}, {"WA", type text}, {"Tas.", type text}, {"NT", type text}, {"ACT", type text}, {"Aust.(c)", type text}}),
#"Removed Bottom Rows" = Table.RemoveLastN(#"Changed Type1",4),
#"Removed Top Rows1" = Table.Skip(#"Removed Bottom Rows",1)
in
#"Removed Top Rows1"

Status: Accepted

We have an issue that our PBI file works fine but when row level security is turned on we get error messages. 

 

We have tracked it down to a caculate measure. When row level security is off this measure works fine  - 

 

CALCULATE (sum(UnitSalesValues[Sale Values]), 'UnitSalesValues'[Attribute]= "Sold prior to qtr" )

 

When row level security is turned on this measure creates the following error is the visual. If the bolded part is taken out the measure works fine. 

 

Colukn't load the data for the visal

An unexpected exception occured. 

 

This same file was working with last months version of PBI. The data in UnitSalesValues is visable with the row level security turned on and has values for "sold prior to qtr". 

 

However, even if we use last months pbix file it does not work in the PBI Embeded enviroment. 

 

This certainly seems to be an error in PBI. Further when the row level security is first turned on a black screen apears and the following program is run. 

 

c:\Program Files\Microsoft Power BI Desktop\bin\SQLDUMPER.EXE

 

 

Status: Accepted

Grouping stuck after changes

Status: Needs Info
by Barslund Regular Visitor on ‎09-12-2017 05:42 AM

Hi,

 

I'm experiencing issues when grouping a large amount of catagorical labels per edit, when using the build in grouping functionality released in the October 2016 release.

 

 

When I exceed a given amount of labels grouped in "one go", when finalizing and clicking "Ok" the "Working on it..." will appear, but be stuck. I'm unable to exit the process and the only way to gain control of the program again is by exiting the program completely from windows task manager.

 

If I instead group a few items at a time, everything works fine, but working like that would significantly increase my work time.

 

Suggestions to why this happens and how to avoid it, besides being a problem with the desktop client?

 

 

Status: Needs Info

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