Issues - Page 193

Funkmiester · ‎01-13-2017

NIGHTMARE! I am building a couple of dashboards in desktop, done 60Hrs this week alone. Working fine yestereday- all use excel files and tables as data sources Today- Update inside windows 10 insiderPro build 15002 this morning Update to Jan 2017 PowerBI Now every dash won't update with the message DataFormat.Error: The input couldn't be recognized as a valid Excel document. Every file opens fine in excel not corrupted, even tried with new data, same message I've rolled back to an earlier Power BI but get the same error, any other ideas welcome. Is there a setting in the build 15002 that doesn't recognise excel files as excel files???

AGo · ‎01-13-2017

As you can see the last measure that which should be 0.00 results 7.11E-15. This measure performs a simple subtraction [measure1]-[measure2] and all the measure in my report are formatted with 2 decimal numbers. The datasource contains only multiple numbers of 0.25. The other problem is that under the yellow bar I can see 0.00, but there should be another equal one under this, and so also under the orange one.

Anonymous · ‎01-12-2017

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?

bogomda · ‎01-12-2017

Hello, in Power BI Desktop (Version: 2.41.4581.361 32-bit (November 2016)) I want to connect to an Oracle data base via ODBC. I do have an ODBC data source set up, which so far worked fine in application MS Access 2016 and MS Excel 2016. In Power BI, however, I get an error. At first the connection seems to wok fine, I get a list of all tables in the data base as expected. But when I try to load a table, the following error message comes up: DataSource.Error: ODBC: ERROR [07006] [Oracle][ODBC]Restricted data type attribute violation. Details: DataSourceKind=Odbc DataSourcePath=dsn=LAWRPT90 OdbcErrors=Table However, if in settings in SQL statement optional field I put something like SELECT * FROM TABLE_NAME I can access specific table. This could be a workaround for me but it’s very inconvenient approach I have same issue connecting in Power Query or Power Pivot in Excel 2016. Is there a way to fix this problem? Thanks, Danil

OBaldan · ‎01-11-2017

I'm using a line chart and want to set both axes in log scale. It works when I only add data to Axis and Values, but once I add data to the Legend, the Y-axis can only be set to linear.

tommy-olsen · ‎01-11-2017

I have recently renamed the group where some of my reports and datasets are placed. After this it seems that I can't upload any of my PBIX files to the group anymore even though it seems to register the original dataset, but even after 1½ hour it was still just "Publishing your file". Can this really be true?

ImkeF · ‎01-10-2017

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/101778#M46005 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 !!!

BraneyBI · ‎01-09-2017

In the November release, Power BI Desktop is creating "Both" (bi-directional) relationships when a single fact table is detected in the data model. The default should always be "Single" due to performance issues (and has been for several months). Most modelers do not fully recognize the impacts that bi-directional relationships can have on a Data Model.

MichielvS · ‎01-06-2017

A join between two datasets in a report seems to dissapear after I refresh one of the two datasets. When I try to reconnect them by either the Merge Queries button in the Query Editor or manually in the Relationships view, Power BI does not seem to respond. Joining again then is not possible. Any ideas on where the problem could be and how to solve this?

JamesYuan · ‎01-05-2017

Recently, I built a report to show [HH.MM] data label in Chart bar, found some bars data is incorrect with data source. For example, one of value is 7.23 from data source, however, it shows 7.299999996 in data label. I've checked backend and confirm the definition of the data column, even in dataset the data and column definition only show 2 decimals, but data lable is wrong for some bars. Changing column definition to show 1 decimal, the wrong lable jump to another bar which is very interesting. Here is an example: After contacting support, they gave me an workaround to change data label property to configure "decimal" value from Auto to 2, and it shows correctly then. However, why it picked up a wrong data from data source is a problem. Post the issue here and hope it will help others to fix the similar issue.

Gopalakrishnan · ‎01-05-2017

I m having table from Azure SQL DB for listing user's name and status like Ok,Alert,Danger.Also i just want to list the user's name and status only if their status was "Alert" or "Danger",for this in "Basic Filtering" i m having a filter condition "is not Ok".So the table only lists the user name and status only if its other than Ok and its working fine.But if the returning table contains only "Ok" as status then the Table visual not getting updated and other visuals in my report properly updated. Is visual wont update if the filtering fails.?

mnelson16 · ‎01-02-2017

