Questions tagged [microsoft-powerbi]

Self service data integration and visualisation service provided by Microsoft. It can integrate data from Excel and other Office programs, and all major databases and analytics tools and web services

Filter by
Sorted by
Tagged with
0 votes
0 answers
2 views

How to upload a local map into PowerBI

I am trying to load a custom map (svg) into Power BI and the local map button doesn't do anything. Is there a setting that enables this or is it blocked by some company policy?
user avatar
  • 2,847
0 votes
0 answers
8 views

How to interpret QoQ% columns in a matrix in Power BI

I'm trying to figure out how the values in year row (column QoQ%, quick measure function ) were generated in this Matrix: But I don't have clue (values [124.88%, -6.17%, -37.28%, -29.03%]). I tried ...
user avatar
0 votes
2 answers
16 views

How to add Epi Week aka MMWR Week column in Power BI

My dataset has a date column. I need to assign the correct Epi Week/MMWR Week to each row. I can't do it by hand because the dataset spans five years and has over 18,000 rows. The Power Query function ...
user avatar
0 votes
0 answers
6 views

Publish Power BI report to SharePoint Online: What are the current options?

I appreciate that the question has been asked and answered hundred of times in various communities. However, given the constant evolution of both Power BI and SharePoint online, the challenge is to ...
user avatar
  • 181
0 votes
0 answers
15 views

Count of previous week values when data filtered by slicer

My report so far I have a data table in Excel as below. I've imported it into Power BI using this: let Source = Excel.Workbook(File.Contents("C:\Documents\Test Data.xlsx"), null, true), ...
user avatar
1 vote
1 answer
11 views

Remove trend line from a Power BI line chart with continuous x-axis

I need to remove the trend line from my Power BI line chart. The trend line was automatically generated and is not meaningful in my data analysis. I can't find an option to remove it. The trend line ...
user avatar
0 votes
1 answer
35 views

List.Sum in Power Query is not ignoring null values

