New Idea

Hi,

 

We are experiencing a problem selecting dates on a report, where we have two filters based on date/time columns. When we try to select an exact date from the calendar for the first filter, the value actually ends up for the second filter. This applies if both filters are of advanced type. Attached is a screenshot showing the problem.

 

date_time_filter_selection.png

 

BR,

Tuomas

Status: Accepted

Hello everyone, 

 

Since the new December version has been released, I keep having crashes of Power BI over and over trying to link two tables... 

 

As soon as I want to create the link (drag and dropping a dimiension to a table to another table) the windows terminal opens with SQLDUMPER.exe and close/crash Power BI.

 

I have never experienced this before the last release.

 

Thank you for your help

Status: Accepted

In Power BI Desktop Jan 2018 release, with a Date or Date/Time field selected in the Fields pane, when you navigate to the Modeling ribbon / Format / Date Time menu, the options at the top (marked with an *) that respect the machine locale now show in US format (e.g. M/d/yyyy) on machines with non-US locales e.g. English (Australia).

 

This appears to only be a problem in the display of the menu.  When date fields are shown in a visual e.g. a Table, the expected non-US locale is used e.g. d/M/yyyy.  

 

This issue was introduced with the Jan 2018 update to PBI Desktop.

Status: Accepted

The supplied URL must be a valid 'http:' or 'https:' URL ???

Status: Accepted
by Sean Super Contributor ‎03-12-2018 09:29 PM - edited ‎03-13-2018 07:45 AM

I have a PBIX file that updates every Monday from a web page.

Last Monday March 5th (before the March 2018 Update) all was fine Smiley Happy

Today Monday March 12th (after the March Update) I get this error Smiley Sad

The supplied URL must be a valid 'http:' or 'https:' URL

Well the URL is working and it opens fine in any browser! (Firefox, Edge, Chrome)

Here's the error I see in the Query Editor

URL Must be Valid.png

Oddly the URL still works in Power Query but not PBI

I've duplicated the issue with this different link http://www.imdb.com/chart/top

Here's result in PBI

URL Invalid PBI.gif

 

And result with same URL in Excel

URL Valid Excel.gif

 

Thanks! Smiley Happy

Any ideas / suggestions would be greatly appreciated!

 

Desktop Forum Link

http://community.powerbi.com/t5/Desktop/WEB-source/m-p/373717#M169672

 

UPDATE: This happens with both March 2018 Versions I've tried so far

2.56.5023.861 - March 7 and

2.56.5023.942 - March 12

Both don't work and say URL is Invalid!

 

Also I was able to downgrade to Feb 2018 and I do NOT encounter this issue there!

 

 

Status: Accepted

Bug with slicer and Bookmark in Service

Status: Accepted
by rmccormick Visitor on ‎01-11-2018 02:27 PM

In the Power BI Service, I have uploaded a project that utilized a bookmark to reset several slicers on a page.  This works smoothly in Desktop, but in the service, it does not function reliably.  Is there a workaround for this, or is this a known issue?  

 

Using the standard drop down slicer and no custom visuals.  

 

Thanks,

Status: Accepted

Hello 

 

I have just installed the Feb 2018 update for Power Bi and i am no longer able to open any .pbix files. I recieve the message; 

 

Unable to open document; we weren't able to restore saved database to the model

 

There is a current forum open - http://community.powerbi.com/t5/Desktop/Unable-to-open-document-we-weren-t-able-to-restore-saved/m-p...

 

I have followed some previous blogs of uninstalling/reinstalling, and the error still remains. Can anyone help please?

 

Thanks

Status: Delivered

Something went wrong error PBIRS (October Release)

Status: New
by Siva_P Visitor on ‎04-06-2018 01:21 PM

We are using PBI report server Oct release. Thousands of users access dashboards via SharePoint page. But frequently getting this error.  After researching server logs found these exceptions "Failed to publish model" / "Failure in modelsandexploration".  

 

 image.png

 

Here is exception stack trace details. 

