Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Just looking for some ideas, I'm using Direct Query however there is one table that I feel I need to add additional row, at least 1 row.
Take example I have a table for grouping something like :
Group id | Name |
Group01 | High |
Group02 | Low |
For some reason, I need to add another row for Group03:Medium, but it is only reside in my Power BI, not in my data source.
Is it possible?
Thanks,
Solved! Go to Solution.
Purely DirectQuery while adding local data sounds contradictory to me. Either add the row in the source or use a mixed mode. To not be mixed mode, you'd need the additional row to be DirectQuery too.
You can add a Union statement in the Power Query Editor with your existing query.
Eg:
Select distinct Column1 from Table1
UNION
Select "DynamicData" as Column1
@admin_xlsior , if you ready to make this table as import mode table you can create a table using enter data with this new entry and append and create a table, that table will be an import mode table. Others can be still direct query
Hi @amitchandak ,
Problem is I can't have hybrid/mixed mode. Need to be pure Direct Query mode. That's why whether probably there is some trick to add the row. I'm not sure how, probably from power query first or something else.
Thanks,
Purely DirectQuery while adding local data sounds contradictory to me. Either add the row in the source or use a mixed mode. To not be mixed mode, you'd need the additional row to be DirectQuery too.
Yes, I actually understand this, only try to "push my luck". 😀
Then it is ok.
Thanks,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |