Questions tagged [powerbi]
The powerbi tag has no usage guidance.
43
questions
-1
votes
2answers
27 views
Querying tables that are created monthly as one table (a phone PBX)
I've tried asking this question on a specific Power BI forum but no good:
querying tables that are created monthly as one table (a phone PBX)
So I'm wondering if this can be achieved by me having 1 x ...
0
votes
0answers
32 views
How to get a encrypt information from a SSAS Database using Power BI?
I have a database encrypted in my SQL Server instance. To be specific,I used the feature 'Always Encrypted' to encrypt two columns from that database.
This database has a relation with a database with ...
0
votes
0answers
28 views
What establish a session?
As an analyst I'm running multiple queries on our Oracle ERP via Power Query (Power BI). Now, I hit some form of session limit on my default profile's session limit. How do you evaluate how many ...
0
votes
0answers
14 views
Connector in use in Report on Power BI Report Server
Is there a way to determine, on an enterprise level, what data connector(s) is/are in use for each report on a Power BI Report Server instance?
Some appear in the DataModelDataSource table in PBIRS on ...
0
votes
0answers
7 views
Can PowerBI run DAX queries directly on any database?
PowerBI DirectQuery mode translates DAX queries into SQL and runs them on a given DB. It looks like OLAP databases from MS also support running DAX queries. Is there any way to run DAX queries ...
1
vote
1answer
43 views
SQL Dynamic Query based on user input in PowerBI
I am pulling data from inSQL using the SQL Query below:
SET QUOTED_IDENTIFIER OFF
SELECT * FROM OPENQUERY(INSQL, "SELECT DateTime, [X],[Y], [Z], [A]
FROM WideHistory
WHERE wwRetrievalMode = '...
0
votes
1answer
26 views
Power BI refresh dataflow keep a snapshot of data
my requirement is to be able to save the past state of an entity at a certain point of time. Currently when the dataflow is refreshed, the past state is lost and only the current one is displayed. Is ...
0
votes
0answers
47 views
The permissions granted to user '' are insufficient SSRS/Power BI
Does anyone know where to configure the account from this error message?
It does not seem to be set as it is blank and I can't find any documentation
on it.
The error message is coming when a ...
0
votes
0answers
52 views
Would Star Schema be useful for a Lakehouse table accessed from PowerBI?
In a Lakehouse, the data is stored in a datalake (deltalake in to be precise in my case) instead of a data warehouse. The data there is stored in parquet format, which is a columnar format. I am ...
0
votes
0answers
8 views
Restrict Report Refresh Between Two Time Periods
Say a user has a report that refreshes every hour around the clock but as an Admin I do not want it to refresh between 2 and 4 AM.
Is there a way to programmatically restrict a report refresh for 2, 3,...
0
votes
0answers
28 views
Existence of Power Bi Report Server UML
Does anyone have a UML/ERD diagram for Power BI Report Server?
To clarify, is there a way to automatically generate the ERD of a given Power BI report server, or at least for a given report?
1
vote
0answers
44 views
Power BI Capacity/Tenant/Gateway - where does the data sit and flow?
I have a scenario with Power Bi Premium where it has been very difficult to get a straight answer or find information that answers the question.
Our Power BI tenant is located in Australia, our Power ...
1
vote
0answers
187 views
How to configure the client certificate in Power BI desktop to authenticate with mutual TLS
I am trying to connect to a private data source from Power BI desktop. Data source has its own trusted root authority. I created my personal certificate and private key signed by this root CA. I ...
0
votes
0answers
28 views
Power BI Scale Out Data model Refresh Control
What, if anything, controls which server in a PBIRS scale out performs the refresh?
I have 3 servers. One is a Back End server where SQL is installed and contains on premise Power BI Report Server ...
2
votes
1answer
47 views
Where can I find SQL Developer Database examples (scripts) to add data to practice?
Where can I find SQL Developer Database examples (scripts) to add data to practice?
I require SQL scripts that will add tables and data on those tables in order to practice with Power Bi.
1
vote
1answer
175 views
SSRS - : How to make a conditional formatting for matrix by group?
I currently have a report produces a matrix, displayed per user group. (1 user group per page, with 35 user groups/pages)
I want to highlight the row in pink in this condition:
=IIf(Fields!...
0
votes
1answer
839 views
Need help installing ODAC 122011x64 so I can connect ADW to Power BI
So I have successfully installed Oracle DB 19c and connected it to Oracle SQL Developer. I am able to create tables and run queries. Furthermore, I can connect to ADW with both python and SQL ...
0
votes
1answer
20 views
Database Design For reporting comparison results
I'm going to design an table architecture. Here I wanted to compare same data coming from different sources say Source_A and Source_B. I have to compare few attributes and identify
Mismatches
Data ...
1
vote
2answers
751 views
How to reference column of DAX variable?
I have a DAX variable that contains a table. How can I reference a particular column in that variable?
For example, in the below command, the EVALUATE returns an error. But it works if I replace ...
0
votes
0answers
28 views
Help with the complex DAX measure
I am struggling with a DAX measure. Here is the fact and 2 dimension tables I have:
factAction(dimAccountID, dimActionID, Date, ActionQty)
dimAction(dimActionID, ActionCode, ActionDescription)
...
0
votes
1answer
2k views
PowerBi Line Graph: Tooltip has different decimal places
I have a line graph showing water level data.
The graph has a tool tip which displays the values when you hover over with the mouse. See below.
My problem is that the number of decimal places ...
0
votes
0answers
2k views
Installing Oracle 32 or 64 bit on a Windows Server 2019 to Import data into SQL server and use with Power BI
I am an Oracle noob and really struggling with this concept of 32 and 64 bit business with Oracle.
All I really want to do, is import data on a daily basis from an Oracle 12c DW into a local 2019 ...
4
votes
1answer
306 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
125 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
797 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 ...
1
vote
1answer
94 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
72 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
26 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
1answer
37 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
2k 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
104 views
Counting rows in a table based on subtable result
Sample data:
--------------------------------------------------
| Customer | Value |
--------------------------------------------------
| A | 5 ...
0
votes
1answer
1k 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
2k 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
1answer
78 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
178 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
702 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
41 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
2k 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
35 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
5k 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
228 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
89 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 ...
2
votes
2answers
43k 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.
...
