I have tried Googling and multiple different searches in StackOverflow, but I haven't found a solution to this problem. I have a website (that requires SSO and login - so no direct queries allowed), that provides period data sets in…
I have the following JSON { "Data": { "totalExecutionTime": "00:00:00.5544916", "totalCount": "33414", "Items": [ { "featureId": 100, "featureName": "Product", "id": 5903, "parentId": 0, "brand": "Normal", "order": 0, "createdDate": "2022-08-18T19:00:57.44", "modifiedDate": "2024-07-10T13:21:29.123", "Values": [ { "featureId": 100, "featureName": "Value", "seq": 0,…
I know basically zero about Azure Blob Storage, but I'm working on a PowerBI report that retrieves CSV files from Azure Blob storage and parses them into tables in the PowerBI model. This seems like an insanely resource intensive way…
I exported a collection in mongo db as a csv file and then imported that csv into power bi…all fields imported except one . Even after manually adding it in mongodb before exporting as csv, the column showed blank when…
I've this Power BI graph with Subscription Name and Subscription Id by Cost: and I would like to see the subscription name but group by id, so I want to display only the Subscrption Name by Cost but with Subscription…
I am trying to read a JSON file in powerBI whose data looks like this, But when I expend the column timeseries.data, I can only see 'timestamp' column instead of 'timestamp' and 'average' "cost": 44639, "timespan": "2023-02-10T23:59:59Z/2023-03-13T23:59:59Z", "interval": "PT1H", "value":…
I want to replace some acquaintance values by keywords to specific value, converting both "google" and "searching google" to "seo" I tried replace but you should specify all the values to replace with and that's not possible. if there is…
I'm fairly new to Power Query and have hit a hiccup that's been bothering me all day. I've read multiple threads here and on the Power BI community and none has really cleared my question, and my logic suggests a…