We are working with our client on a Power BI project and we are facing a one issue with the Power BI currently.
The developer of the cube has created a data cube for us to use in the Power BI and we have connected to that with live data.
Now when report and all has been done, we would like to have feasible report \ dashboard in use for the future, without user always updating manually the weeks\dates in use on the visual. But this can't be achieved 'cause we are using string dates.
Well at least that was the case until the cube developer told that the dates are actually in date forman in the ssas cube already.
For some reason power bi handles those dates as a string.
We need to have a dynamic date filtering that did come available with the July 2017 power bi update with a date field in place soon. But for reason Power BI handles the date as a string....?
The developer is now going to try something like this fix, to see if we can figure this out:
Please try again later or contact support. If you contact support, please provide these details.
I have a DashBoard where I loaded 9 csv files. The sum of the sizes is 6.26GB. It means the uncompressed size.
I load this files with less data in order to publish the dashboard in my work space and I created a Data Set to load this files.
My Workspace has 9,5GB free. And when I tried to refresh the data set I got the following message:
"The received uncompressed data on the gateway client has exceeded limit."
But, how I said, the sum of the files size is 6.26GB. It's not more than 10GB.
I don't know what to do to fix this problem once I read the Power BI documentation and it shows a size limit of 10GB of uncompressed files.
Anyone can help me?
I use Power Bi with 'MS-SQL, Oracle' DBMS in company.
At this time, we got a new DBMS in 'PostgreSQL'. Fortunately,I success connect datasource and load database and doing my own job in Power BI DESKTOP. but since i tried to setting gateway service on Power BI Web portal, have big problem as below.
Step1. Connecting Power BI Web portal(app.powerbi.com)
Step2. Manage Gateways
Step3. 'Add Data Soruce' then input PostgreSQL setting parameters which exact the same as Power BI Desktop connection parameters (ex: server, database, ID, password).
Then, i got a error message as below.
in order to error message by microsoft, feedback to me, I did not install 'Npqsql'.
but i already installed 'Npqsql'.if not, definitely, it does not work in 'Power Bi Desktop' also. so i thinks this feedback is incorrect.
so i search information in Power BI Community forum. lastest NPQSQL is not supported. so i re-install NPQSQL 3.2.2.
but it does not still works..
please let me know what i have to do for solving this issue.
your advise will be very appreciated.
I had some reports connected to sql server in azure without problems, since I update gateway (version: 14.16.6390.2 ), I received this message:
Underlying error code:
Underlying error message:
The server name provided doesn't match the server name on the SQL Server SSL certificate. Please see https://go.microsoft.com/fwlink/?LinkId=394782. (Source at XXXXX;YYYYYY.)
The server name in the certificate is the same that configuration. This problem is new. Please help me. I tried change the server name for IP and it didnt work.
Also, problems is just with sql server, other sources works fine.
I created a workspace, then deployed it as a Power BI app.
Worked great, I made some adjustments, published it a few more times updating the app each time. Zero issues.
Now I went and added a few more users to the access list and went to update the app again... it goes "publishing app" spins and then errors out:
Has anyone else had this?
My other apps seem to update just fine.
I also tried deleting the workspace image file it was using, as a few other posters had mentioned that helping.
Still no good
I have a model that is using a deployed Power BI model as a data source. On one page that has (new) Matrix visuals, I see different behaviour between Power BI Desktop and the web service. On the desktop, clicking one of the Slicer members filters all four Matrix visuals properly. But on the web, clicking the same Slicer member only filters TWO of the four matrix visuals.
Screen shot is included but the resolution may be bad. On the right is the Desktop, on the left is the Service. On each, notice the first and third matrix visuals on the respective left side of the canvase.
LS, when opening my Power BI reports and when switching to different pages, I regularly get the error described below. I sent a frown and your colleague requested me to open a ticket online. Not sure what to write as a summary as I get an error message that I don't understand. My colleagues have the same issue. We do not get the error in all our power bi reports.
Note that I could not upload all error data.
Hope you can help.
Thanks and regards,
Data to send to Microsoft:
2.48.4792.721 (PBIDesktop) (x64)
Microsoft Windows NT 10.0.14393.0 (x64 es-ES)
4.6.2. or later [Release Number = 460805]
Workbook Package Info:
1* - en-GB, Query Groups: 1, fastCombine: Disabled, runBackgroundAnalysis: True.
Peak Working Set:
Peak Virtual Memory:
JS Error Message:
An error occurred while rendering the report.
at :line 0
Invocation Stack Trace:
at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3.<SendAndMarshalExceptions>b__0(Object null)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments)
at System.Delegate.DynamicInvokeImpl(Object args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String args)
Model Default Mode:
Snapshot Trace Logs:
C:\Users\florus.denblanken\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1569483217.zip
Performance Trace Logs:
C:\Users\florus.denblanken\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Disabled Preview Features:
Disabled DirectQuery Options:
I'm currenlty new on Power BI and I'm trying to connect our JIRA instance with the power BI (get-data).
This is currently working for anonymous authentication but not for basic or windows authentication. This keeps on loading(for hours +24h) and nothing happens . On the desktop app with the content pack we have the same issue. The only difference is that it goes in timeout after a while.
Do you have any idea what can be the reason?
I have a text box that is all underlined and bold.
I then take the formatting of some of the text and it is ok.
I then navigate to another tab in desktop mode and then back again and the formatting is back.
When I add a tile to a dashboard with a custom link to a report in the current workspace, the link works fine. However, when the dashboard is shared with a user who isn't a member of the workspace, the tile doesn't seem to respond at all, although the pointer changes to the hyperlink hand.
I'd expect having a custom link to a report in the current workspace would provide access to that report to users the dashboard is shared with.
I've got a Data/Time column and I'm grouping by 1 hour chunks. On the same page I have a stacked column of time vs quantity of tickets logged at that time. I also have a table that shows the details of all the tickets received in the selected hour. The hours along the axis of the bar chart go something like ' ..... 8:00, 9:00, 9:59:59, 11:00, 12:00, 12:59:59 , 2:00, 3:00, 3:59:59 .....'. For all the hours ending in :00, when the column is selected the data for the tickets displays correctly in the table below, but for the hours ending in :59, no data is displayed in the table below when you select those hours. Seems like a bug to me, unless someone knows otherwise.
As previously said, the bins are 1 hour and no other customisation is available.
I have a report which I renamed in the online service. I then downloaded the report added a change, but when I reuploaded it instead of overwriting the old one it created a new instance and becasue of that doesnt allow me to update the content pacl.
I have a mapping table that has two values
When joining to my fact table, I am getting the error that there "unique values are required in one table. Once I remove the "GREEN " row then the join works.
Power BI seems to be dropping the " " when I try to join. My data type is set to ABC and I see the space in the query editor. Please fix this issue.
I m trying to schedule data refresh for a data-set that uses Salesforce and Excel using On-premises gateway.
While I m able to configure the same using the latest gateway(Personal Mode), the option to select on-premises data gateway is disabled.(It is running fine on a different local machine and I have configured other data sources for refresh)
Salesforce prompts for authentication using OAuth2 while Windows Authentication is enabled for Excel.
* Does on-premises gateway (July 2017 update) support Salesforce?
* I m fine changing excel to a different data source like Azure SQL DB/ SQLS erver if necessary. But is there a work around that I can use that would enable me to use on-premises gateway instead of personal gateway.
* I have also come across articles that mention lack of support for salesforce/ OAuth2 with other Data Sources. If it has anything to do with the feature implementation on on-premises gateway, it would be nice if someone from microsoft can comment on any plans regarding when the support for salesforce can be expected.
I have streaming dataset as a sink output of an ASA job. Occasionaly I get similar send errors like shown below in the ASA job.
"Message": "There was a problem sending data to Power BI. The following information may be helpful diagnosing the issue. Power BI ReferenceId: 50472c19-4d3d-4079-bb82-1480005acedd. PushDataAsync error [An error occurred while sending the request.] with request Id [50472c19-4d3d-4079-bb82-1480005acedd]. Error encountered after writing  batches. Error - An error occurred while sending the request.\r\n- The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.\r\n- Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.\r\n- An existing connection was forcibly closed by the remote host\r\n",
I've submitted a support ticket (REG:117021715339692) to the ASA team and the conclusion is that this is caused by some internal Power Bi activities. Is it possible to get rid of these errors as it's triggering nuisance alerts?
A really small bug. When you right click on a view or table the menu load/edit pops up but it hides the Navigator pane. See video voor reproducing the bug.