New Idea
0 Kudos

So I've been trying to sign up for about 3 weeks now, and I keep getting the same error message "Sorry, that didn't work. There's a problem on our end. We're working on it, so try again later."

This problem has been persistant for 3 weeks and I'd like to sign up so I can buy PRO and continue. 
I signed up, got the verification code, put it into the field and continued. |

Help?

 

Erico

 

Status: Needs Info
0 Kudos

Hi,

 

I have a table called newspaper sales and a table called web sales.

 

When they are brought into PowerBI they are in a different order.  However in the query i make them look exactly the same.

 

When I then try to create a custom table using the DAX UNION function it treats them as if they have not been reordered.

 

Thanks

 

Chris

Status: Accepted
0 Kudos

Table.Profile() Bug

Status: Accepted
by Simon_Nuss Frequent Visitor on ‎06-09-2017 08:32 AM

There are two bugs that exist in Table.Profile() that can be replicated against the WorldWideImporterDW using the below instructions:

 

1) Executing the below query results in, "Expression.Error: The Duration operatnio failed beacuse the resulting duration falls outside the range of allowed values".

 

let
    Source = Sql.Database("SQL_Server_Name_Goes_Here", "WideWorldImportersDW"),
    Dimension_City = Source{[Schema="Dimension",Item="City"]}[Data],
    Profile = Table.Profile(Dimension_City)
in
    Profile

1083573.png

 

 

2) Table.Profile() will effective DDOS a data source when [CreateNavigationProperties = true].  The below script results in 1,619,884 queries (7 (columns) * 231,412 (rows)) being folded back to the data source.  It is worth noting that [CreateNavigationProperties = true] is the default in Power BI.

let
    Source = Sql.Database("SQL_Server_Name_Goes_Here", "WideWorldImportersDW", [CreateNavigationProperties=true]),
    Fact_Order = Source{[Schema="Fact",Item="Order"]}[Data],
    Profile = Table.Profile(Fact_Order)
in
    Profile

1083574.png

Status: Accepted
0 Kudos

It seems there is a bug in the relative date slicer when using filter by "Last 1 day". In the PBI desktop the "Last 1 day" option shows yesterday, in the service - today's date.

 

The user regional settings in O365 and locally are for one and the same time zone (UTC+2).

 

In PBI DesktopIn PBI DesktopIn ServiceIn Service 

0 Kudos

Data source errorWe cannot convert the value "[List]" to type List

Status: Needs Info
by pradeepgali Visitor ‎06-12-2017 05:24 AM - edited ‎06-12-2017 05:25 AM

There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.

 

Data source errorWe cannot convert the value "[List]" to type List.. The exception was raised by the IDataReader interface.
Cluster URIWABI-WEST-US-redirect.analysis.windows.net
Activity IDb086f14b-5950-6c03-35ca-1ebed29a9cc9
Request ID5c0721f5-2c01-4a90-e95d-a37b4e797b75
Time2017-06-12 12:18:02Z

 

Can you please help?

 

Below is the query that's causing the error. It works fine in PowerBI Desktop. Fails the refresh routine in PowerBI portal.

 

let
Source = Json.Document(Web.Contents("https://jda.com/api/sitecore/Search/GetKnowledgeCenterSearchResults?mode=expanded")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"body", "color", "contentType", "date", "description", "fileSource", "formattedDate", "headline", "industries", "industryDisplay", "language", "photo", "salesTags", "tags", "title", "url", "urlTarget", "videoID", "videoType"}, {"body", "color", "contentType", "date", "description", "fileSource", "formattedDate", "headline", "industries", "industryDisplay", "language", "photo", "salesTags", "tags", "title", "url", "urlTarget", "videoID", "videoType"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"date", type datetime}, {"formattedDate", type date}}),
#"Expanded industries" = Table.ExpandListColumn(#"Changed Type", "industries"),
#"Removed Columns" = Table.RemoveColumns(#"Expanded industries",{"body", "color", "tags"}),
#"Added Custom" = Table.AddColumn(#"Removed Columns", "Pitch Perfect - Solutions.Label", each List.Intersect({[salesTags],List.Distinct(Table.ToList(Table.SelectColumns(SalesCentralMaster,"Solution")))})),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Pitch Perfect - Products.Label", each List.Intersect({[salesTags],List.Distinct(Table.ToList(Table.SelectColumns(SalesCentralMaster,"Product")))})),
#"Added Custom2" = Table.AddColumn(#"Added Custom1", "Pitch Perfect Industry.Label", each List.Intersect({[salesTags],List.Distinct(Table.ToList(Table.SelectColumns(SalesCentralMaster,"SubIndustry")))})),
#"Expanded Solution" = Table.ExpandListColumn(#"Added Custom2", "Pitch Perfect - Solutions.Label"),
#"Expanded Product" = Table.ExpandListColumn(#"Expanded Solution", "Pitch Perfect - Products.Label"),
#"Expanded Industry" = Table.ExpandListColumn(#"Expanded Product", "Pitch Perfect Industry.Label")
in
#"Expanded Industry"

