Stack Overflow
Stack Overflow

Questions tagged [powerbi-datasource]

622 questions
2
votes
2 answers

programmatically change dataset SQL statement in power bi

Is it possible to change SQL statement of the dataset via API call? My Scenario: I have data in multiple tables in SQL Server. I have created a SQL query with joins to fetch the required data. I created a SQL server dataset by providing that query…
Prathako
  • 91
  • 1
  • 8
2
votes
2 answers

Get values from one table and put in other table based on other column DAX/Power Query M

I need a help. I have one Table A with 2 columns - first is just some name and the other is a value. I have also Table B with 3 columns - fist with some names, second called valMin and third valMax. What I am trying to do is get the name (col1) from…
Rael
  • 149
  • 2
  • 10
2
votes
1 answer

401 - Unauthorized error during Dataset Refresh PowerBI

I am trying to do the Dataset refresh for a PowerBI Report. I created the gateway and I am able to do the dataset refresh from the admin portal. I could validate that the refresh happend successfully from UI i.e. Last Refresh column in the Admin…
Krishnan
  • 958
  • 5
  • 21
  • 44
2
votes
1 answer

How we can pass logged in user name to fetch data from database in PowerBI?

I need to show data only for logged in user in PowerBI. He is manager and in drop down i want to show list of employees under him. Also, only load for all employee whose manager is logged in user We have more than 1 million rows for a day, so I want…
Arun Kumar
  • 21
  • 1
  • 3
2
votes
2 answers

power bi switch is unrecognized in query

Have used the following code to create a custom column but its stuck at the an expression error that it is unable to recognize the SWITCH function : = Table.AddColumn(#"Removed Columns", "Empolyees", each SWITCH([Index], 1, Empolyees = "Chris1", …
Cosq
  • 155
  • 1
  • 2
  • 12
2
votes
1 answer

How to Connect Power Bi to Visual Studio Team Service

Please, I'm trying to connect Power BI to Visual Studio Team Services (VSTS). But, I get the message problem: "The underlying connection was closed: Could not establish relationship of trust to secure channel for SSL / TLS." Someone know how to…
Helio Roots
  • 177
  • 2
  • 10
2
votes
1 answer

Why PowerBI is not showing me the records in Azure Table Storage?

I have connected My Azure table storage account to PowerBI. Storage account has following fields But, after connecting data source to PowerBI desktop application, I only see following screen. See the red bordered screen. Why can't I see the other…
tRuEsAtM
  • 3,517
  • 6
  • 43
  • 83
2
votes
0 answers

Gathering data from rate limited API in Power BI

I've recently discovered that Power BI is available through my enterprise O365 account and I've been asked to start exploring dashboarding for a few of our tools. One of these tools uses a RESTful API to make data available and I have already…
Brian R
  • 785
  • 1
  • 6
  • 13
2
votes
0 answers

Power BI Desktop ODBC connection to Firebird

I have trouble to connect my Power BI desktop to ODBC DSN to Firebird database. My System DSN with Firebird driver is connected successfully from ODBC settings. When I select my DSN (correct DSN is selected) in Power BI Desktop an error…
TomasKincl
  • 21
  • 1
  • 2
2
votes
1 answer

Create Power BI Web Query based on data table

I am using Power BI Desktop to create a web query to the stack overflow API. I want to obtain the number of questions asked on stack overflow for each user which is extracted from a prepopulated table of users in Power BI. So I want something that…
ToDevAndBeyond
  • 1,120
  • 16
  • 24
2
votes
1 answer

Connect AWS PostgreSQL to Power BI Desktop:The specified hostname was not present in the certificate

I am trying to connect my PostgreSQL database to my Power BI desktop. I downloaded the certificate from https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem and installed in my machine. I am getting the same error as follows Details:…
Dency G B
  • 8,096
  • 9
  • 47
  • 78
2
votes
1 answer

How to set default page in power BI Embedded report

I'm using a power-bi Embedded report in my webpage.The report have multiple pages. I need to set the default page based on drop-down selection.Is there any query-string parameter i can use for this? Thanks in advance.
CGN007
  • 131
  • 2
  • 10
2
votes
0 answers

(403) Forbidden Error while accessing https://api.powerbi.com/v1.0/myorg/datasets PowerBI

I got the Authorization token from PowerBi, and while requesting dataset, I receive 403 error. I can verify that this work with Apiary and return result. It is a windows Form Application. My code set is as below string clientID = "{My App Client…
Sudheesh PM
  • 77
  • 8
2
votes
0 answers

PowerBI.com Dataset Refresh for Azure Data Lake with OAuth2

Situation: I have a Power BI desktop workbook with a data source connection to Azure Data Lake storage. I can query the storage and get to the datasets without any problem. I've created my visuals and published the workbook to PowerBI.com. Next: I…
Paul Andrew
  • 3,233
  • 2
  • 17
  • 37
2
votes
1 answer

power bi embedded using no Azure sql server

Currently, I´m tryining to embedded power BI reports in our solution. To do that, I´m using power BI embedded. I have an Azure suscription and there I have created a workspace collection and many workspaces (one for any customer that uses my…
Jorge Diego
  • 21
  • 1
1 2 3
…
41 42