Stack Overflow
Stack Overflow

Questions tagged [powerbi-datasource]

622 questions
0
votes
0 answers

Change Dataset to Support Effective Identity

I attempted an embed with the App Owns Data sample and am unable to implement RLS because "This checkbox is disabled because the current report does not support providing effective user name." So how do I convert my dataset, which is a SQL database…
Sartorialist
  • 291
  • 2
  • 18
0
votes
1 answer

Power BI DAX formulae divide and subtract together

Kindly advice on DAX formulae for calculating divide and subtract together I have Column A, B, C Formulae for calculating % as follow Colum A / (Column B-C) OR A/(B-C) Any advice on how to convert this into DAX formulae will be highly…
SQLfun
  • 53
  • 3
  • 15
0
votes
1 answer

Embedding PowerBI reports and authenticate in web application without using Azure AD

I have embedded power bi report public access url in my web application, which is not authenticated. Is their any way i can authenticate the report without using Azure AD? Please do reply with solution. Thanks in Advance
Pallavi
  • 13
  • 5
0
votes
1 answer

Encryption in M language for Custom Data Connector

Is there a way to encrypt this string in M language "bmVVNG46bmVB". Is it possible to call a C# function or something in M language or if M language has any libraries for standard encryptions like AES/DES let Source = Web.Contents(…
mehwish
  • 199
  • 3
  • 15
0
votes
1 answer

Can PowerBI be integrated with Azure Powershell

If I have Azure Powershell cmdlets, can their outputs be directly streamed to Power BI for rendering with visuals? Thanks!
Daisy
  • 167
  • 1
  • 2
  • 11
0
votes
1 answer

How to create Actuarial Loss Triangle in Power BI Desktop?

I am trying to create Loss Triangle matrix. Examples are…
Serdia
  • 4,242
  • 22
  • 86
  • 159
0
votes
1 answer

How to calculate conflicting meeting using data from Exchange server in PowerBI

I am trying to get data insights of my calendar through visualizations in PowerBI. I am able to get almost all data from my outlook calendar using in-house API in PowerBI. I intend to find how many conflicting meetings I have per week, but I…
Sushruth
  • 43
  • 8
0
votes
0 answers

How to build line chart in power bi for temperature vs date

I have table storage as data source. Data is IoT data and every 10 seconds I get new row with timestamp. I can succesfully connect with Power BI Desktop. I have changed data type as Date/Time. Column name is Timestamp and values is in format of…
user3301440
  • 800
  • 6
  • 13
  • 27
0
votes
1 answer

Is it possible to add new data periods using 'Import' mode in Power bi?

I use 'Import' connectivity mode in Power Bi to get data from SQL server. On the one hand, I can refresh the data for existing time periods. But on the other hand, once the data extended on server and new time periods are added, the new data with…
Artyom Makarov
  • 47
  • 2
  • 7
0
votes
2 answers

how to decode/ get encoding of file (Power BI desktop file)

I am having power BI desktop report(pbix) internal file (DataMashup), which i am trying to decode. My Aim is to create Power-BI desktop report, Data Model using any programming language. I am using Java for initial. files are encoded with some…
Rahul Patel
  • 307
  • 1
  • 9
  • 27
0
votes
1 answer

CRM Odata url 5000 Row limitation + PowerBI

I am working on a POC to explore PowerBI RLS. While working on the POC, I found that the CRM ODATA end point is only returning first 5000 records and it returns a next link with paging cookie. My Query is, How can we utilize this mechanism to get…
SKocheta
  • 133
  • 1
  • 8
0
votes
1 answer

Embed Power BI - view insights of datasets into web applications

Power BI has some cool features like NLP and quick insights of the dataset and dashboard tiles in app.powerbi.com. But while embedding the quick insights feature doesn't come. How to bring that feature of quick insights. NLP can be embed I've the…
user1805948
  • 99
  • 2
  • 8
0
votes
0 answers

M Language (Power Query) Salesforce Web API - Passing Collections?

I am trying to query a Salesforce Datasource using the Salesforce API in Power BI. The issue I am having is that the Salesforce API requires the SOQL to either contain a WHERE clause on the specific query being performed, by using an explicit value…
realtek
  • 831
  • 4
  • 16
  • 36
0
votes
3 answers

Average gives incorrect number Power BI Desktop

I have two columns with OpenTasks and ClosedTasks, both have values either 0 or 1. Then I use matrix grouped by date and want to get an average for each column. But number seems incorrect to me. 0.44 and 0.56 I tried to create measure, but gives…
Serdia
  • 4,242
  • 22
  • 86
  • 159
0
votes
1 answer

Year calculation not showing proper value

I am facing a weird problem. In my .pbix file, i have a date table and a main table. I have calculated "year wise count" in both Power BI and excel. But the problem is that, the numeric figure of the power bi file is not getting matched with the…
Sayan analytics
  • 21
  • 1
  • 4
1 2 3
…
41 42