All measures not showing up in Power BI Report Builder
I am creating Paginated Report based on PBI Dataset. I selected Dataset as Data Source, but while creating Dataset using Query Designer I get notification under "Measures" category: More Measures exist than can be shown. And many measures needed for my report are not in my measure folder. How do I access full list of measures? I tried adding them manually in querry Expression, but as soon as I add measures that don't show up in querry designer, I get this error:
Error "The Item '' cannot be found" when scheduling refresh
Hello all! we just upgraded our server to Septemeber 2022 and are running into an issue with scheduling refreshes. This is a new thing we've never done on this server before, so I'm not sure if this issue is related to the upgrade or just server set up. When trying to schedule a data refresh, we're getting an error message of "The item 'x/x' cannot be found. However, the item exists, and works. How can we fix this?
')' expected, but all () statements are closed
Hello, I am getting an error in Power BI Report Builder that I am positive I should not be getting. I'll let it speak for itself. Here is the error message: But here is the formula for "DataBar2": Can you see the problem? All four sets of parentheses have an opening and closing parenthesis, but the error message says that it expects a closing parenthesis somewhere. My question is, where does it expect the closing parenthesis, and why? Please ensure you have thoroughly read the question and passed a Captcha before responding. I don't want another extremely unhelpful response from a bot. EDIT: Here is some context: The "Percent" in the formula refers to a dataset I have named Percent. The deductible value was taken from the same cube in both my main and Percent datasets, but the percent dataset aggregates by State and Year fields while the main one also aggregates by City. The above formula is used for the City level databar. The goal is to have a report that separates the data by state and city, with the parameter being Year. I figured that by creating a new dataset that gives the deductible by year and state, I could get subtotals for each state within each year. Here's a sample of the report in design view: And here's a picture of what the report currently looks like without the databar: The far right column is supposed to show the total by state or city and year. 99,669.71 is the grand total, but 4100 is the total for the year 2005. 4100 is shown at the bottom as a total column, as shown here:
Something went wrong - Value cannot be null. Parameter name: stream error
When attempting to Edit a Report in Power BI Desktop from the Power BI Report Server, I receive the "Something went wrong - Value cannot be null. Parameter name: stream" error and the report is blank in Power BI Desktop for RS (October 2020). In addition, no connections to the data files. Feedback Type: Frown (Error) Timestamp: 2021-04-21T12:41:14.7919236Z Local Time: 2021-04-21T08:41:14.7919236-04:00 Session ID: 91ad69bd-0abc-4993-a46a-cf71a1fedc0d Release: October 2020 Product Version: 2.86.3481.0 (20.10) (x64) Stack Trace: at System.IO.StreamReader..ctor(Stream stream, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean leaveOpen) at System.IO.StreamReader..ctor(Stream stream) at Microsoft.PowerBI.Client.Windows.Services.FoldedArtifactsCacheService.GetExistingEntry(FoldedArtifactsKey key) at Microsoft.PowerBI.Client.Windows.QueryFolding.FoldedArtifactsGenerator.TryGetFoldedArtifacts(Report report, IDataModel model, String tableName, IReadOnlyDictionary`2 queryDependencyGraph, FoldedArtifacts& artifacts) at Microsoft.PowerBI.Client.Windows.QueryFolding.FoldedArtifactsGenerator.GenerateFoldedArtifactsForQueriesWithoutCache(Report report, IDataModel model, IExceptionHandler exceptionHandler, IUIHost uiHost, IPowerBIWindowService windowService) at Microsoft.PowerBI.Client.Windows.Services.FileOperationUIHandler.OpenFileInternal(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, IQueryServices queryServices, IOpenSaveUI openSaveUI, TelemetryUserActionId entryPoint, IPbixFile pbixFile, Boolean fromRecentFile) at Microsoft.PowerBI.Client.Windows.Services.FileOperationUIHandler.OpenFileFromSSRSService(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, IQueryServices queryServices, TelemetryUserActionId entryPoint, Uri reportUri, Boolean fromRecentFile) at Microsoft.PowerBI.Client.Windows.MainWindow.OpenFromSSRSService() at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_7.<<Main>b__8>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.MainWindow.<<ActivateMainWindow>b__114_1>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext() PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.86.3481.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Services.FoldedArtifactsCacheService","Error":"System.ArgumentNullException","MethodDef":"GetExistingEntry","ErrorOffset":"44"} OS Version: Microsoft Windows NT 10.0.19042.0 (x64 en-US) CLR Version: 4.7 or later [Release Number = 528372] Peak Virtual Memory: 38.6 GB Private Memory: 584 MB Peak Working Set: 702 MB IE Version: 11.789.19041.0 User ID: 98a56a36-150e-4d78-a7b4-655c1763a2c3 Workbook Package Info: 1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Model Default Mode: Empty Model Version: PowerBI_V1 Is Report V3 Models Enabled: True Enabled Preview Features: PBI_NewWebTableInference PBI_v3ModelsPreview Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_JsonTableInference PBI_ImportTextByExample PBI_ExcelTableInference PBI_qnaLiveConnect PBI_dataSearchCuration PBI_azureMapVisual PBI_dataPointLassoSelect PBI_narrativeTextBox PBI_dynamicParameters Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI Report Server, Power BIGeneric Error Message - Report Server
Hi, Need help to understand more about an error message that I receive when opening a file on Power BI Optimized version, I make sure that I do not use the Import Query, no Order-by, no CTE or any other limitations that may throw an error, but with all the precautions, I receive an error message with not very helpful details. It would be great if Power BI could guide the user with appropriate error details. Need help to understand, is there any way to get more details about an error.Scheduled Refresh Issue - [0] 0: Model can not be refreshed for files not mapped to a network share
I have just published my first reports to BI report server . One of which has 4 pages , for display purposed I have another 4 reports that are the individual pages of the first report (ie first report with pages deleted but exactly the same underlying data and design). They all run on a 3 minute schedule refresh. I have noticed that they all fail intermittently at different times and they give the following error message: "Data refresh failed. Please try again later or contact your administrator." With the information giving error details: "SessionID: 979d17a1-e778-4ba3-accb-e3f69575a904 [0] 0: Model can not be refreshed for files not mapped to a network share" What am I doing wrong / how can I rectify these. at first they were all refreshing fine but now they have become divergent and therefore all show data from different times.Named Pipes Error 40
I have a somewhat unique situation and I'm having trouble finding an answer anywhere online. So I have two servers, both Windows servers 2016. One soley a MySQL server, the other a web server. I am attempting to set up power bi report server on my web server, when I do this I get the part where I'm attempting to connect to my database. It then gives me an error that it can't connect: "Could not connect to server: A network-related or instance specific error occurred while establishing a connection to SQL Server" ... "(provider: Named Pipes Provider, error 40 - Could not open a conncetion to SQL Server)". From doing a bit of digging it 'seems' like this is what you get when you use an MSSQL query to try to connect to a MySQL database. However I have installed 'MySQL Connector Net 8.0.16' on the web server, and by default there's a 'Connector NET 8.0' on the mysql server - after installing mysql, so I assumed it wouldn't be a problem. I am new to power bi though, so I'm curious if there's something I've missed? Or some other reason I might be getting this error? *It should be noted that I am able to connect to this server using my normal methods (usually php connection strings). In addition I opened up port 1433 on both servers just in case.
Upgrading existing SSRS to PBIRS, Web Portal Error: "The service is not available."
I've spent hours researching this and to no avail. We've upgraded SQL Server 2016 to 2017 and detached the ReportServer db as part of this process. After installing SSRS v14.0.6514.11481 and pointing to the restored ReportServer db it worked perfectly. The problem came when we tried to upgrade to PBIRS. Recieved this message when navigating to the localserver/Reports portal: Checked the logs and it said: ERROR: Database downgrade detected. The database schema version is newer than service schema version. Not sure how to proceed here. Why would the db schemas be incompatible? Trying to complete this process for reference: https://docs.microsoft.com/en-us/power-bi/report-server/migrate-report-server
