Questions tagged [powerbi-datasource]
622 questions
15
votes
4 answers
Node js App integration with power bi rest Api
Is there a way using power bi rest API in node js, I watched video ,Ran Breuer and Arina Hantsis were showing the demo here,Setting up and Getting Started with Power BI Embedded I want to achieve same but using node js, in our development…

Jo Joy
- 333
- 2
- 14
11
votes
1 answer
Cannot install Microsoft Power Bi Postgre SQL connector
I am trying to use Microsoft Power Bi to connect to a PostgreSQL database.
When I go to Get Data it just says that the connector requires one or more additional components to be installed before it can be used
I have installed Microsoft Power Bi…

ianwuk
- 121
- 1
- 4
10
votes
1 answer
Pass several parameters in StartLogin function
I am building a custom connector to connect to our API via OAuth2. This is so we can use our api as a data source to powerbi.
// Resource definition
Resource = [
Description = "MyAPI",
Type = "Custom",
…

sudeepdino008
- 3,194
- 5
- 39
- 73
9
votes
3 answers
How to connect google sheet with power bi?
I am trying to connect google sheet with power bi using R Studio, there is a video on youtube by stephnie locke, but that is just a short video and dont help completely. any one there which can help properly and completely.

Azam Saleem
- 129
- 1
- 1
- 3
8
votes
4 answers
POWERBI - Object reference not set to an instance of an object
I'm trying to connect oracle database using prowerbi desktop. Throwing following error
Details: "An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'"
Any idea why i see this error? I have…

Praveen Govind
- 2,619
- 2
- 32
- 45
7
votes
3 answers
Power BI Desktop - How to change data source?
When I'm trying to change my existing data source (Microsoft Azure CosmosDB) to Blob Storage, the Change source is disabled. How do I workaround this?
I have gone through various questions but none of them were similar to mine.
Any help is much…

Dee
- 483
- 2
- 11
- 24
7
votes
2 answers
Connecting to private Amazon Redshift from PowerBI service
Our Amazon Redshift is in private subnet an not open to internet. So we want to connect to Redshift from PowerBI online service.
So we installed powerBI desktop inside AWS VPC and able to connect to redshift as both of them are in same private…

wudpecker
- 386
- 6
- 15
7
votes
2 answers
Power BI: Query parameters in an embed request
Does anyone know of a way in Power BI to set query parameters as described here from an embed request instead of inside desktop? We are attempting to setup a system where we use power bi to power visualizations within our app for customers to view…

Evan Snapp
- 523
- 5
- 21
6
votes
1 answer
Power BI embedded, direct query, not refreshing
I have implemented Power BI embedded in a web app with direct query using Azure SQL as data source.
The Azure SQL database is being updated by webjobs and if I leave open the Power BI embedded web app I don't see the visuals refreshing with the new…

donquijote
- 1,642
- 5
- 19
- 41
5
votes
1 answer
How to refresh report that uses custom functions on Power BI Service?
I know this issue has been posted many times before, but I was not able to get a solid/working solution.
I am trying to figure out a workaround for refreshing dataset with Custom functions over Power BI service. My query looks like the following:…

Pratik Bhavsar
- 808
- 8
- 32
5
votes
2 answers
Exporting all data programically from powerBI Visual
I have to export all data from PowerBI visual.
I managed to use a library powerbi.js (https://github.com/Microsoft/PowerBI-JavaScript/wiki/Export-Data) and manage to implement the following solution:
report.page("ReportSection").getVisuals()
…

Marek
- 3,935
- 10
- 46
- 70
5
votes
2 answers
PowerBI doesn't Refresh
I have several PowerBI reports that don't refresh automatically or whenever I press refresh in the website and I have to use PowerBI desktop app to refresh it manually and then save it or publish it again.
The reports use direct queries in MySQL db…

Andrew Ravus
- 451
- 1
- 7
- 14
5
votes
3 answers
How to show value in only first cell in case of duplicate Power BI
I wrote a query in Power BI which returns results like this
Is it possible: For the first column Service Name if value is same in cells than to show value in the first cell and than leaves all the other cells blank until the value is changed, If…

Nouman Bhatti
- 1,341
- 6
- 28
- 54
4
votes
1 answer
Refresh report that uses custom functions on Power BI Service?
I am trying to figure out a workaround for refreshing dataset with Custom functions over Power BI service. My query looks like the following:
Data source for _op_kiekis
let
Source = Loginai_File,
#"Invoked Custom Function" =…

Dmitrij Holkin
- 1,995
- 3
- 39
- 86
4
votes
1 answer
PowerBI - Gateway error with ODBC (Hive) Data source
We have PowerBI report with data source as ODBC (Hive -- connected through MS Hive ODBC driver).
Now, we need to configure gateway so that data can be refreshed periodically.
However, while adding an ODBC data source in Gateway we are getting…

Ruchita P
- 359
- 1
- 4
- 17