Forum Discussion
Add rows in a PBI report automatically
Hi,
Do you know how to add rows to a PBI report automaticaaly. I have already used the dax function union and rows and it worked bu manually because i had to enter the data. For now it is not a problem because it wasn't a lot of data but i will probably meet this problem in the future. Do you know how to solve it ?
The picture below is what i have already done.
Thanks
3 Replies
PaulDBrownCommunity Champion
If there isn't a source, I would probably go down the route of creating the data in a table in Excel and import the data to append to the other table. It will be easier to update/maintain in Excel, and if you store it in OneDrive and connect the Query to the file in OneDrive, it will update automagically once published in the service (about once an hour I think)
I don't think it's the good way to do that because we always have the manual part to do in the excel. what i want is to create a forecast in dax for my product. I have applications that each have several phases. There are 6 life phases in our products and for this year there are applications that are not present on all phases. What I want to do with dax is to anticipate these phases by setting a null value for them because they do not exist
Hi Anonymous ,
Accodring to my study, now Power BI does not support it. May you can create an idea here and post this link for us to vote for it.
If I have misunderstood your meaning, please provide more details and your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly