search

RuiRomano / pbigtwmonitor

MIT License
83 stars 27 forks source link

Gateway Monitor - FromDisk.pbit is not working #14

Open Gujjugaming2k opened 3 months ago

Gujjugaming2k commented 3 months ago

Have any buddy checked, look like its not working @RuiRomano any update when it will be fixed ?

sachinv22 commented 1 month ago

Yeah it isn't working for me either. the problem is with the Requests query wherein it's throwing an error that "Cannot convert value '' of type Text to type Date." and the other problem is with the Mashup Container profile table.

kieran-steele commented 3 weeks ago

Likewise. Same error. "Cannot convert value '' of type Text to type Date." in the requests query

This is actually my first use, found this funnily enough as the Microsoft OnPremisesDataGatewayLogs.pit still has that error "DataFormat.Error: There were more columns in the result than expected. Details: Count=11" from years ago.

I had a quick look at the Files query. I notice it takes the date and does

= Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}}) and then near the end of the query it does

= Table.TransformColumnTypes(#"Removed Columns",{{"Date", type date}, {"Folder", type text}, {"Content Type", type text}})

In step 3 of Files from disk there is a date modified in date format, and when it gets grouped and comes back out its text in step 8.

Only other thing I can see, is when the query fails, the last line of code is :

//SUMMARIZE(UNION(logsRequests, queriesRequests), [RequestId], "Date", MIN([Dat, [Time])

In looking to check the syntax is correct (and note Dat, not Date)

https://amitchandak.medium.com/power-bi-power-query-vs-dax-append-and-summarize-data-233f173d0839#:~:text=%23%22Grouped%20Rows%22-,DAX%20Solution,-In%20Dax%2C%20we

Maybe? its meant to be "Date", MIN(Date, [Time]) and in a few rows above its TimeId but I dont think thats it.