When I press refresh button in Power BI (version 2.112.1161.0) I have this error message ! Table1 A cyclic reference was encountered during evaluation. ! Table2 Loading blocked by failures with oth...

I need to find the month difference between two dates (checkIn and Checkout dates) in Power Query (M-query). It can be similar to DAX bellow. period of months = DATEDIFF([dateCheckIn], [dateCheckOu...

Is there a way I can reorder columns in 'Data View' within Power BI? I tried doing it in Power Query first but when the data loads into the table, the columns automatically rearrange.

Following are 2 measures: SUMX ( ALL ( SALES ) , SALES[AMT] ) CALCULATE ( SUMX ( SALES, SALES[AMT] ), ALL (SALES) ) Similarly for the following 2 measures: SUMX ( FILTER ( SALES, SALES[QTY]>1 ...

I am trying to import data into PowerBi using a Python script so that I can schedule it to refresh data at regular basis. I am facing a challenge getting the data from an excel file and receiving t...

I currently have Column Data formulated below in Power BI which I need for it to display in one column but replacing the "1" with a Text value being: Orginal column formula: Age (18-27) = IF(AND(...

I need to create the following chart with DAX, without using Power Query. This has to be done with the following 2 tables: Does anyone have an idea how to create this chart without Power Qu...

In Power Query, when I right-click on the name of a query (in the left-most pane of Power Query's window) I see selections for "Enable Load" and "Include In Report Refresh." I cannot find an expl...

How can I automate the exporting of .pbix to .pbit without Microsoft services? Some hacky solutions using autogui, power automate amongst others. Otherwise does anyone have a python solution or any...

i have created Power bi project, It is working fine in the beginning but when i refresh my datasource , i get this error " not allowed for columns on the one side of a many-to-one relationship" . A...

Since the announcement about XMLA endpoints, I've been trying to figure out how to connect to a URL of the form powerbi://api.powerbi.com/v1.0/myorg/[workspace name] as an SSAS OLAP cube via Python...

I have a powerbi report embedded to my webpage. What I need is to add an "export" button to my page and export the report to the PDF when the button is clicked. How can I achieve this? People onlin...

I have activated Power BI Pro License in my tenant. I have Azure AD with Same Account. I have added following Permissions. In the screenshot, I have added these Power BI Service Permissions which n...

I'm totally new to Power BI so I'm tried different approached to convert my JSON file to a table but unsuccessful so far. { "Family": [ { "Father": "F1", "Age": 50, "Mother": "M1", "MAge": 4...

What would be equivalent of SQL IN operator for Power BI. Just like in clause: where [Column1] IN ('Value1', 'Value2', 'Value3') I am looking for M solution (not DAX).

I'm trying to build a Power BI tool for some data analysis, and one of the plots I need is an inverse quantile plot (quantiles on x axis, values on y axis). Power BI does not have this, and I can't...

I connect my sql database to Power BI. I got sth like 80.000 rows and I have two additional calculated columns that get previous vales. Here is a code Table.AddColumn(#"Added Custom", &qu...

Need RANK function in Power Query, Like in Excel, SQL, DAX... The Best answers for now: Built in Table.AddRankColumn function available since Jun-2022 Solution with the best performance, at least ...

We've been trying to follow this Power BI article so that we can embed reports/dashboards in our SaaS product. Specifically, we're stuck at Step 3, 'Create the Embed Token.' We're able to obtain a...

The following error appears whenever I try to connect to the data sources and authenticate using oAuth login screen on iExplorer web browser.

I have my own Power BI Pro account from my company [email protected]. My client has given me access to his tenant as an external guest user with one of it's Power BI Pro licenses. The question...

I'm trying to connect oracle database using prowerbi desktop. Throwing following error Details: "An error happened while reading data from the provider: 'Object reference not set to an instance of...

I'm attempting to embed Power BI reports into my .Net Core application, however I'm unable to get a valid response back from the request. I'm using the Microsoft.PowerBI.API package and an azure ap...

I have been trying WITH NO LUCK, to get an embed token to be able to embed my powerbi reports into my existing .netcore web api application. The front end looks like a super easy 1 simple react com...

I have 2 queries: Premium: and Losses: How can I simply summarize data from Premium query and LEFT JOIN it to summarized data in Losses query using DAX? In SQL it would be like that: decl...