I have a SSAS Tabular model with multiple perspectives on a single table where not all measures are included in each perspective. The measures are grouped together using Display Folders. When connecting in PowerBI to SSAS Tabular model and selecting one of the perspectives, empty Display Folders appear in the field list even when the measures are not included in the perspective. Same result when tested against both 1103 & 1200 compatible models Connecting to the same perspective in Excel, the display folders with excluded measures do not appear in the field list.

Kiran_Holi · ‎01-02-2017

Hi, We are integrating new powerbi embedded azure service in our web application. The usecase is to embed power bi dashboard/reports and customize them into web application and data source choosen is google analytics. I have created POC of it and able to embed dashboard/reports and its working fine. The problem that I see is Data refreshment Issue for embedded reports/dashboard in the web application and also there is no Auto refresh configuration option exists, means if some data is updated in my google analytics account, those changes are not refelected in embedded reports and dashboard in web application until I do the data refersh manually(recreate a pbix and re-import it to workspace). Is this Problem solved? I dont see even Schedule refresh option for newly launched powerbi embedded azure service. Thanks, Kiran

Yulius · ‎01-01-2017

Why do I create a new column in Project Online (Project Site), does not appear in the power bi? anyone can help me? Thanks

ColinE711 · ‎12-28-2016

The SWITCH command is failing when being used with more than 10 levels in DirectQuery. I sent a frown and received a response, so I'm guessing it's in the ICM, but I'd like to know status since all queries I have using SWITCH commands fail given more than 10 options.

wynhopkins · ‎12-21-2016

When using the Combine Binaries functioanlity, if you add a Duplicate Columns step to the Transform Sample Binary query then the output fails. Note, this also happens if you add a custom function manually.

Anonymous · ‎12-19-2016

Hi, I have a report with a Date/Time TimeZone field set to En-AU. When I refresh data on PowerBI Desktop I get the correct local time but when a scheduled refresh takes place, the report shows UTC time instead of local. Is there any way that I can fix this? Thanks

mauropasi · ‎12-16-2016

I have a report that works like a charm in the desktop application but fails in the service. I am appending two large tables with monthly data and the result in the service is some data from the last day of the first month. I am assuming the operation times out or something like that.

vitaly · ‎12-13-2016

Our data model has fairly long tables names. Many windows in Power BI Desktop have limited real estate and thus truncate these table names. Because names often have the same prefix it's impossible to tell which table the selection applies to. Example: Manage Relationships and Manage Roles windows. These windows have fixed external size and the internal panes also cannot be resized. So we are stuck with truncated table names. Please allow external and/or internal resizing.

Willgart · ‎12-13-2016

Hi, I have created a Power BI Model using Power BI Desktop in Direct query mode. I upload it to Power BI web, everything is working. Now my users dislike the performance of the direct query model. So I change the model to in memory mode, publish it. Everything is working... except the GUI to setup the automated refresh and the connection to my gateway. So I cant refresh my model from the power bi web site. and I cannot delete it, because I have online reports connected to this model. If I drop it, I'll drop the reports too, and I cant do it for now. so how I can get the options to refresh my model? Thanks.

Share your ideas and vote for future features

Jan Update and Build 15002:DataFormat.Error: The input couldn't be recognized as a valid Excel docum

Error on simple subtract measure

SAP BW Data Load Performance and Limitation Issues

DataSource.Error: ODBC: ERROR [07006] [Oracle][ODBC]Restricted data type attribute violation

Bug - Log scale for line charts

Publishing after renaming the group doesn't seem to work

Bug in "Don't include in Report Refresh"

Automatic Relationships are creating "Both" relationships

Join fails after refresh

Data Labels length in chart

Table not updating if filter condition fails

SSAS Tabular perspective showing Display Folder with no measures that should be excluded

PowerBI Embedded Azure Service

Unable to load the data in Power BI use Odata (Project Online)

SWITCH command failing

Combine Binaries - Adding Duplicate Column step causes process to fail

PowerBI web not showing local time

Table.Combine failing to append two large tables in the service

Truncated table names in Power BI Desktop

Updating a model from direct query to in memory did not allow me to schedule a refresh

Helpful resources

PowerBi consistently crashes when chosing Quick Me...

Bug in quick filter in PBI Desktop

Something went wrong endless loop

Unable to create new dataflows Power BI GCC tenant

Power BI Embedded with DirectLake Dataset Error