Failed to publish model for reportGUID_507223161|

Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to publish model for reportguid_507223161 ---> System.ArgumentException: Item recordID already exists in the collection.
at Microsoft.AnalysisServices.Tabular.NamedMetadataObjectCollection`2.ValidateCanAdd(T item)
at Microsoft.AnalysisServices.Tabular.MetadataObjectCollection`2.Add(T metadataObject)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadObjectsFromSchema(DataSet schema, ObjectType[] types, Dictionary`2& objectMap, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadModelFromSchema(DataSet schema, ObjectType[] objectTypes, Dictionary`2& objectMap, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.DiscoverModel(Database db)
at Microsoft.AnalysisServices.Tabular.Database.LoadModel()
at Microsoft.AnalysisServices.Tabular.Database.get_Model()
at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.AddRole(String roleName, String databaseName)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.<>c__DisplayClass16.<LoadDatabaseInAsAsync>b__15()

--- End of inner exception stack trace ---

Failure in modelsandexploration| Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to publish model for reportGUID_507223161 ---> System.ArgumentException: Item recordID already exists in the collection.
at Microsoft.AnalysisServices.Tabular.NamedMetadataObjectCollection`2.ValidateCanAdd(T item)
at Microsoft.AnalysisServices.Tabular.MetadataObjectCollection`2.Add(T metadataObject)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadObjectsFromSchema(DataSet schema, ObjectType[] types, Dictionary`2& objectMap, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadModelFromSchema(DataSet schema, ObjectType[] objectTypes, Dictionary`2& objectMap, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.DiscoverModel(Database db)
at Microsoft.AnalysisServices.Tabular.Database.LoadModel()
at Microsoft.AnalysisServices.Tabular.Database.get_Model()
at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.AddRole(String roleName, String databaseName)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.<>c__DisplayClass16.<LoadDatabaseInAsAsync>b__15()

 

Please share any ideas/resolution for this issue? does PBIRS Mar 2018 release has any fix?

I have a report connecting to a live SQL database that updates every few hours from 8am to 7pm.

 

Recently the error message has been emailed to me after every refresh attempt:

 

The last refresh attempt failed because of an internal service error.

 

Technical Information:

Activity Id: a473f02e-fc88-4dfc-abc0-7b6025e481f1

Request Id: bdd61c66-6efb-476a-8f4b-e17555e42a01

Cluster Name: WABI-NORTH-EUROPE-redirect.analysis.windows.net

Refresh Start Time: 03/22/2018 16:01:23Z

Refresh End Time: 03/22/2018 16:16:59Z

 

However when I look at the report the refresh did succeed.

 

The emails would be ignorable but after a time the refresh is disabled and has to be reactivated

 

XX_Report data refresh disabled.

 

The refresh normally only takes a second or 2 so timing out isn't an issue, and has been working for several months with no problems before this issue started. A new version of the report has been deployed recently which may be a factor.

 

Thanks.

After updating to the March 2018 release of Power BI Report Server, the Export Data function is no longer working.  The link is visable to show Export Data, but once clicked nothing happens.

 

Chrome Console shows the following error:- ' Script error for "odataFilterParser" '.

Cancellation occurred when sending or receiving a request.

Status: New
by hugo6262 Visitor ‎01-11-2018 08:09 AM - edited ‎01-11-2018 08:11 AM

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

Cluster URI:WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID:c21669ce-c606-4dc0-93d6-66fc6578519d
Request ID:3a01ab7b-abe3-e1d6-dbf1-2fc09cde3c1c
Time:2018-01-11 15:29:15Z

 

POWERBI DIRECT QUERY HAS STOPPED WORKING!!!!

Status: Accepted
by jak82 Member on ‎01-10-2018 12:27 AM

Okay,  We had the issue last month with unable to join tables together.

 

Now after updating to the January I cannot load any DIRECT QUERY pbi files as it says it cannot connect to multiple databases when it is only connecting to one.

 

We are a multi million pund business and have made an investment into using PowerBI as tool.  This breaking on and off all the time is not very viable.  Please can this be fixed ASAP!!!!!!!!

Status: Accepted

Power BI Desktop Crash post Feb 18 update

Status: Accepted
by Stharwani Regular Visitor on ‎02-06-2018 05:30 PM

PBI Desktop is still crashing on prublishing a file.

 

The same error as previour month, opens up a SQLDumper.exe.

 

Please resolve

Status: Accepted

We have a Power BI daily status report that is published to the power bi service and shared with users.  Users subscribe to the main report page to receive a daily status update via email.

 

The report was edited in the Power BI Desktop service to add a new visual on the main page. The name of that page was not changed. After the report was published to the Power BI service, users stopped receiving the daily email update. When they signed onto Power BI service to view their subscription status, they now see the word "Draft" next to the repport page name. The only fix is for them to delete that subscription and then resubscribe to that page.

 

This is tremendously inconvenient-- we need to be able to edit our reports without breaking subscriptions. 

 

 

Status: Needs Info

Issue: Couldn't load the data for this visual

Status: Needs Info
by slee Visitor on ‎04-19-2018 09:37 AM

This issue has been occurring on the Power BI Service over the last 2 days.  Only 1 of the report page is erroring out when uploaded from Power BI desktop to Power BI Service.  The other report pages are functioning properly.  I've reduced the amount of data and it is still erroring out.  Please advise on how to troubleshoot and resolve this issue.  Is this related to data volume because I didn't think the dataset were that large (PBix file size is approximately 500 MB.).

 

2018-04-19_9-35-35.png

Thank you for your help.

Status: Needs Info

Function  definiton:

 https://msdn.microsoft.com/query-bi/dax/datesinperiod-function-dax

Problem:

 Can't save/apply/change measure anymore due to not accepting any interval parameter

Measure:

 avg something = CALCULATE(AVERAGE('Table'[something]),
  DATESINPERIOD('Table'[Date],TODAY(), -7, DAY))

Version:

 Version: 2.57.5068.721 64-bit (April 2018)

Solution/Fix:

  avg something = CALCULATE(AVERAGE('Table'[something]),
  DATESINPERIOD('Table'[Date],TODAY(), -7,0 , DAY))

 

Function is defined with integer and not number. Parser seems to be broken

Status: Needs Info

Hi everyone,

 

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:

 

https://community.powerbi.com/t5/Service/Slicer-works-on-Desktop-but-not-well-Online/m-p/242274/high...

 

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.

 

Thanks

 

Jarrod

Bug: FORMAT function formatting mm:ss incorrectly

Status: New
by behonji Visitor on ‎04-17-2018 10:39 AM

The formatting of datetime in Power BI doesn't work if you only use mm:ss.  Power BI will format the value as if it was MM:ss displaying Month then seconds.  If I use an hour indicator, then Power BI will recongnize the lowercase mm as minutes.

 

MyMeasure:=TIME(0, 0, 195.6) 

Has a value of "12/30/1899 12:03:16 AM"

 

TestFormat:=FORMAT([MyMeasure], "mm:ss")

Has a displayed value of 12:16 which is actually December and 16 seconds.  If I used mmm:ss, I get Dec:16.

 

TestFormat:=FORMAT([MyMeasure], "hh:mm:ss")

Has a displayed value of 00:03:16, but this is actually wrong because my hh indicates a 12-hour clock and should read 12:03:16.  For some reason it treats the hh as HH.

 

 

Power BI Service Down

Status: New
by darranm Frequent Visitor on ‎12-08-2017 12:38 AM

Hi,

 

Is the Power BI Service down for anyone else?

 

UK, 8:37am

 

Power BI Error.PNG

Hi Guys, 

 

This morning i was able to login and publish my file to the Power BI web service; this afternoon i downloaded the latest January update and since then i am unable to login to the Desktop app. I get the message "Unable to login. Details: One or more errors have occured". Thats it. Any advice? I cant reset my password for my BI account as it is connected to my Microsoft Account, re-installing has not fixed. Clearing my permission/cache has not fixed. 

 

Many thanks

Scott

Status: Needs Info

Since some time last Thursday evening any tile that I have using the "Dark Gray Canvas" base map in the Power Bi Arc GIS maps has been displaying an Arc GIS login rather than the map. The problem does not appear to impact any of the other base maps.

 

I also get the same if I create a new tile and select the "Dark Gray Canvas" base map in the Arc GIS maps visual. The problem shows up in both desktop and service.

 

Is anybody else seeing the same and/or is anybody seeing no issue using the "Dark Gray Canavas"? I'm not sure if this issue is regional or widespread in nature.

Status: Needs Info