model
3 Topics
Server dails to refresh "Qe cannot convert the value "[Binary]" to type Binary" No binary value
I am getting to types of errors which are probably related. For context, the dashboard is a large and complex model with over 20 queries and 15 data sources, pulling from Azure, Shaerpoint and other sources. First, on the desktop, I can only refresh the data when I open the Power Query editor, refresh the data sources and then close it. Then I can refesh the data with no problems. Otherwise, one of the query dependencies will fail. Second, once I do the Power Query editor part and I upload, I always get this error but in different queries: Data source error: Expression.Error: We cannot convert the value "[Binary]" to type Binary.. . The exception was raised by the IDbCommand interface. Table: XXXXX. The Table will change on each iteration. None of the tables have binary values.Solved774Views0likes2Comments
Matrix Table - keeps on repeating
Hi! Would appreciate insights on where my model is going wrong. I have these tables: (1) Base headcount of employees w/c I am planning to use as dimension (2) Data that would be used for the measures - this table has a person identifier that could be linked to table 1 (3) Dimension table for Region, Business Unit and Country Basically, the stakeholder would want a visual and table that shows how many employees meets the metrics and how many are not. So the table 1 have a mapping of region and business unit per employee w/c was then connected to table 3. Now, the issue is the matrix table. Since they would want as well the list of workers that does not have data in table 2, I have added +0 at the latter part of the DAX that simply count the rows, sum some data, etc. What happens is that, if I visualize it as a table: Region - Business Unit - Worker, the worker appears to ALL regions and BUs w/c should not be the case. Any insights on where did I went wrong? Any help would be appreciated 🙂Solved1.1KViews0likes3Comments
