I'd like to connect to a power BI database and query it using SQL. My first instinct was to use Python's pyodbc package, like so: conn = pyodbc.connect( 'DRIVER
I am trying to calculate the total recipe cost price for each recipe. I used the below DAX formula as shown in the image but I am not getting the correct result
I am doing a DAX query able to retrieve a list of products installed before a certain date (COIDate) , and that have a specific ProductLine. But, it returns t
I am trying to add a service account key file to access a bigquery data set in power bi. I am selecting service account login during the set up process. I added
I am having an issue using the Distinctcount function in DAX. I have a table with a total of 1,154,493 rows. I have a measure created to count the number of d
My test tabe in powerbi: IdRecord Date Value 1 2022-04-25 23:45:00.000 100 1 2022-04-24 18:07:00.000 344 2 2022-05-01 23:45:00.000 5 2 2022-05-02 18:07:00.000
Quick Note, I have reviewed these threads and they do not fix my issue: ( Outdated info, see documentation below ) Access Snowflake query results through PowerB
How to assign automatically st/nd/rd/th to number behind in date field using power bi DAX formula. I'm creating labels for date something like this 1st MAY 202
I'm getting this issue when trying to load/refresh the report, When I clicked the continue the loading wizard starts with an unending state. I am receiving the
How to download the report as an excel in the PowerBI. Currently, I have embedded the report in the SharePoint page using the PowerBi web part, would need to do
Hi I have two tables(table1 & table2) which both contain year, quarter, month and week. I want to apply a slicer such that when I change the year or Quarter
I have three different tables. I want to select different columns from each of the tables and create one table based on some filters. Have a look at the followi
I have some data about projects I would like to transform in a way that makes it easier to analyse with PowerBi. The data looks like this: Project Number Proje
I have a column with "Yes" or "No" values in it and I want to count the number of rows with "yes". I can create a new column and have values =1 or 0 depending o
I have a problem with the MTD column. I want this column to show only April '22 sales and not the previous months. For example, the sales for April '22 is 7379,
I would like to calculate the daily average weight gain per day for each row and add the answer in a a new column. The variable to calculate the average are
I have created my application in REACT.js and I have embeded my PBI reports into my application. Whenever I am clicking on the button in my PBI report, I am be
Say for example, I want to count how many people are in a room while others are in that room for each day. When that person leaves, I want an updated count of h
I'm building a dashboard in power bi and I have a dataset with a few percentages. There are several categories of data, but only one category is shown at a time
I'm trying to request a Power BI API using axios. var configReportInfos = { method: 'get', url: `https://api.powerbi.com/v1.0/myorg/groups/${process.env