Status: Needs Info
0 Kudos

Query multiple SQL databases in a single query

Status: New
by jim_boyce New Member on ‎05-30-2017 08:50 PM

I would like to join data in multiple tables from the same server, something like:

 

SELECT *

FROM server-x.db1.tblA

INNER JOIN server-x.db2.tblB

ON server.db2.tblB.someColumn = server.db1.tblA.SomeColumn

WHERE server.db1.tblA.something = 'whatever'

 

Hasn't worked so far for me in the several variations that I've tried...is it possible and if so, what am I missing? I know I can bring the data into multiple tables in Power BI and then do a merge on them, but I would prefer to use a single query up front. Thanks!

0 Kudos

From Wikipedia: When the borough incorporated in 2013, it took area from the Hoonah–Angoon Census Area and the former Petersburg Census Area.

 

Power BI recognizes "Petersburg Census Area, AK" as a 'county' but does not recognize "Petersburg Burrough, AK". Can you adjust the shapefile data to recognize the more modern version of this 'county'?

Status: Needs Info
0 Kudos

Error while Loading Live Connecion OLAP Cube Schema:

 

Error Message:
Failed to parse CSDL into ConceptualSchema

Stack Trace:
Microsoft.PowerBI.ExploreHost.Errors.ConceptualSchemaCreationException: Failed to parse CSDL into ConceptualSchema ---> System.ArgumentException: An item with the same key has already been added.
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at Microsoft.InfoNav.Data.Edm.ConceptualEntity.BuildHierarchiesByName(IReadOnlyList`1 hierarchies, ReadOnlyDictionary`2& hierarchiesByName, ReadOnlyDictionary`2& hierarchiesByEdmName)
   at Microsoft.InfoNav.Data.Edm.ConceptualEntity..ctor(String name, String edmName, String displayName, String edmContainerName, ConceptualEntityVisibilityType visibility, Boolean isDateTable, Nullable`1 rowCount, IEnumerable`1 properties, IEnumerable`1 hierarchies, IEnumerable`1 displayFolders, IDictionary`2 edmNamesToProps, IEnumerable`1 keyColumns, IEnumerable`1 defaultFieldProperties, ConceptualColumn defaultLabel, ConceptualColumn defaultImage)
   at Microsoft.InfoNav.Data.Edm.ConceptualSchemaBuilder.CreateConceptualEntity(IEdmEntitySet edmEntitySet)
   at Microsoft.InfoNav.Data.Edm.ConceptualSchemaBuilder.CreateConceptualEntities(List`1& edmEntitySets)
   at Microsoft.InfoNav.Data.Edm.ConceptualSchemaBuilder.CreateConceptualSchema(String schemaId)
   at Microsoft.InfoNav.Data.Edm.ConceptualSchemaBuilder.TryCreateConceptualSchema(IEnumerable`1 schemaReaders, ITracer tracer, Version csdlVersion, String schemaId, ConceptualSchemaBuilderOptions options, IConceptualSchema& schema, IList`1& deserializationErrors)
   at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.ParseConceptualSchema(Stream dataModel)
   --- End of inner exception stack trace ---
   at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.ParseConceptualSchema(Stream dataModel)
   at Microsoft.PowerBI.ExploreHost.ExploreClient.GetConceptualSchema(String databaseID)
   at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabaseLive.get_DataModel()
   at Microsoft.PowerBI.Client.Windows.Modeling.ModelProxy.TryGetModel(IDataModel& dataModel)
   at Microsoft.PowerBI.Client.Windows.Services.WarningDetectionService.DetectDataModelWarnings()
   at Microsoft.PowerBI.Client.Windows.Services.WarningDetectionService.<ScheduleAsyncDetection>b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Invocation Stack Trace:
   at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
   at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
   at Microsoft.PowerBI.Client.Windows.Utilities.UIBlockingAwareExceptionHandler.HandleException(Exception e)
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   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.InvokeMarshaledCallbacks()
   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.PowerBI.Client.Program.<>c__DisplayClassd.<Main>b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)

 

Schema to Load: CSDL Cube Schema

Status: Needs Info
0 Kudos

How to connect MS Project to Power BI

Status: Delivered
by Richard456 Occasional Visitor on ‎11-18-2016 04:29 AM

Is there a way to connect a Microsft Project file to Power BI?

Status: Delivered
0 Kudos

Error SQLQuery to table not the same data.

Status: New
by jpsolares Occasional Visitor on ‎04-25-2017 01:40 PM

Hi,

I just make a T-SQL Query

 

#invoice, DateInvoice, Month, year, Isoweek#invoice, DateInvoice, Month, year, Isoweek

When i see it in Power(In a table) its show different.

#InvoiceNumber, Isoweek, Month, Date#InvoiceNumber, Isoweek, Month, Date

The problem that month and isoweek differ baddly.

 

Any idea to fix this thanks in advance.

 

Greetings,

 

JP

 

 

0 Kudos

I'm trying to edit my query with an R script.

I need two libraries with conflicting functions. This wouldn't be a problem at all in R, as overlapping functions are simply shadowed. By the way, in Power BI I hit an error and simply can't proceed further to run the script.

error.JPG

 Is the issue known? Fixed? If not, would it be possible to fix it?

Status: Needs Info
0 Kudos

below error occured during scheduled refresh;

 

An error occurred while processing the data in the dataset.

There's not enough memory to complete this operation. Please try again later when there may be more memory available.

 

Technical Information:

Activity Id: 7a3d5954-9225-4335-8046-de93478bd66c

Request Id: 0fa52e75-9b4f-46bf-b6ed-4ee220fc4abc

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

Refresh Start Time: 06/09/2017 06:30:01Z

 

Status: Needs Info
0 Kudos

Two related bugs:

 

1. When I add an index column, it should be added as integer not decimal

 

2. When I add an index column to the "Transform File from X" subquery/function created by the "combine files" feature, the column type in the final query becomes "any". It should be the type that was present in the subquery.

Status: Accepted
0 Kudos

Time 11:59:59.573 Imports from SQL as PM

Status: Needs Info
by Michoffy Visitor on ‎06-15-2017 08:47 AM

Date of 2015-07-15 11:59:59.573 imports as 7/15/2015 11:59:59 PM instead of AM or 12:00:00 PM

 

 Power BI Bug.JPG

Status: Needs Info

We have a report that connects to a SSAS tabular model using Direct Query. In order to make some of our measure names more user friendly in a report, we created some Report Level Measures (the new feature in the May release of Power BI desktop) and formatted those new measures appropriately (whole number with commas, decimal numbers with commas and two digits after the decimal, percentages, etc.) but we lose that formatting after saving and re-opening the file. We also lose the formatting after publishing the report to the Power BI service on the web.

 

Has anyone else experienced this issue? Any known work arounds?

Status: Accepted
0 Kudos

Rows with errors are not being removed after applying remove errors to columns or an entire table.

 

 

let
    Source = Folder.Files("X:\Projects\DA_BIM_Resources\BIMLIST-forReports"),
    #"Filtered Rows1" = Table.SelectRows(Source, each ([Extension] = ".bldb")),
    #"Expanded Attributes1" = Table.ExpandRecordColumn(#"Filtered Rows1", "Attributes", {"Size"}, {"Attributes.Size"}),
    #"Removed Other Columns" = Table.SelectColumns(#"Expanded Attributes1",{"Name", "Date accessed", "Date modified", "Date created", "Attributes.Size", "Folder Path"}),
    #"Added Custom Path" = Table.AddColumn(#"Removed Other Columns", "Path", each [Folder Path] & [Name]),
    #"getXML Table0" = Table.AddColumn(#"Added Custom Path", "XML Data", each getXML_Table0_DatabaseInfo([Path])),
    #"Expanded XML Data" = Table.ExpandTableColumn(#"getXML Table0", "XML Data", {"ID", "Name", "LastUpdatedDate", "RemoteServerAddress", "CreatedBy", "LastUpdateBy"}, {"database.ID", "database.Name", "database.LastUpdatedDate", "database.RemoteServerAddress", "database.CreatedBy", "database.LastUpdateBy"}),
    #"getXML Table 2 - contentItems" = Table.AddColumn(#"Expanded XML Data", "Custom", each getXML_Table2_ContentItems([Path])),
    #"Expand ContentItems" = Table.ExpandTableColumn(#"getXML Table 2 - contentItems", "Custom", {"ID", "Name", "CategoryID", "Path", "AverageRating", "TotalLoadCount"}, {"ContentItem.ID", "ContentItem.Name", "ContentItem.CategoryID", "ContentItem.Path", "ContentItem.AverageRating", "ContentItem.TotalLoadCount"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expand ContentItems",{"ContentItem.AverageRating", "ContentItem.TotalLoadCount", "database.LastUpdateBy", "ContentItem.ID", "ContentItem.Name", "ContentItem.CategoryID", "database.LastUpdatedDate", "database.RemoteServerAddress", "database.CreatedBy", "Path", "database.ID", "Date created", "Attributes.Size", "Folder Path", "Name", "Date accessed", "Date modified"}),
    #"Split Column by Delimiter1" = Table.SplitColumn(#"Removed Columns","ContentItem.Path",Splitter.SplitTextByEachDelimiter({"\"}, QuoteStyle.Csv, true),{"ContentItem.Path.1", "ContentItem.Path.2"}),
    #"Removed Columns1" = Table.RemoveColumns(#"Split Column by Delimiter1",{"ContentItem.Path.2"}),
    #"Removed Duplicates" = Table.Distinct(#"Removed Columns1"),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Duplicates",{{"ContentItem.Path.1", "PathsUnique"}}),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each Text.StartsWith([PathsUnique], "S:\_Firmwide\BIMListContent\2017") and Text.Contains([PathsUnique], "Area Tags")),
    #"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"PathsUnique", Order.Ascending}}),
    #"Added Custom" = Table.AddColumn(#"Sorted Rows", "AllFilesInAllFolders", each Folder.Files([PathsUnique])),
    #"Expanded AllFilesInAllFolders" = Table.ExpandTableColumn(#"Added Custom", "AllFilesInAllFolders", {"Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}, {"Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}),
    #"Removed Errors" = Table.RemoveRowsWithErrors(#"Expanded AllFilesInAllFolders")
in
    #"Removed Errors"

Image 10.png

Image 9.png

Status: Accepted
0 Kudos

Power BI Desktop February release bug

Status: Delivered
by aaronjlevitt Frequent Visitor on ‎02-13-2017 07:31 AM

I just updated to latest version of Power BI Desktop and can no longer link tables

 

I've tried creating links between a few different tables, deleted and regenerated them, etc. No luck. I'm getting the message: "Unexpected Error    Object reference not set to an instance of an object"

Status: Delivered
0 Kudos

BULLET CHART VISUAL PROBLEMS

Status: Accepted
by areabim Occasional Visitor on ‎03-21-2017 08:53 AM

Good morning,

 

The graphic "Bullet Chart by OKViz" from Visuals Gallery distorts when I want to visualize it from the IPad or mobile. Can you  tell me what is happenning? I´ve already talked to the author of the graphic and he said that is an issue from the Power Bi team.

 

This is how I see it on the Power Bi Desktop and in the Power Bi cloud:

 

 barra verde.png

 

This is how I see it from the IPad or mobile:

 

 

 barra negra.jpg.png

 

Thank you!

Status: Accepted
0 Kudos

Azure SSAS scheduled refresh issue

Status: Accepted
by pawel_sz Frequent Visitor on ‎02-17-2017 04:19 AM

When having imported data from Azure SSAS, I tried to set a scheduled refresh on it but it seems not possible from the portal:

large.png

 

Twaking around various ways of doind it (like switching to alternative source with data gateway), I made the refresh work temporarly, so it seems the functionality works, it's just management UI which seems not to support setting authentication to Azure SSAS.

 

Thanks

Status: Accepted
0 Kudos

Hi, each time I refresh my Sybase connection in Power BI Service or test the connection in the Data Gateway settings, Sybase adds a connection or 2 to this database.  Yesterday I had used up all my connections because of this.  Is there a way to close the connection after running my PowerBI query or testing the connection?  Thanks.

Connection Results.JPG

 

declare @Max_trade_date int
select @Max_trade_date =
max(trade_date_id)
from misty_owner.gcis_v_workflow_status
where
is_weekend_flag = 0
and is_holiday_flag = 0
and trade_date_id < Convert(int, Convert(varchar(12),today(), 112))

select
CONVERT(varchar, CONVERT(DATETIME, CONVERT(CHAR(8), trade_date_id)),101) as 'Trade Date'
,status_code as 'Status Code'
,status as 'Status'
,business_name as 'Business Name'
,business_group as 'Business Group'
,business_description as 'Business Description'
,Convert(varchar, completion_time, 101) || ' ' || CONVERT(varchar(15),CAST(completion_time AS TIME),100) as 'Completion Time'
,Convert(varchar, expected_completion_time, 101) || ' ' || CONVERT(varchar(15),CAST(expected_completion_time AS TIME),100) as 'Expected Completion Time'
,is_weekend_flag
,is_holiday_flag
from misty_owner.GCIS_V_workflow_status
where trade_date_id = @Max_trade_date
order by
status_code
,business_name

Status: Needs Info
Idea Statuses