After instalation of PBI Desktop update (March) I am not ableto open any PBI file (even new blank one). I tried to repair PBI desktop via Control PAnel, reinstall back to rpevious verison, change x64 bit to x32 bit version, but nothing worked.
Error messages varies based on PBI file that i am trying to open, below is one of the error logs that PBI shown me after PBI failed. Sometimes is error message only announcement that PBIDesktop is not able to load data modle and nothing else (what is kinda strange when this error message appear during opening of blank PBI file...
2.56.5023.942 (PBIDesktop) (x64)
Couldn't load the model schema.
Microsoft Windows NT 10.0.16299.0 (x64 en-US)
4.7 or later [Release Number = 461308]
Peak Virtual Memory:
Peak Working Set:
Workbook Package Info:
1* - en-US, Query Groups: 5, fastCombine: Enabled, runBackgroundAnalysis: True.
Model Default Mode:
Snapshot Trace Logs:
C:\Users\v-pavsch\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot360440546.zip
Performance Trace Logs:
C:\Users\v-pavsch\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Disabled Preview Features:
Disabled DirectQuery Options:
For example Language = Nederlands
Edit option is missing with 100% Zoom Level
This is actually hiding underneath, when the zoom level is 90% it shows up
This is happening with lot of languages.
This is becoming a very big pain point for me.... It is crucial that my colors stay consistent throughout my report, However, the colors will change in the service!!
Below image shows what I have set in Desktop.
Below shows what is in the Service. Even when I try to re-publish my desktop report. The colors won't match. I have to completely delete the report from my service, then publish. And even then it only lasts a day before the colors are changed.
You will notice, it is all the same colors in both charts.... However, they are just taking different priorities.... In Desktop, I have the magenta line as top priority, but in the Service, it doesn't follow that.
Please, please, please fix this. There are so many threads about this, that have supposedly been resolved, but the issue is not resolved.
I have noticed that report usage metrics is not appearing for newly created reports. Reports that are created last couple of weeks does not show up when connecting to the Report usage metrics model.
Metrics for "old" reports still generate statistics but nothing from all the new reports!
There have been a similar issue a couple of months back and before new year which was fixed in February according to some other issue that was posted here but it now seems to be happening again.
This does not seem to be same issue as is posted under the Support page since it states that usage data is complete after 2/7!
Tenant is located in North Europe in my case.
Power BI usage metrics for reports are missing data from 1/19 to 2/7. As a workaround, the Power BI audit logs can be used to determine report usage during this period of time. Usage data for reports is complete before 1/19 and after 2/7. Usage metrics for dashboards is unaffected.
I've been using Power BI desktop for visulaization of data in scatter plot. the problem is, the data I have is in million and billions of entries. so while visualizing it over the scatter plot, the bubbles of scatter plot often overlaps because of thier size even when the size is set to 0. is there any way to squeeze the size of the bubble more even it looks like a simple dot. so that the visualization can be a bit understandable and demonstrable? Thank you.
Hello, Im unable to refresh one of my reports, the gateway is ok, and in power BI destkop refreshes properly. can you help me out, I get this message:
Last refresh failed: Thu Jan 11 2018 16:29:15 GMT+0100 (Romance Standard Time)
Cancellation occurred when sending or receiving a request
I created a report in the desktop application a couple of weeks ago which used the OKViz Smart Filter. Everything worked great and I published the report online. Now, the filter does not work in the desktop application and only works online in report mode. Does anyone else have this issue? Is it a limitation with the OKViz Smart Filter? Thanks for the help!
Since the latest PBI service update the Chiclet visual is not working within published reports. The issue has been raised in the Community forum but yet to be resolved:
From initial testig this is what we have found:
- various versions of the visual work within PBI Desktop (also variety of versions) but whenever published doesn't work as it should
- when published online the visual doesn't refresh the other affected visuals (instead it either does nothing, displays the wrong information, or requires a different visual to be clicked before it is refreshed)
- only under one circumstance were we able to get it published correctly (that was to an account we created years ago in O365 - all other accounts, including new accounts created in O365 today, fail to load the visual properly)
- the visual works fine within the Windows 10 PBI App
- the issue (that we have kown about) has been ongoing for the past few days - corresponding with the latets PBI Service update
Any help would be much appreciated as we have over 50+ reports using this visual and it's quite an embarassing to have to explain to users/customers we're not sure why or when the issue can be fixed.
When loading the app.powerbi.com page we are getting 500 errors for multiple http calls
Below you can find the console log from chrome debugger0
(index):163 GET https://wabi-north-europe-redirect.analysis.windows.net/powerbi/metadata/app 500 (Internal Server Error)
doInitialMetadataLoad @ (index):163
(anonymous) @ (index):163
web.bundle.min.js:26 GET https://wabi-north-europe-redirect.analysis.windows.net/metadata/notifications/summary?take=100 500 (Internal Server Error)
In November 2017, we created and published a data model combining Odata feeds and excel files stored on a shared drive. The different sources are merged in the query editor.
After publishing the model, we were able to select the on premise data gateway to schedule refreshes of the model.
After the latest update of the Power BI gateway (End of January 2018) the scheduled refresh stopped working and we were not able to select the gateway anymore.
When we upload a model with all the sources but without merging them, the gateway works fine.
Anyone encountering the same issue or having any feedback?
I posted this in the Desktop forum but the issues forum seems more appropriate.
Is there a bug in the bookmark feature?
I have set a Bookmark to a page with none of the slicers selected. If I then select both slicers and click on the bookmark, only one of them clears.
I have then tried changing the bookmark. This time the bookmark is created with both slicers selected. If de-select and then click on the bookmark, both slicers are selected (as they should).
So it is inconsistent, right? Can aynone reproduce this?
I ran up a few on-premises gateways to test the new clustering functionality. While testing I reconfigured these gateways a few times which resulted in the creation of 2 gateway clusters being listed in the PowerBI Service. Once I was happy with the options I explored, I joined the servers to a single gateway cluster. When I attempted to click on the ellipsis and select "Remove" to delete the unwanted gateway cluster that now had no gateways configured.
I received the following error:
We could not remove this gateway because it is the primary gateway within a cluster that has other
gateway instances. Please remove other gateway instances from this cluster before removing the
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: cdd6df13-c757-1c0a-a0e6-2e3bf002d8de Request ID: fcb39f98-2bbb-8de6-a6a6-32f8637cff6a Correlation ID: 45443bdb-551f-51ed-c621-71ca973a24fe Status code: 400 ecsCorrelationId: cdd6df13-c757-1c0a-a0e6-2e3bf002d8de Time: Thu Jan 04 2018 13:00:33 GMT+1100 (AUS Eastern Daylight Time) Version: 13.0.3495.303 Cluster URI: https://wabi-australia-southeast-redirect.analysis.windows.net
Followed by :
Not all gateway instance within this cluster are connected. Please find more details below about
specific errors for each gateway instance.Hide details Activity ID: cdd6df13-c757-1c0a-a0e6-2e3bf002d8de Request ID: 0f7bc62c-d442-8368-a95f-23d736052f3b Cluster URI: https://wabi-australia-southeast-redirect.analysis.windows.net Status code: Time: Thu Jan 04 2018 12:31:20 GMT+1100 (AUS Eastern Daylight Time) Version: 13.0.3495.303 Test Gateway Node 2:
Gateway on endpoint '<ii>sb://wabi-australia-southeast-relay34.servicebus.windows.net/
3a25589f-aeef-49ab-b481-0b237f407d96/</ii>' is unreachable. Test Environment:
Gateway on endpoint '<ii>sb://wabi-australia-southeast-relay22.servicebus.windows.net/
0755b3d2-c4de-40b7-a189-88dccefad1a4/</ii>' is unreachable.
I expect there are a few scenarios where you would need to remove existing gateway clusters when the servers are no longer configured or available.
after the last Power BI Update we are facing some issues with our Direct Query reports based on SAP HANA.
It seems that after the last Update the query execution plan create SQL query with wrong syntax every time we interact with a slicer on a report.
We analyzed the On-Premise Data Gateway logs and we found that SQL query like these raise errors:
SELECT "t4"."Esercizio Sales" AS "c96","t4"."Data Sales" AS "c97","t4"."Mese Sales" AS "c98"
(select "DueYear" as "Esercizio Sales",
"C1" as "Data Sales",
"DueMonth" as "Mese Sales",
"DueWeek" as "Settimana Sales"
cast("DueDate" as DATE) as "C1"
group by "DueYear",
) as "ITBL"
where "C1" >= date'20120101' and "C1" <= date'20181231')
"t4"."Esercizio Sales" = '2017'
GROUP BY "t4"."Esercizio Sales","t4"."Data Sales","t4"."Mese Sales"
AS "basetable0"INNER JOIN
(SELECT '2017' AS "c96",'10' AS "c98" ) UNION ALL
(SELECT '2017' AS "c96",'11' AS "c98" ) UNION ALL
(SELECT '2017' AS "c96",'12' AS "c98" ) UNION ALL
(SELECT '2017' AS "c96",'01' AS "c98" ) UNION ALL
(SELECT '2017' AS "c96",'02' AS "c98" ) UNION ALL
(SELECT '2017' AS "c96",'03' AS "c98" ) UNION ALL
(SELECT '2017' AS "c96",'04' AS "c98" ) UNION ALL
(SELECT '2017' AS "c96",'05' AS "c98" ) UNION ALL
(SELECT '2017' AS "c96",'06' AS "c98" ) UNION ALL
(SELECT '2017' AS "c96",'07' AS "c98" ) UNION ALL
(SELECT '2017' AS "c96",'08' AS "c98" ) UNION ALL
(SELECT '2017' AS "c96",'09' AS "c98" )
AS "semijoin1" ON
("semijoin1"."c96" = "basetable0"."c96" OR "semijoin1"."c96" IS NULL AND "basetable0"."c96" IS NULL)
("semijoin1"."c98" = "basetable0"."c98" OR "semijoin1"."c98" IS NULL AND "basetable0"."c98" IS NULL)
GROUP BY "basetable0"."c97","basetable0"."c98"
the error occurs at the highlighted statement and seems related to the SELECT statement without FROM clause created by THE Power BI engine which SAP HANA cannot manage.
We are facing the same issue in Power BI Desktop
How is it possible?
This morning we have experienced issues with reports in the online service and embedded, the data is not returning the correct results from the DB (directquery), e.g. if i open the report in the desktop client, i see the correct data, when I run the embedded or online version it returns no data or very little data.
In a Power BI embedded (via azure workspace) I get the following error on some visuals:
"Custom visuals have been disabled for your organization"
The visuals are not custom visuals from the custom visual gallery but very simple standard visuals, for example a standard Card visual to display a string, referring to a measure with a simple IF statement to choose between two strings.
A common element to all the places where I see this bug is the use of IF statement in the measure that is displayed in the visual.
In all cases the visual is a simple Card.
I have done a routine check of the datasets within our Premium EM1 Capacity and found a small number of reports (within the same App Workspace), have not been refreshed, some have.
The error is:
Processing error: You have reached the maximum allowable memory allocation for your tier. Consider upgrading to a tier with more available Memory.
This is a little striking, has anybody else seen this issue? We have an extremely small number of reports utilising EM1 Premium, with average to little usage (development phase), yet we have exceeded 80% memory thrashing 8 times in the last 7 days.
Are the particular reports failing at fault here, or have their refreshes arbitrarily been chosen to pause?
in latest version of PowerBi Desktop (Jan - 2018) is introduced the ability of hide pages.
In my application i've a page called ABC - Details that has DrillThrough filters. This page is hide.
I've publish this application on web but when a user clicks with the right mouse button on a matrix that has a link to DrillThrough filters the ability to browse on the page that has drillthrought filters is not hidden and the user can go to the page even if has been hidden.