I want to be able to pick a color palette for the pie chart, tree map, and donut chart that can be defined for the size of value grouped by tenant. For example, in a multi tenant environment with row level security I want to be able to give the tenants all the same experience. See image below. Red is what exists today and Green is what I want... Thank you   ... View more

I've been sharing the same report with a few dozen users for most of this year.  This last week is the first time I'm seeing this issue.   One of the table views typically will refresh as a user engages a slicer elsewhere on the page.  However, as of this last week, in the scenario where the resulting table is null (i.e. there are no resulting records under the newly selected filter context), instead of displaying an empty table as expected, the table just stays as-is (i.e. doesn't refresh).   We don't see any issue in the scenario where the resulting table is NOT empty... it refreshes properly in this case.   I don't see this issue in my Power BI Desktop version of the model, it only occurs when folks are browsing the report via the Power BI cloud service.   I stumbled across a workaround to get it to refresh... I notice that when I switch to a different report page, and then come back to the page with this issue, the tables will then be refreshed properly to show an empty table as expected.  Although this is not a good workaround since it can be cumbersome to jump back and forther between tabs simply to refresh a table.   Thanks. Jason ... View more

I am getting the below error when conneting through a end user account.  "ole db or odbc error type mismatch exception from hresult 0x80020005 disp_e_typemismatch" I tried out the same view using admin privileges, which worked very well. But with a user account it transformed decimal columns in to an identified format. Transformation is as follows. Actual Value SAP View is 11,3000,4500.2345 this but query editor shows this as 11.3000.4500.2345. All commas for thousands have been transformed to ".". Any idea why? Is it problem with the connector or problem in the SAP side or problem in the query editor? ... View more

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! ... View more

After recently deploying to report server, I am encountering what appears to be intermittent errors in some of the visuals on report using the same SSAS model. The error message can vary from 3 forms:   the most common one is: "Couldn't load the data for this visual.  An unexpected exception occurred. Please try again later or contact support. If you contact support, please provide these details".    The second is "Couldn't load the data for this visual. Memory error: Allocation failure. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine."   The third message is "Couldn't load the data for this visual. OleDB or ODBC error: The multi-part ientifier "xxx (it varies)" could not be bound; 42S22."   Server is 64 bits, with 32Gb of RAM and memory doesn't look like an issue. The report works fine, but all of a sudden, one object will fail, and from that point on, it appears to be totally intermittent. The same data will display correctly, then fail. The only thing that I can seem to isolate as a factor is that this happens only for that one SSAS model.   Report Server version is Version 14.0.600.301 (June 2017) ... View more

Is there a way to update w/ new data (only) during Refresh, so the loading wouldn't take so long? ... View more

When I publish a report using custom visuals on Power BI Report Server, these visuals are shown as an 404 error when I navigate using Android or iOS PowerBI App. If I navigate using the web portal, all runs normally.   Steps to reproduce: I updated to the last version (server and desktop) and created a sample report using three different custom visuals: - Chord  - Heatmap - Dual KPI Results on Mobile: Only Dual KPI custom worked   ... View more

Greetings,    I'm having trouble loading my report measures when using DirectQuery for SAP BW on Power BI cloud service. Here is the error message: "Couldn't load the data for this visual   MdxScript(Model) (5, 42) Cannot find data source '' in function 'EXTERNALEXPRESSION'. Please try again later or contact support. If you contact support, please provide these details.   Activity IDba46f5a8-2e0e-40a5-99c8-3849f2baaaab Request IDec00dc39-9f95-5c3c-e6ee-5e4e95fb06aa Correlation ID0c939e55-b820-03e1-3024-c14d1d51cb13 Version13.0.1781.239" Some facts:  - I'm loading dimensions and measures (key figures) from Bex Query perfectly well in Power BI Desktop; - The issue happens only with Measures on the Power Bi Service after publishing the report; - Dimensions and Hierarchies are loading seamlessly on Power BI service;   - The Data Gateway is up and running; - I've tried to convert the measures into currency format but to no avail; - "Send a Frown (Error)" is not available in the error message window to report the technical issue; Has anyone run into the same problem using DirectQuery (beta) and Data Gateway connecting to a Bex Query? (SAP BW) Thanks!  ... View more

When you try to set the report description on a Power BI Report in Power BI Report Server you get an error.  This only happens for Power BI Reports.   Here is the relevant error in the log file:   2017-06-29 11:51:00.7799|INFO|190|Received request [REDACTED] POST http://localhost/powerbi/api/reportproperties| RequestID = s_b6852949-333d-4f8d-8d0c-1804b80af583 2017-06-29 11:51:00.7799|ERROR|190|Failure in reportproperties| RequestID = s_b6852949-333d-4f8d-8d0c-1804b80af583 System.IO.FileFormatException: Archive file cannot be size 0. at MS.Internal.IO.Zip.ZipArchive.OpenOnStream(Stream stream, FileMode mode, FileAccess access, Boolean streaming) 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.PowerBI.Packaging.PowerBIPackager.Open(Stream storageStream, Boolean& requiresConversionToReportLayout, Byte[]& securityBindings, Boolean skipValidation) at Microsoft.PowerBI.ReportServer.WebApi.PBIX.PbixShredder.<Shred>d__2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<GetReportProperties>d__1d.MoveNext() 2017-06-29 11:51:00.7799|ERROR|190|Unhandled error in the Web API|POST http://localhost/powerbi/api/reportproperties - Response Unknown| RequestID = s_b6852949-333d-4f8d-8d0c-1804b80af583 System.IO.FileFormatException: Archive file cannot be size 0. at MS.Internal.IO.Zip.ZipArchive.OpenOnStream(Stream stream, FileMode mode, FileAccess access, Boolean streaming) 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.PowerBI.Packaging.PowerBIPackager.Open(Stream storageStream, Boolean& requiresConversionToReportLayout, Byte[]& securityBindings, Boolean skipValidation) at Microsoft.PowerBI.ReportServer.WebApi.PBIX.PbixShredder.<Shred>d__2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<GetReportProperties>d__1d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__3`1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext() 2017-06-29 11:51:00.7799|INFO|167|Sending response. Response code EXCHANGE\powerbisrvcacct 500, Elapsed time 0:00:00.0034201| RequestID = s_b6852949-333d-4f8d-8d0c-1804b80af583     ... View more