I added a column with this code: = Table.AddColumn(#"Changed Type", "Total Quantity", each List.Sum( {[species_males]+[#"species_females-mixed"] })) List.Sum is ...
user avatar
0 votes
1 answer
15 views

How to tell which users are running which reports?

I apologize if this isnt the right domain. I searched all the stack exchange communities. I'm using Microsoft PowerBI and would like to know which of the reports created are being run and by which ...
user avatar
0 votes
1 answer
30 views

Power BI bookmark conflicts with slicers

I ran into a bookmark/slicer issue in Power BI. When I try to set a bookmark with more than one filtering setting, I have to update the bookmark every month. My general bookmarks point to a certain ...
user avatar
0 votes
0 answers
143 views

Connecting Power Bi to protected Excel using a connection string

I am trying to connect Power Bi Desktop to a password protected Excel file. I have looked online for solutions and everything points to the same conclusion. Power Bi does not support connecting to ...
user avatar
0 votes
2 answers
122 views

Excel: Power Query - how to repeat block of code for each row in a table

I have JSON in format like this: { "data": [ { "date": "2021-01-01", "data": 10 }, { "date": "2021-01-02", ...
user avatar
  • 810
0 votes
1 answer
17 views

powerbi parse sheets in excel file

I'm importing a list of excel files into PowerBI. So far, I've imported the folder, expanded the files to show the list of sheets, and expanded the sheets to show columns. Here is my code so far let ...
user avatar
0 votes
1 answer
19 views

xlsb PowerBI error External table is not in the expected format

so I read that Excel binary format is faster and better, so I saved my table in this format. Unfortunately I found out that my other workbook which was importing one sheet from this now has problems ...
user avatar
  • 779
0 votes
1 answer
24 views

Power BI formulas not calculating properly

I have a visual that I want to calculate as a percentage above or below a target goal. Let's say I have a table head(5) that looks something like this: id Date Inbound Requests Outbound Responses 1 ...
user avatar
  • 5
1 vote
1 answer
51 views

Power BI sort by column (Date) is producing different results

I have two graphs that are based off of the same dataset. I had an issue with sorting the graph chronologically, so I sorted by a YearMonNum column. The data looks something like this: id YearMonNum ...
user avatar
0 votes
0 answers
834 views

Power BI Desktop turns white when browsing a bit

I have a really tiny Power Bi application, 32bit, getting about 800 lines from a single table with about 200 columns. The size of the app is less than 1 MB. Whenever I browse for about 30 seconds I ...
user avatar
  • 101
0 votes
0 answers
29 views

How to connect oracle db to powerbi report builder

I have installed oracle-11g 32bit and everything is working fine following is the screenshot of DB working. But I am not able to connect to oracle DB from the power-bi report builder (32-bit) or from ...
user avatar
0 votes
0 answers
10 views

Power BI Report - Report Server Move to Production

How can I move a Power BI report to production using Report Server? I don't see an option for this and everything I google doesn't seem to be very helpful.
user avatar
0 votes
0 answers
8 views

PowerBI Drop Zone - Dropped File Now What?

I dropped my power bi desktop file into the drop zone, is it automatically supposed to push to production or does it go to dev > testing > prod? Do I need to click on anything in the drop zone ...
user avatar
1 vote
1 answer
81 views

Sum of previous year Power BI

I'm working in Power BI with data in the following format: Year Number Week Number Sales Value 1 1 20 1 1 15 2 5 32 ...ect ...ect ...ect I'm currently using the measure Total Sales = SUM(Table[...
user avatar
0 votes
0 answers
22 views

Excel Power Pivot Sums are off

For work I am extracting data from a huge .csv file (1.754.488 rows), including revenue numbers for different customers at different months. When I load this .csv file into Power BI and create a ...
user avatar
  • 1
0 votes
1 answer
135 views

How to refresh an uploaded data source for a report created in Power BI web app?

I created a Power BI report using the Power BI website interface at app.powerbi.com. My data source is an Excel table that I uploaded to the web app. Now I need to update the source data. However, it ...
user avatar
0 votes
1 answer
639 views

Power Bi: formula similar to Excel's MAXIFS with multiple criteria

In Power Bi I have a similar Table and I'm trying to figure out a way to calculate in column "G" the maximum value (only for Gender F) for each Team and each Day. In Excel I would use ...
user avatar
  • 137
0 votes
1 answer
11 views

PowerBI - How to See All Pages Being Linked to

I have a page called "Courses". On this page, I select certain filters. When I log into https://app.powerbi.com and select the filters, there is a Tab on the left that says "Courses&...
user avatar
0 votes
1 answer
91 views

Power BI Check If Value Takes Place Before a Certain Time

I have data that looks like this: Joined Time null null 10:01:00 AM 02:20:00 AM I want to add a column that has the following logic: If "Joined Time" < 09:00:00 AM then "PM" if ...
user avatar
0 votes
2 answers
109 views

How do I add a column to a Table in a row with data from another column?

I have a query that aggregates MySQL.Database output. What I would like to do is update the Table in Data to contain the value of Schema for each row in the Table. I think it would be something to do ...
user avatar
1 vote
1 answer
59 views

How can I use Excel to make a chart with two x-axis at different scales?

How can I use Excel to produce charts like the images below? Is it possible? I want to have two different x-axis scales with major tick marks every 10 values. The only data I would want to display ...
user avatar
  • 283
0 votes
1 answer
324 views

Why did On-premises Data Gateway sign-in fail?

When attempting to setup Microsoft's On-premises Data Gateway, after successful installation, the login repeatedly returns a sign-in failure. Following the setup process, an email address to setup the ...
user avatar
  • 9,581
0 votes
1 answer
57 views

Microsoft Power BI desktop — columns col1 and col2 (from excel) make a chart with col2 y axis vs col1 axis

Microsoft Power BI desktop -- after importing excel columns col1 and col2 make a chart with col2 (y-axis) vs col1 (x-axis). Very much like the title says, after importing a spreadsheet from excel, ...
user avatar
0 votes
1 answer
48 views

Loop through visualization in power bi

So I want to have a visualization that is basically a table form, but with visualizations that loop for each customer, is there a control or visual that I can use to do this in powerbi? Please see the ...
user avatar
  • 195
1 vote
1 answer
1k views

Power BI Report Server - change maximum size of uploaded file

Power BI Report Server allows uploading report files to the server up to 2GB in size. The limit is set by default to 1GB see details from the documentation You can upload files up to 2 GB in size, ...
user avatar
  • 1,644
0 votes
1 answer
668 views

PowerBI - Getting a count per day from data containing date and time

I'm fairly new to PowerBI and am having difficulty with getting a count per day form data containing both date and time. I'm using Direct Query and currently have date_closed and Count of date_closed ...
user avatar
  • 164
0 votes
1 answer
3k views

Refresh Power Query For Excel File in OneDrive

I have a Microsoft Form that saves to an Excel file in my OneDrive. I use Power Queries to manipulate the data. This works fine for when I need open the excel file on my computer and I can then ...
user avatar
0 votes
1 answer
99 views

Designing a mass attendance system with Excel and PowerQuery

I am building an Excel spreadsheet for tracking a large number of personnel's daily attendance records. All data examples shown here are fictional, including the data structure. Only the gist of the ...
user avatar
  • 103
0 votes
1 answer
202 views

In powerBI, using a measure breaks the relationship between two tables. What am I doing wrong?

I am doing membership statistics for an organization. In our membership_subscriber table, we have the the dates when the membership begins and ends. There are multi year memberships. I need to show ...
user avatar
1 vote
1 answer
9k views

How to remove a data source from Power BI Desktop?

Edit: I found a solution--see my answer below. The answers I've read are old and no longer work (possibly because Microsoft makes substantial changes to the UI on a regular basis). I tried File -> ...
user avatar
1 vote
1 answer
434 views

Getting 400 Bad Request using Power BI Connector with Aprimo API

I'm trying to access a custom report designed in the Aprimo SaaS with Power BI. I'm following the instructions here on Aprimo's website, https://developers.aprimo.com/marketing-operations/using-...
user avatar
0 votes
0 answers
439 views

How to create a list in Power Query from the listed values in Excel sheet, if it has a range

I am trying to modify the Excel's Power Query with specific rows to keep by using function Table.SelectRows(...). I have the list with numbers of rows to keep and it's working fine, however, I can't ...
user avatar
0 votes
1 answer
37 views

PowerBI Report shifted to the upper left

Every now and then (I can't reproduce this error), upon opening an existing PowerBI document, the report would be shifted to the upper left, such that a good deal of the dashboard is not visible. This ...
user avatar
  • 227
1 vote
0 answers
189 views

Unable to connect to Analysis Service Server from Excel, Visual Studio and PowerBI

Within our domain we have an analysis service server running with cubes. When trying to retrieve this data using Excel (Get data from Analysis Service), Visual Studio (using source control explorer) ...
user avatar
  • 11
1 vote
1 answer
1k views

Power BI how to use offline map

Is there any way to display an offline map on power bi? Have tried the basic and ArcGIS map. None of them support offline map.
user avatar
1 vote
1 answer
43 views

Power BI - Apply Query from Azure DevOps server stuck

My Power BI version is September 2019, Azure DevOps 2019 I imported data from Azure DevOps Server into Power BI report. I used out of the box analytics view (Stories - Today and Tasks - Today). I ...
user avatar
0 votes
1 answer
26 views

Power BI Time duration

I have time stamp data I'm working with. I have data I get in a excel file that I'm uploading to Power BI that has Production Hours field. This field is the amount of time it took to do a task. I have ...
user avatar
  • 1
0 votes
1 answer
312 views

How can I refresh Reports Sequentially in Power Bi without manual intervention?

I have some Power Bi Reports to refresh which are connected sql server. At present we have scheduled them for the refresh with some idle time in between all. I would like to put them in a Sequence ...
user avatar
  • 1
0 votes
1 answer
29 views

Subindexing and Marginal Differencing in Power Query (Excel)

I have this dataset: User Date Time A 9/1/2019 8:00 AM A 9/1/2019 10:00 AM A 9/1/2019 4:00 PM A 9/1/2019 5:00 PM A 9/2/2019 8:00 AM A 9/2/2019 5:00 PM B 9/1/2019 ...
user avatar
1 vote
1 answer
2k views

Removing data sources from a PowerBI gateway

It appears that it is currently impossible to remove a data source from a PowerBI gateway - is this actually true, or am I missing some obscure option somewhere?
user avatar
0 votes
1 answer
605 views

Using a PowerBI gateway with web data sources: query parameters

We have an onprem gateway for PowerBI that gives access to some SQL and Web datasources. This is working, but it appears that each internal web address that we want to use in PowerBI has to be added ...
user avatar
3 votes
1 answer
1k views

Does Microsoft Power BI have file size limitations for functionality like Excel Power Query does?

I inherited an Excel data model consisting of multiple workbooks. Each workbook has multiple tabs utilizing Power Queries to get, transform and load data sets from base supporting Excel and csv files....
user avatar
1 vote
1 answer
130 views

Replace Static Table Data w/ External Source and Update Pivot Automatically (Excel)

st tab is a table with data manually pasted from a file nd tab is a pivot based on the 1st tab Is it possible to replace the 1. st tab with an external data source (load-in the file without pasting ...
user avatar
  • 159
2 votes
1 answer
3k views

Does .pbix file also contain data?

I'd like to send my pbix file to a colleague to make him work on that. Does the pbix file also contain the data or is it just the visualization and they have to load data by themselves?
user avatar
  • 231