Questions tagged [powerbi]
The powerbi tag has no usage guidance.
27
questions
0
votes
0answers
4 views
How to add a measure as value in PowerBI histogram
I have a simple Power BI visual displaying a histogram of a value. The data is coming from an SQL query. I'm happy with the results, so I have created a DAX measure in a tabular model for the value. ...
0
votes
0answers
35 views
SSRS ReportServer blocking from a CREATE PROCEDURE
We have a PowerBI Report Server that will just continue to load on the homepage (http://reportserver/reports) and just times out after certain minutes. When we investigated the ReportServer database, ...
0
votes
0answers
11 views
How to Script a Database from A local power Bi Data model to SSAS
After connecting SSAS to a local power bi model, I am attempting to replicate the model in the server version of SSAS using Script Database as> Script To > Create to, but the script generated is ...
4
votes
1answer
102 views
Power BI on-prem data gateway for Azure devops pipeline?
I'm building a POC for DB devops using redgate SCA and an azure devops pipeline. Need to connect to our SQL Servers that don't have public IPs. Was hoping power BI on-prem gateway would facilitate. Is ...
1
vote
1answer
53 views
sp_blitzFirst Does Not Output to DB When Run as SQL Job [closed]
I'm an accidental DBA here,
I am attempting to create a SQL Agent Job that will capture the data for sp_blitzFirst. My goal is to start using the PowerBI dashboard to help show our pain points to ...
4
votes
2answers
144 views
Power BI DESKTOP licensing - is it really free to share pbix files?
The Power BI Desktop app for Windows is free, which is great. However, the Microsoft site is loaded with talk of licensing to share/view Power BI content. Is that only for their hosted Power BI ...
0
votes
0answers
12 views
Rolling up/aggregating a duration measure in OrderLine fact table
I am starting to model a datawarehouse, and would like some suggestions.
We have Orders and OrderLines. I have read that it is often recommended to model this as one OrderLine fact table at the ...
0
votes
0answers
17 views
best option for moving from SSRS to Power BI?
One of my customers have an On Premise SQL Server Express edition, using a few SSRS reports for about 20 users.
In order to maintain their system, I need one of their PCs to login to their intranet.
...
1
vote
1answer
44 views
PowerBI Service Account granting duplicate execute permissions on stored procedure almost constantly
I have PowerBi Server (Jan 2019) installed on my server. I can see from the default trace that that the PowerBi Service account NT SERVICE\PowerBIReportServer is granting execute permissions on a ...
0
votes
1answer
59 views
How to secure SQL Server in an enterprise environment?
So I've been tasked with learning how to secure our SQL Servers. Here's the scenario:
Individual users have read access to a table in SQL Server. This table have apx. 33 million rows, and growing (...
1
vote
0answers
16 views
Custom Export from power BI service
I'm trying to make a custom button that exports filtered tables to a csv and downloads them to my computer. I am aware that you can do this with the '...' button but this functionality is for other ...
1
vote
0answers
25 views
After SSRS to PowerBI Reporting Server migration, parameters are rendering goofy when trying to enter data
We just successfully migrated a SSRS 2016 instance to PBIRS. Users are reporting weird behavior when trying to enter data in a multi value parameter.
When they click on a parameter to enter in data, ...
0
votes
1answer
436 views
How to extract multiple key value pairs into distinct columns
I have a database that is outside my control, and am pulling data from it using Power BI for reporting. The database is a list of pages on a website, where each page is a new row, and the columns all ...
2
votes
2answers
57 views
Counting rows in a table based on subtable result
Sample data:
--------------------------------------------------
| Customer | Value |
--------------------------------------------------
| A | 5 ...
0
votes
1answer
720 views
How to get Kerberos working against a named SQL Server instance in Power BI Report Server?
I have a Power BI Report Server working perfectly connecting to SQL Server machines with a default instance only. I can also connect to SSAS named instances with the proper SPNs and by allowing ...
1
vote
0answers
971 views
Getting MAX of AVERAGE measure (Power BI/DAX)
I am stumped. I am calculating an average of products sold per location. Then, I am using AVERAGEX to calculate that average for each sales associate.
But how do I find the MAX of that average and ...
0
votes
2answers
160 views
First Responder Kit Power BI Dashboard - New Databases
With the PowerBi and sp_blitz scripts running in a scheduled task I can get the great dashboard and reports.
However when I add a new database to the server they don't show up in the reports later ...
0
votes
1answer
65 views
Business Intelligence for developers
I'm a developer with apps backed with SQL databases. I want to give my CEO access through BI self-serving tools such as PowerBI or Tableau.
My issue is that the affordable tools all seem to require ...
1
vote
0answers
127 views
Auth failing when using Devart ODBC connector to mLab
I'm trying to connect PowerBI to a mLab-hosted Mongodb instance.
I first tried installing the MongoDB BI-connector, but after installing it didn't show up on the drivers list in Windows ODBC manager (...
2
votes
2answers
435 views
Is it possible to host pbix and rdl files on the same report server instance? [closed]
Just upgraded an existing instance of SQL Server 2014 to 2016. That instance has an instance of Reporting Services installed. My end goal is to connect Power BI Desktop (March 2018) to my existing ...
0
votes
1answer
39 views
Best approach to calculation problem
I am re-developing an application that has been running on Excel. One of the reports I need to recreate (which will be published in Power BI and needs to be a direct query) is as follows;
Column "...
3
votes
1answer
1k views
Minimum credentials on SQL Server to connect via Power BI Desktop
Note: This is not a Power BI issue, this is a DB credential issue.
In Power BI Desktop, I am trying to connect to a database, but I only want that user to have SELECT access.
I have one User that is ...
1
vote
1answer
31 views
How to relate LatLong and State columns on PowerBI
I have two separate tables, one with latitude and longitude columns (for locations in the USA), and the other with the US state abbreviation (TX, AZ, CA, etc).
Is there a way to count the number of ...
9
votes
2answers
3k views
Will SSRS be extinct soon, and PowerBI the new model?
I read SQL Server 2017 will now include PowerBI Server. They also moved SSRS to a different installer, so it will not come packaged in the original SQL Server installation. Does this mean Microsoft ...
1
vote
0answers
225 views
Error while connecting to PowerBi
I am trying to connect PowerBi to a local SQL Server instance.
It has previously worked with a direct Windows Authentication. I tried changing it to a SQL Server Authentication. No luck.
I have ...
1
vote
0answers
81 views
Making a KPI table in SQL or with dax?
I am going to make a KPI table, however I've yet to decided where to make it. In essence its going to show weekly numbers derived from our customer database.
*Weeknumber
*New users (users with ...
1
vote
2answers
20k views
Login Error while connecting SQL Database through Power BI?
I get the error message displayed in Power BI Online when using an enterprise gateway connected to an on-premise SQL Server
Unable to connect: We encountered an error while trying to connect.
...
