Questions tagged [powerbi]

The tag has no usage guidance.

14 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
2answers
318 views

Is it possible to host pbix and rdl files on the same report server instance?

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 ...
1
vote
0answers
12 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
21 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, ...
1
vote
0answers
523 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 ...
1
vote
0answers
104 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 (...
1
vote
1answer
29 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 ...
1
vote
0answers
218 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
75 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 ...
0
votes
0answers
8 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
10 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. ...
0
votes
1answer
55 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 (...
0
votes
2answers
129 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
60 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 ...
0
votes
1answer
37 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 "...