I am struggling with transforming xml message to table view. Was searching for it, found few solutions, none of those worked or I implemented those poorly. Kind
I have written a python library (ak_sql.py) to query my sql server and written another ".py" script (query_sql.py) to invoke this library and return data in dat
I am not experienced with DAX, but want to create a duration curve in Power BI which is responsive to the user's selections (slicers): I am working with time s
I have a simple PowerBI Matrix visualization and I need to justify columns left or right selectively. However, the Field Formatting section is not available or
I have a PowerBi report with several data sources, SQL query and Excel connector. The SQL data data on our Products whereas the Excel is living data on salesper
Table 1: Table 2: Result: I have tried using Fuzzy matching but it's not giving me the results. Please help!
I am working on SSAS Tabular project and I am using Live Connection when importing data to Power BI. Do I need to schedule refresh in Power BI ?
I have a call dataset. Looks like this If a call about a certain member comes in within 30 days of an "original call", that call is considered a callback. I ne
I'm using Power BI Dataflows to access spreadsheets I have in blob storage. I have configured IAM permissions on the storage account for myself and the Power BI
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