Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I built out a report based on a CSV, but I'd like to be able to programatically add rows to the dataset. I'm unable to modify AddRowsApiEnabled setting to True and I can't find any related setting in the desktop app or the web app.
I'm able to programatically create a brand new dataset from the CSV, however it seems to just be a flat table that I'm not able to modify at all, including create the datetime group/bin that allows me to filter dates correctly.
Does anyone have any ideas how I can be able to programatically add rows to a dataset and be able to add a datetime bin?
ID | DateTime | Status |
32613 | 2/10/2022 1:00:12 PM | Down |
32650 | 2/10/2022 1:00:12 PM | Down |
52242 | 2/10/2022 1:02:10 PM | Down |
52242 | 2/10/2022 1:02:19 AM | Down |
56615 | 2/10/2022 1:04:54 PM | Down |
55937 | 2/10/2022 1:07:48 PM | Down |
51719 | 2/10/2022 1:09:25 AM | Down |
51717 | 2/10/2022 1:09:35 AM | Down |
51938 | 2/10/2022 1:09:38 AM | Down |
Above is some sample data I pulled into a CSV. The DateTime field is what I'm looking to group. If I import the CSV directly, I have full access to Table Tools/Column Tools and can modify the data as I please. However I cannot add new rows to the dataset programatically, I have to refresh the data using the Desktop App and then publish it.
If I use the API to upload the data (using powershell: https://docs.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.data/new-powerbitable?view=p...), I can connect to it in the Desktop App and I can add new rows programatically, however I have no access to the Table Tools/Column Tools and therefore cannot create DateTime groups.
Hi @dearle ,
It seems that you don't quite understand your needs, what kind of functionality do you specifically want to achieve with powerbi?
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Looking forward to your reply.
Best Regards,
Henry
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |