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
3 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
40 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
28 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
46 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) ...
0
votes
0answers
36 views

Error connecting to SQL Server in Power BI Desktop

I am a newbie using Power BI and am just trying to install the server-side software to get access to our database informaiton. I am working on a somewhat old setup of Windows Server 2008 R2 and SQL ...
0
votes
1answer
221 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.
0
votes
0answers
53 views

Can't connect to DB2 from Power BI

When I try to connect to a DB2 server using the IBM driver I get this message: Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'System....
0
votes
1answer
20 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
16 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
0answers
9 views

Issue with PowerApps Studio not coming up from inside Power BI

I am inside my Power BI report on app.powerbi.com. I have done the following: Added PowerApps from marketplace Added PowerApps icon to my report Added fields to "PowerApps Data" in the Fields Pane ...
0
votes
1answer
66 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
0answers
44 views

PowerBI internal error, extension of Google Analytics quota

I have unsuccessfully tried to get some data from PowerBi and ran into multiple "internal errors". I have immediately contacted the PowerBI support, which investigated this issue and confirmed that ...
0
votes
1answer
21 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 ...
0
votes
1answer
357 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
212 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 ...
2
votes
1answer
501 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
36 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 ...
0
votes
1answer
396 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
265 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
15 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
0answers
17 views

Power BI, Integrate the sales info from different tables

I would like to compare the sales from KEYWORD table and SALES table by Date. Here is the relationship. Image 1: Image 2: Here is the table I wish I can compare the sales, however, sales from SALES ...
0
votes
0answers
45 views

How to stream data from Azure SQL to Azure Blob/Event Hubs?

I have a random integer program in python which is posting the random integers into an Azure SQL Database The data in the Azure SQL Database is updating in realtime, and I want to stream this data ...
0
votes
1answer
2k 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
407 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 ...
0
votes
1answer
31 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 ...
0
votes
0answers
299 views

Power BI button/bookmark to control multiple pages

I have a Power-BI report that has 4 different coherent formats, each encompassing all 5 report pages. To move between these formats I need to change visibility and other selections in each of the ...
2
votes
2answers
364 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
0answers
38 views

Authentication when embedding Power BI visuals in an external app

When you create your own app, the users you give access to log into this, the app authenticates with Azure Active Directory (AAD) to get the access token, which is then used to pull back the power bi ...
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 ...
0
votes
0answers
56 views

Connecting to master data from SAP BW/4HANA with Tableau

Whenever the SAP BW/4HANA data is accessed from Tableau all the ASDOs can be brought in but the master data is left out. Does anyone know why this is? And has the problem been encountered when using ...
-1
votes
1answer
25 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 ...
0
votes
0answers
50 views

Changing Dashboard Themes for Streaming Data in Power BI

Is it possible to change the color of gauges in streaming dashboards? I've tried updating and creating new JSON theme files, but nothing seems to work when it comes to changing the actual color of the ...
0
votes
0answers
14 views

Power BI Screen Bounces

We resized our Power BI screens by changing the pixel size and saving in the fit-to-width view. Now, the screen bounces when we view the dashboard online. Any idea why it is bouncing? How do we fix ...
2
votes
0answers
22 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
1k 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
0answers
103 views

Add-PowerBIRow -Dataset Powershell command throwing 404 Not found error

I'm using the below code to create a dataset in powerbi. When I'm trying to add a row to the dataset, I'm getting 404 not found error $col1 = New-PowerBIColumn -Name UID -DataType String $col2 = New-...
0
votes
1answer
564 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
23 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
352 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 ...
1
vote
0answers
254 views

Error using Power Bi tool

When I try to refresh data or try to get new data into Power Bi, I am getting the error shown below. I get the error even when running as administrator. Can someone help me on this? An error ...
0
votes
1answer
41 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
51 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
1answer
593 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
236 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
74 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,...
0
votes
1answer
275 views

API with Parameters in Power BI

New to Power BI but hoping someone can point me in the right direction.... I have a API that I use to pull data from an ERP databoard via Postman but it holds various params to make it work see below:...
0
votes
1answer
456 views

Load many csv files at once in Power BI

I received a relational database export where each csv file represents a table. Just 107 files, and i need to import them all to Power BI... Am i out of luck and need to import each of them ...
0
votes
1answer
139 views

PowerBi Order categorical slicer by numerical value in same table

I have a slicer like this: And my data has this format: And I want these values to appear in the order of the weekdayNumber, but my "Sorting by Columns" is keeping itself gray. These are the ...
2
votes
1answer
1k views

Order x axis by month in PowerBi where the months start from 12 - 11

I'm creating a report in Power Bi which I re-fresh each month and display data going back two years on a line graph. Each month the report updates the two year time frame it looks at. For example, ...
1
vote
0answers
50 views

Could Power BI be causing an Access database to corrupt?

I've recently started using Power BI Desktop and have been creating a report pulling data from an Access database. Since starting on the report the Access database has required repairing on 3 ...