I am encountering a problem quite frequently in a console application (.NET Framework 4.7.2) that attempts to build and then deploy a Tabular Database to a Power BI workspace as a Semantic Model. W...

So I've asked a similar question, but I thought I'd ask it more generally to get as many ideas as possible. I have Power BI Pro. I am tasked with creating reports for hundreds of recipients, each ...

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 the service account email as well as...

I am new to PowerBI. I am trying to implement "App owns data" i.e. embed reports within my web application. I am following this article https://learn.microsoft.com/en-us/power-bi/developer/embed-sa...

I have Year number and Month Number in my data. How using DAX can I get the month name out of month number? In SSRS its very easy. But how to achieve that using DAX?

I was trying to get data from a vendor's REST API from Power BI. When getting data, under Web API, it keeps throwing this error. See attached screenshot. It is a POST method where you can filt...

I am trying to show "Some Column Name" against "Total Amount" in Power BI. I am expecting the following results: But instead it's showing me the following results: The current data type is "...

I have a DAX function that pulls in multiple strings of text (from multiple columns) into one cell. But on display I want to have a line break in between the header and the body of the paragraph. I...

I'm trying to connect Postgres Database on AWS EC2 instance to Microsoft PowerBI. I tried various method available on internet but its showing the above error. Although I've done this connection on...

I have implemented Power BI embedded in a web app with direct query using Azure SQL as data source. The Azure SQL database is being updated by webjobs and if I leave open the Power BI embedded web...

I would like to have a powerquery in my excel file which pulls all the issues from a jira board. I have: created a filter in jira for the issues already. captured the link to the csv export: http...

I am fairly new to Power BI and I have to implement a dashboard which I already have in excel. I am trying to show the transition of some products. The example shown is for demonstration. Basically...

I am writing a Django multi-tenant web application which is supposed to use Power BI Embedded as a reporting frontend (basically to render data from the local DB). For this, I am using the 'App Own...

Set up: Similar to this question on a MSDN forum, I have a measure that switches between various other measures (some of them much more complex than others). The measure looks like this (my actual ...

I want to create a new table based on this one: that filters for Warehouse=2 and "drops" the columns "Price" and "Cost" like this: I have managed to apply the filter in the first step using: ...

I am trying to connect PostgreSQL database to Power Bi. Database is hosted on Heroku. I am getting the following error - An error happened while reading data from the provider: 'The remote certi...

A column in Power Query converts a JavaScript timezone into UK format: = #datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [Timestamp]/1000) But this produces the wrong output (-1hr difference...

I want to dynamically change the number format of a DAX measure, based on a dimension value (or indeed, based on the order of magnitude of the measure value). I understand I can use SWITCH and FOR...

I'm specifically trying to convert string in Column A : yyyymmdd to dd/mm/yyyy date format using Power Query Editor in Power BI. I can already perform this in Excel using the formula below: Any ide...

I am trying to find a solution to load an external data file but from a relative path, so when someone else open my PBIX it will still work on his/her computer. many thanks.

I am working on a report in Power BI. One of the tables in my data model collects sensor data. It has the following columns: Serial (int) i.e. 123456789 Timestamp (datetime) i.e. 12/20/2016 12:04...

If I have the following source: #"My Source" = Table.FromRecords({ [Name="Jared Smith", Age=24], [Name = "Tom Brady", Age=44], [Name="Hello Tom", Age = null], [Name = "asdf", Age = "abc"] }),...

Suppose I have a table as follows: TableA = DATATABLE ( "Year", INTEGER, "Group", STRING, "Value", DOUBLE, { { 2015, "A", 2 }, { 2015, "B", 8 }, { 2016, "A", 9 }, { 2016, "B", 3 }, { 2016...

In Power Bi, I have a table that contains Name and TimeSpent by user in seconds. I want to convert total seconds spent by all users into duration format (hh:mm) When I am getting seconds in hh:mm...

I concatenated four columns using this code (to prevent null values to be linked together) in Power Query (Power BI Desktop): = Text.Combine(List.Select( { [Col1], [Col2], [Col3], [Col4] }, each _...