This is the example Request body provided by Microsoft to disable a PowerBi schedule refresh via the Rest API { "value": { "enabled": false } } When I call the API, using a service principal, in ADF, with the same…
I have an Rest API made in flask that is registered in Azure, My API allows logging in through Azure credentials, but when I go to generate an access token to access the powerbi reports through user's access_token logged in…
I'm trying to create a dashboard for a client which pulls data from their traditional database into Azure Synapse using Pipelines, where I stored data into Azure DataLakeGen2 as parquet files. Now, i want to visualize data in PowerBI, by…
Can we create a live connection between PowerBi and MySql so that the dashboard reflects the changes made in the database without having to do a manual refresh from PowerBi desktop everytime? I have tried scheduled refresh but i want…
i have a simple flow in azure logic apps: 1- reccurence. 2- Export to file from paginated report as excel. 3- email the excel file. but the second has an error, says Unauthorized code 401. the power-bi paginated report is…
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 am trying to set season ranges for specific dates coming from my DTBL_SCHOOL_DATES table. Below is my logic which works based on the year and its region to set the season per a given range. CASE WHEN RTRIM(dtbl_school_dates.local_school_year) =…