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
1answer
118 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 ...
0
votes
1answer
24 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 ...
0
votes
1answer
7 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&...
0
votes
0answers
8 views

grant power bi app access to name@mycompany.onmicrosoft.com

Is it possible to grant access for name@mycompany.onmicrosoft.com group to a Power BI app? I always get below error: the following groups have failed validation
0
votes
1answer
88 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 ...
0
votes
2answers
104 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 ...
0
votes
0answers
12 views

Is it possible to create a time series table from a MySQL data?

I was wondering, given a MySQL table that has no "datetime" information but has something simple like key [VARCHAR] and value [NUMBER(19,2)]. I want to periodically query the table to track ...
1
vote
1answer
32 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 ...
0
votes
1answer
63 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 ...
0
votes
1answer
42 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, ...
0
votes
1answer
26 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 ...
1
vote
1answer
397 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, ...
0
votes
1answer
134 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 ...
0
votes
0answers
7 views

Power Bi and SSRS

I am trying to deploy a PowerBI report to SSRS and it was deployed. But while trying to view the report, The report is downloading instead. Can any of you guide me through the steps. Thanks in advance....
0
votes
1answer
2k 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 ...
0
votes
1answer
70 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 ...
0
votes
1answer
73 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 ...
0
votes
1answer
4k 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 -> ...
1
vote
1answer
166 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-...
0
votes
0answers
415 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 ...
0
votes
1answer
32 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 ...
1
vote
0answers
160 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) ...
1
vote
1answer
822 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.
1
vote
1answer
39 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 ...
0
votes
1answer
21 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 ...
0
votes
1answer
219 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 ...
0
votes
1answer
24 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 ...
1
vote
1answer
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?
0
votes
1answer
485 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 ...
3
votes
1answer
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....
1
vote
1answer
81 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 ...
2
votes
1answer
2k 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?
1
vote
1answer
555 views

Manage changing column names in Power BI Desktop

I have a csv which containts 35 columns, the problem is that the last 13 columns name will change monthly. Now when I'm trying to refresh I receive an error like this " name x was not found". Is it ...
0
votes
0answers
18 views

Confused on Power BI embedding

I am trying to embed a report I made onto my company's internal website. I have tried for days to get an AAD Token, but am very confused about the process as well if it's what I even need. I have ...
0
votes
1answer
3k views

How to Conditionally format text in a Card in Power BI

I have a Card in a power BI Dashboard that that displays roughly 6 unique text attributes depending on the input. How do I add a separate color to each attribute, for example if the card displays "...
1
vote
1answer
636 views

How do I read data from Microsoft Graph API into PowerBI?

I'm trying to get a list of subscribed users from my tenant using Microsoft Graph API. I've been using the query https://graph.microsoft.com/beta/subscribedSkus which returns the right information on ...
1
vote
1answer
46 views

Power BI: advanced query relationships

I need to do left joins in my data model in Power BI. I import my model from SQL Server where I have one big fact table with multiple relationships to dimension tables. Power BI only allows me to do ...
2
votes
2answers
710 views

How to remove extremely annoying Power Bi popup?

Since an update, I regularly get a really anoying popup in the DAX editor in powerBI whenever I press ctrl-enter. Does anyone know how to turn this 'feature' off? This is the popup: It is ...
0
votes
1answer
34 views

Unexpected Connections when trying to connect PowerBI to mySQL

When we open Power BI on the desktop client (PBIX file). It will automatically create a connection to the tables that are referenced in the file for some reason. Does anyone know why the connections ...
-1
votes
1answer
28 views

Create table comparing data from multiple date periods

In Power BI I've made a table where I'm comparing values from different date periods. For example, I have the following columns: Last 7 Days Last 14 Days Last 30 Days Last 60 Days Lifetime So I'm ...
2
votes
0answers
27 views

Power BI Report Server Jan 2019 hyperlinks

After upgrading company's Power BI Report Server from Aug 2018 to Jan 2019 version, hyperlinks no longer change color after visited. In previous versions, users would click on a link for the 1st time, ...
0
votes
1answer
3k views

Power BI data refresh timeout

So I have built some dashboards in Power BI that have direct linked data to my access queries that are connected to sql servers. when I refresh them individually they work fine just take some time. ...
0
votes
1answer
811 views

Scheduled refresh not working in Power BI

I just started receiving an error in my scheduled refreshes (and if I select the Refresh Now option) with Power BI Service a few days ago... I don't believe any of my actions changed, but all data ...
0
votes
1answer
28 views

How can I enable users to create dashboards without edit access to the report in Power BI?

I share a workspace with a number of users in Power BI service. I have a report and a dashboard within this workspace, but I would like to allow users to create their own dashboards without giving the ...
0
votes
1answer
1k views

Power query pivot column with multiple records

How can I pivot a table where there is more than one record for a given column heading? See images below - I have transformed data so that it's listed by date, and I want to pivot the table so that ...
0
votes
1answer
45 views

Power Query - Appended Queries pulling from same folder - Need only 1 query to run on new files

I have two queries created in Power Query that pull data from the same folder and are appended. The reason for this is because that folder contains many files with two distinct data structures, one is ...
0
votes
1answer
84 views

Merge Power BI is blocked

I have data divide into three Data from customers (10 000 lines) Location data (10 000 rows for each table) Traffic data Sflow (18 000 000 lines) that I stored in MongoDB. On Power BI when I am ...
0
votes
2answers
1k views

powerbi Web.Contents Error 400

I have request NonWorkHours = Web.Contents("https://mysite.azurewebsites.net" & "/api/v1.0/Report/Setter5", [Headers=[Authorization="Bearer xxx"]]) This request works fine in PowerBI Desktop. ...
0
votes
1answer
370 views

In Power BI Report Server, web service URL is working, web portal URL is not

I had to reinstall Power BI Report Server. I reconnected to the underlying Reportserver database. Since I didn't have a backup of the encryption key, I deleted encrypted content. At this point if I ...
0
votes
1answer
329 views

Power BI Desktop - Number format - shows american format in visuals but European everywhere else

I have created a report in Power BI Desktop. It is not linked to Service. When i created the report i set the regional settings (local file) to danish, so the number and date format would be correct,...