Stack Overflow
Stack Overflow

Questions tagged [powerbi-datasource]

622 questions
2
votes
1 answer

How Much Content Should You Put on Power BI Desktop Tabs

I am using Power BI Embedded. I have created a .pbix file containing a few tabs worth of visualizations. Each tab contains a TimeLine visualization so I can select timer periods along with several charts and maps. This arrangement looks good in…
Muhammad Rehan Saeed
  • 35,627
  • 39
  • 202
  • 311
1
vote
0 answers

PowerBI Matrix - Each row different calculation

I'm trying to make a PowerBI Matrix where each row is a different calculation. Below is what I would do if it was in Excel. How can I do individual calculated rows in PowerBI Matrix?
DrewSmith
  • 47
  • 1
  • 6
1
vote
1 answer

Change SQL Server database of a web published PowerBI report runtime

I've a PowerBI report with a SQL Server datasource thats retrieves data from a database database_{number}. {number} is a query params of PowerBI. I can change it from Data Transform -> Edit parameters and it works correctly. It's possibile to edit…
Matteo Cappello
  • 13
  • 2
1
vote
1 answer

Get sql query from powerbi report/dataset

can I get SQL query used to create a dataset in PowerBI using the powerbi report/dataset. I no longer have the desktop file (.pbix). I only have the report and dataset in PowerBI Service. I had used couple of joins and a couple of where conditions…
franco mango
  • 107
  • 7
1
vote
0 answers

PowerBI performance monitoring

As a tenant admin in PowerBI, I've access to all system relevant settings. However, i can't see all workspace details of my users. How can i find out automatically, which PowerBI Workspace and User action brings the PowerBI tenant to it's capacity…
R. Maier
  • 340
  • 2
  • 13
1
vote
0 answers

Power Query showing data that cant be filtered nor can be found while merging while some values in the column are working properly

in power query I have data ROE = 23,85 but when I actually trying to filter this value it says this value doesnt exist neither it can be found within merging functions. The situation is printscreened in following: Everything is refreshed,…
Dominik
  • 23
  • 5
1
vote
1 answer

How to refresh a dataset in Power BI Service which uses Python script connector as a source?

I've a report which uses Python script connector as a source. Below is the example of the code. import requests import json import pandas as pd authentication_url = "https://name.api.yyyymanager.com/Authentication/AuthorizeUser" credentials = { …
Shahab Haidar
  • 625
  • 3
  • 11
  • 25
1
vote
0 answers

Data source information is not found in Power BI service

I am currently trying to work through the following tutorial from Power BI: https://learn.microsoft.com/en-us/analysis-services/tom/create-tables-partitions-and-columns-in-a-tabular-model?view=asallproducts-allversions I did everything exactly as in…
Tored
  • 33
  • 5
1
vote
1 answer

Authentication between PowerBI and Azure SQL

Inside Azure, am doing all authentication to my Azure SQL database over Managed identity. However, by authenticating PowerBI on Azure SQL database, there are only "Organization Account" and "Basic Authentication". How can i make the authentication…
R. Maier
  • 340
  • 2
  • 13
1
vote
0 answers

Error to create a Databricks datasource using Power BI Rest API

I successfuly used the "Gateways - Create Datasource" (https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/create-datasource) method from Power BI Rest API to create a SQL datasource, but I´m stuck when I try to create a Databricks…
Rafael Espirito Santo
  • 21
  • 2
1
vote
1 answer

Real time data report in powerbi service

We have a react app where i want to embed a powerbi service report. That report (kept in powerbi service) data will update the user interact with our react app's database. I know there is a way- if we connect that report with an SQL database source,…
navinrangar
  • 904
  • 10
  • 20
1
vote
1 answer

Create a report in powerbi service through APIs in React

We have a React app. What I actually want to do is to send JSON to power-bi service, and on the basis of that json data, powerbi service should create a visual/graphical report for me. I want this whole process to be automated What I have done so…
navinrangar
  • 904
  • 10
  • 20
1
vote
1 answer

How to update credentials of Dataset (based on data flow) using service principal

I am facing an issue while patching the credentials of a data set. Our application is using the service principal to upload PowerBI reports to the respective PowerBI workspace. Most of the report is using Web Api sources, so we are patching the data…
arun
  • 21
  • 3
1
vote
1 answer

Is there a way to get the PowerBI SQL tables and queries being used via powershell?

I am trying to get the tables and the queries that are being used by a PowerBI file. So far, I am able to get all of the data sources using the REST api. But I am having trouble finding a way to get the queries and tables. EDIT: I just want the…
Alex Jokerst
  • 35
  • 1
  • 6
1
vote
1 answer

Recursive, Non-Dynamic (Refreshable) Web API via Power BI

I am trying to write a recursive web API call in PBI to collect all 27,515 records, the oDATA feed has a limit of 1,000 rows. I need this data to be refreshable in the PBI service, therefore these 28 requests via M code cannot be formulated in a…
jessica4255
  • 31
  • 1
1 2 3
…
41 42