Stack Overflow
Stack Overflow

Questions tagged [powerbi-datasource]

622 questions
4
votes
1 answer

Unable to refresh data in power Bi service while connecting to sharepoint list and document folder of all listed sites

Hi I am currently trying to develop a reporting tool. There is a SharePoint online list which has various SharePoint sites in that list. My objective is to retrieve all SharePoint sites from that list and to connect to the documents folder of all…
Faizan
  • 105
  • 15
4
votes
2 answers

How to connect Power BI to IBM DB2

Currently, I am trying to query data from IBM DB2 and then present it in Power BI. However, I notice the information that Power BI needs is different from what I got from the IBM DB2. The information that Power BI needs is: The connection…
Yipin
  • 61
  • 1
  • 5
4
votes
3 answers

Power BI workspace limits

How many reports can I create in one power bi workspace ? How many datasources can I create over there ? Details: We are going to implement our own application and use Power BI Embedded features. Our app will own all data, thus our users will be…
Alezis
  • 2,659
  • 3
  • 27
  • 34
4
votes
2 answers

One Slicer for Power BI Desktop affecting multiple tables

I'm setting up multiple tables on a single Page in Power BI Desktop, with plans to publish to an App. I'm using SQL Server as a data source to pull the output of three different pre-established System Views. Each of the Views pulls from the same set…
David Martin
  • 95
  • 1
  • 2
  • 9
4
votes
1 answer

Power Bi Dates in Chart

I am trying to solve this problem, I have a table with company_name , articles and each one of them has a price and amount, with a certain date. So this article could be ordered many times. At the end it looks something like this: Company …
NFAL
  • 185
  • 3
  • 20
3
votes
1 answer

How to use Power BI REST API to set Databricks access key on a datasource?

I am trying to set a Databricks access key credential in a Power BI datasource through REST API calls. I own the dataset and can set the key through the Power BI service web UI (app.powerbi.com) But when I try to do this through REST APIs (e.g.,…
wrschneider
  • 17,913
  • 16
  • 96
  • 176
3
votes
2 answers

Is there any REST API to refresh specific table in a Power BI Dataset?

Like a refresh data menu in Power BI desktop. I have exported these datasets from SQL Server database by running stored procedure query.
Sanjay
  • 191
  • 3
  • 17
3
votes
5 answers

Power BI - You cannot see the content of this report because you do not have permissions to the underlying dataset

I have a dataset (SSAS) in workspace A, and a report in workspace A that was also copied in workspace B. People in my organization can see the report in workspace B after I grant them access at report (from workspace B) and dataset (from workspace…
bjnr
  • 3,353
  • 1
  • 18
  • 32
3
votes
2 answers

Power BI Service to GCP (BigQuery)

I have created this power bi report with data in GCP-BigQuery and once is deployed in app.powerbi.com i get this weird error in datasets when i run the report. Not sure what it is ... anyone seeing this error with datasource as Big query ?? Error "…
user2799179
  • 29
  • 1
  • 2
3
votes
0 answers

PowerBI Embedded V2 Direct Query - Azure Sql credentials not updated programatically

I'm programatically creating a workspace and importing a Direct-Query report into PowerBI Embedded V2. Everything works fine except the report data source credentials which are not updated. This is the code for the import flow: await…
Florin D. Preda
  • 1,358
  • 1
  • 11
  • 25
3
votes
1 answer

Programmatically add users in roles in PowerBi Service, when using RLS

I would like to create a sync job, that takes users from an external system, and creates them as users of a datasource, under a specific role: I am struggelig to find a proper API/other way to add users programmatically into these groups.
Henrik Gering
  • 1,769
  • 16
  • 29
3
votes
2 answers

Remove duplicates values based on multiple column with a condition in query editor Power BI

I am new to power bi and would require your help to sort out below issue which I am facing. Basically I am taking three columns into consideration as below: Question: I would like to remove duplicate values from above table based on conditon…
Mahi
  • 37
  • 1
  • 2
  • 7
3
votes
4 answers

Errors when connecting oracle DB with Power BI

I am trying to use Power BI to connect with Oracle 12c Data source, I have looked for multiple solutions and followed the instruction on Microsoft…
Ahmad Saleh
  • 879
  • 2
  • 10
  • 20
3
votes
2 answers

Power Bi dashboard with data entry

It is possible using powerbi pro, to publish online a dashboard that allows a user to either: 1) do data entry (maybe a text box in the UI or entering a table in the data model), and that data would be use only in his or her dashboard? 2) do data…
donpresente
  • 1,230
  • 2
  • 13
  • 24
3
votes
1 answer

How to have multiple column sorts in Power BI desktop/online with directquery

I have matrix visualization with multiple columns say: ProjID ProjName Budget Proj_Status project_duration I want to do a multiple column sort (like in Excel) first on Budget then on Project_duration in Power BI.
ivric
  • 109
  • 1
  • 6
  • 24
1
2
3
…
41 42