User Profile
RZ
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Mashup Exception: Any ideas to try?
I have been trying to solve a MashUp exception error for some time now. I have managed to simply the problem as follows. I have a main and related table, they have a common id between themselves. For debugging purposes the main table has only one column "id" and one row. And I have a function GetRelated(id) that retrieves the related records from an API given an id. When I add a column with a call to this function referencing the id and then remove the column; DataFlow gives a MashUp Exception when published but looks fine in the PowerQuery Editor. Just a note: the error is the same if I dont remove the column. Fail let Source = mainTable, #"Invoked Custom Function" = Table.AddColumn(Source, "related", each GetRelated([id])), #"Removed columns" = Table.RemoveColumns(#"Invoked Custom Function", {"related"}) in #"Removed columns" However if I retrieve the related records outside the failing query in another table... GetRelatedInAdvance: let Source = GetRelated("98035f6c-e16f-46cd-9fea-08db04f8aa2f") in Source And then add this table into a column let Source = mainTable, #"Invoked Custom Function" = Table.AddColumn(Source, "related", each GetRelatedInAdvance), #"Removed columns" = Table.RemoveColumns(#"Invoked Custom Function", {"related"}) in #"Removed columns" The flow works. Looks the same as the failing one in the editor. What else should I look into? Thanks RuchanUnexpected behaviour in Power Query
Hello, I have a Power BI report that connects to variouys data sources (files, API) and brings them together. I made some changes yesterday, And I started getting dataformat.error's during refresh. The error is not associated with one row. Instead the whole step fails. After some backward steps to identify the issue , now I am at a stage where I am getting the error DataFormat.Error: We couldn't convert to Number. Details: True at the sorting step where I was hoping to find some problematic data... The immediate step before refreshes fine. It s the step where I converted the values to text in order to debug if something was wrong with the data I have,,, Any suggestions? Thanks... RuchanDynamic Real-Time Simulation X-Axis
Hello, I have second resolution calculated/simulated data. The data is forecast data covering the the next year. I am trying to build a demo dashboard that would display a current window of 20 + 1 seconds worth of data. I tried calculated columns or measures or calculated tables by filtering according to current time ... i.e. LiveViewValue = IF(AND(secondresolution[timestamp]>(NOW()-20/(24*60)),secondresolution[timestamp]<NOW()+1/(60*24)),secondresolution[measurement],BLANK()) But I can't make the calculations, measures that refer to NOW() refresh themselves... I wonder if it is doable.. Any suggestions?Re: Datetime import issues
Hi Xiaoxin Sheng, The issue is the imported values are not the same as the original values. The first screenshot shows a cell value of 10/04/2022 12:00:00 in excel. When this gets in PowerQuery it is displayed as the same in the column view but when you click on the cell you see that the value has actually become 10/04/2022 11:59:59.9990000. That I became aware when I used the a column to extract the Minute(). The funny thing is: I have a year worth of hourly data and the values before 10/04/2022 12:00:00 import fine but the ones after all have the same issue. I found a way around that, I extract the minute in excel and import afterwards. But the behaviour is strange and would like to understand why that happens. But as of now I will double check my datetime imports.
