Skip to main content

Questions tagged [powerbi]

The tag has no usage guidance.

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

Generating PowerBI report URLs that include query strings automatically (instead of manually)

All of the documentation and examples I've seen thus far cover how to manually create a URL that includes filters using a query string. It seems programmatically trivial to generate a URL for the ...
Paul π's user avatar
  • 101
0 votes
2 answers
68 views

How to simplify this intersect query?

SELECT * from M left JOIN K on M.id = k.id left JOIN W on K.str = W.str where str = N'أخبار' INTERSECT SELECT * from M left JOIN K on m.id = k.id left JOIN W on K.str = W.str where str = N'فلسطين' ...
simpatico's user avatar
0 votes
2 answers
57 views

How to calculate revenue by sales team if sales agents change teams?

Agents ID | Agent 1 | A 2 | B Teams ID | Team 1 | AA 2 | BB Memberships ID | AgentID | TeamID | Start Date | End Date 1 | 1 | 1 | 2023-...
simpatico's user avatar
-1 votes
1 answer
106 views

Create a category column or a table for each category?

Which is better? Table: Words Columns: ID, Word, ParentWordID, CatID Table: Categories Columns: CatID, Category Or: Table: Words Columns: ID, Word Table: Categories Columns: CatID, Categories ...
simpatico's user avatar
0 votes
0 answers
15 views

How does M:M relation in Power BI behave (cross join or simple filter)?

Generally in a M:M relation I can think of this doing something like a cross join. How does M:M relation in Power BI behave? Is it a cross join or a simple filter just like how a 1:M would behave?
variable's user avatar
  • 3,468
1 vote
0 answers
13 views

PowerBI Data Modeling: Modeling with sub-dimension and sub-facts

We collect test data from network tests. There is common dimensions and facts for all the different tests, But there are also some facets of the dimensions and facts that are unique. If this was an ...
Dr.YSG's user avatar
  • 399
0 votes
0 answers
26 views

Database design question around nested columns vs separate tables

I am working with an API endpoint in Power Query where the data is a bunch of nested tables. When I expand all of those columns I am getting duplicate data (the total count of the rows is nearly 8 ...
21200506's user avatar
0 votes
0 answers
53 views

Limit Power BI slicer to two (2) options

I have a column called "teams" and I want to write a dax statement that will limit user to only two teams at a time. Please remember that Teams is going to be a slicer. Valid Selection = ...
Sam Johnson's user avatar
1 vote
1 answer
42 views

How do I write a Dax statement that returns the current counts whenever I filter for a TEam

Below is my sample table and I'd like to write a Dax statement that returns the current count whenever I filter for Team A or B. Ideally, the current count per team would be on a card in power BI. ...
Sam Johnson's user avatar
0 votes
0 answers
32 views

Extended Events - is that a proof that the issue is not at the SQL Server side?

I have a problem with one PowerBI dashboard and I would like to ask for your advise if my logic is correct. We are migrating a few databases from one server (Server1) to the another one (Server2). At ...
Radek Gąska's user avatar
0 votes
1 answer
589 views

Unable to create linked server to Power BI XMLA endpoint in SSMS

Unable to create linked server to Power BI XMLA endpoint in SSMS and getting below error: The test connection to the linked server failed. Additional information: An exception occurred while ...
Khanjan Shah's user avatar
0 votes
1 answer
187 views

Converting EAVT table into SCD type 2

After a lot of research and head picking, I'm still unable to find a good/clean solution to convert an entity-attribute-value-timestamp table to an scd type 2 dimension. Here's the issue: I have a CRM ...
Rami Ouanes's user avatar
0 votes
1 answer
27 views

Filtering by value parameter

We're embedding PowerBI reports in a web page, and setting filters from our own code. Main fact table is Event, which has a Date and a Duration (in milliseconds). Desired output is something like Date ...
Stu's user avatar
  • 285
0 votes
1 answer
2k views

DAX Calculate the sum of values for a year with start date and end date

I can't manage in DAX, to calculate for a year, the sum of the values which are in this year, I would like the proportion of each of the values in a year according to its starting date and its ending ...
Gabriel Valvin's user avatar
0 votes
1 answer
25 views

Using tablenames from a config table for joins

SELECT $model_master_id$, $model_market_segment$, $country$, $ctry_cd$, $score_run_id$, $period_id$, $prediction_from_dt$, $prediction_to_dt$, $buy_acq$, $...
Reshmi Nair's user avatar
0 votes
1 answer
148 views

In a star scheme, How to define the fact table when the data has different levels of dimensions?

In a PowerBI project, I need some help to define the fact table/s. Eventually, I would like to have a nice star scheme to preset some basic visuals as stacked bar etc. to the client. I'm new to BI and ...
ShayD's user avatar
  • 1
1 vote
3 answers
637 views

Can Power BI change data in the database?

A colleague approached me with a request to install Power BI for him. As I understand it, this software creates various graphs and reports based on data from the database. In this regard, I have a ...
RoyalGoose's user avatar
-1 votes
2 answers
56 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 ...
user125942's user avatar
0 votes
0 answers
103 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 ...
Douwe van der Meer's user avatar
2 votes
1 answer
729 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 = '...
Felix Silva's user avatar
0 votes
1 answer
463 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 ...
Yousra's user avatar
  • 1
1 vote
0 answers
190 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 ...
jezr's user avatar
  • 11
1 vote
0 answers
2k 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 ...
Parth_patel's user avatar
2 votes
1 answer
195 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.
Rodolfo Villalta's user avatar
1 vote
1 answer
853 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!...
user7821021's user avatar
0 votes
1 answer
2k 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 ...
Andrew Hicks's user avatar
0 votes
1 answer
29 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 ...
Avinash's user avatar
  • 105
1 vote
2 answers
5k 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 ...
explorer's user avatar
0 votes
0 answers
34 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) ...
Steve's user avatar
  • 21
0 votes
1 answer
5k 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 ...
Sir Swears-a-lot's user avatar
0 votes
0 answers
3k 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 ...
d18's user avatar
  • 1
4 votes
1 answer
588 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 ...
PeterDaniels's user avatar
1 vote
1 answer
257 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 ...
brndr's user avatar
  • 13
4 votes
2 answers
2k 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 ...
SomeGuy's user avatar
  • 2,013
1 vote
1 answer
158 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 ...
SE1986's user avatar
  • 2,000
0 votes
1 answer
112 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 (...
Sam Axe's user avatar
  • 183
1 vote
0 answers
43 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 ...
mario font's user avatar
1 vote
1 answer
51 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, ...
jdids's user avatar
  • 309
0 votes
1 answer
3k 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 ...
Moses's user avatar
  • 103
2 votes
2 answers
190 views

Counting rows in a table based on subtable result

Sample data: -------------------------------------------------- | Customer | Value | -------------------------------------------------- | A | 5 ...
user169728's user avatar
0 votes
1 answer
2k 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 ...
SomeGuy's user avatar
  • 2,013
2 votes
0 answers
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 ...
Scott Mohler's user avatar
0 votes
1 answer
95 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 ...
John's user avatar
  • 765
1 vote
0 answers
261 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 (...
Andrew's user avatar
  • 11
2 votes
2 answers
911 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 ...
user9666467's user avatar
0 votes
1 answer
63 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 "...
SkinnyPete63's user avatar
3 votes
1 answer
3k 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 ...
hurleystylee's user avatar
1 vote
1 answer
43 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 ...
I'l Follio's user avatar
14 votes
2 answers
11k 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 ...
user avatar
1 vote
0 answers
264 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 ...
Rijnhardt Kotze's user avatar