Stack Overflow
Stack Overflow

Questions tagged [powerbi-datasource]

622 questions
3
votes
0 answers

Power BI hybrid dataset reports on dashboard not updating

We are using a Pro trial account for Power BI. We are using a hybrid dataset (that's streaming and push) in Power BI. We successfully create dashboards using streaming tiles which can get refreshed as expected using the Card visualization. However,…
sdaviesnz
  • 31
  • 2
3
votes
1 answer

Drilling Down Power Bi Matrix Table

Is there anyway i can disable "Go to the Next level in the hierarchy (Button)" but i want second Button to keep working.
Joyo Waseem
  • 680
  • 8
  • 25
3
votes
0 answers

How to generate power BI report dynamically (By passing parameters to reporting API) without building data model

I did not find a way to generate reports by executing SQL queries directly on database in power BI. I am new to this tool and surprised that we dont have such capability in it. I have a reporting requirement where I need to generate reports on the…
Chetan Shirke
  • 896
  • 4
  • 13
  • 35
3
votes
1 answer

OMS Log Analytics 8MB PowerBI Query Limit workarounds?

So I am querying data directly from OMS Log analytics using PowerBI Desktop, and I believe there is an 8MB hard limit on the data returned by the query. The problem I have is that I need to query about 30 000 rows, but hit the 8MB limit around 18…
Riaan
  • 31
  • 1
3
votes
1 answer

PowerBi - This data source cannot be accessed by data gateway

I tried to publish my report on dashboard. and I get this error This data source cannot be accessed by data gateway. I used direct query from my sql server. I downloaded and installed on-premise data gateway. When I go to Manage Gateway in Power…
yoyo yagami
  • 257
  • 1
  • 5
  • 18
3
votes
2 answers

How to use IP for location in Power BI?

Currently trying to add a map of users, by IP, from an SQL-Server data source. The IP's either map to a wrong location, or don't map at all using Power BI's inbuilt lookup for them. Is there a way to query location via the IP column? Or any known…
Mattcul
  • 242
  • 1
  • 8
3
votes
1 answer

Power BI - Numeric Format

I would like to know how to change the standard format for numbers in Power BI. The software I use separates decimals by coma "000.000,00", but the idea is to set that to US format: "000,000.00". How can I fix that?
Petter_M
  • 435
  • 3
  • 10
  • 20
2
votes
1 answer

Power BI, connect directly to a dataset from a nodeJS app

I have an application that uses data from a DataSet in Power BI, right now, we use a flow under power automate to retrieve this data from and generated endpoint. This is a simple question because I cannot find anything under the MS docs. Is it…
DJ22T
  • 1,628
  • 3
  • 34
  • 66
2
votes
2 answers

RLS in datamarts - where is the DAX option?

in PBI Desktop, it's possible to configure the RLS by Manage Roles and writing the DAX expression for example [Email] = userprincipalname() But how to secure the datamarts? So that if a user connects to this datamart from PBI Desktop, they can only…
malval
  • 29
  • 6
2
votes
0 answers

How can I manage PowerBI report with code

I currently work at a company where I design PowerBI reports for our clients. Having a large number of clients, I would like to automate the process of creating and maintaining the reports with code. In idea, I would like to be able to get the code…
Melvin Moriniere
  • 21
  • 2
2
votes
1 answer

Showing unexpected values in Power BI charts

Please find my expected result below But I am getting result as below where I have choosed Order Id from orders table and Product Id from Order Items tables and I have used below measure order_to_orderitem = CALCULATE(SUM('Order Items'[Unit…
sheetal
  • 43
  • 1
  • 5
2
votes
1 answer

PowerBIAPI - Operation is not supported for selector # - connection details contains parameters" - update ServerName in PowerBI Dataset of the Report

I have a Problem Updating the Server details in the dataset of the uploaded power bi Report. Please Help. Here I used 2 approaches. Approach 1 Used the below method in Microsoft.PowerBI.Api.V2 UpdateDatasourcesInGroup public static void…
Neehar Gadam
  • 43
  • 4
2
votes
0 answers

PowerBI Data Refresh Error: TEAuthTokenExpired. Please update the token and try again

I have two sources (Azure Databrick, SQL Server) for my report. My report uses merge to combine both sources. I can see data has been loaded but after sometime it fails and throws this error: TEAuthTokenExpired. Please update the token and try…
John Mante
  • 21
  • 1
2
votes
1 answer

How to download the entire PowerBi report as an excel

We have designed the report which has Pie and bars chart would need to download the entire report as an excel with the Chart representation. Currently, the report is embedded in the SharePoint page. Would need to download the report from the…
Nanda
  • 49
  • 1
  • 6
2
votes
0 answers

Power BI Gateway Architecture for SaaS

We are a SaaS provider and would like to open up our data to clients through Power BI. Our solution is hosted in AWS with an RDS database and we plan to make the database available through a Power BI Gateway to RDS. I am currently trying to work out…
Thomas
  • 1,119
  • 9
  • 24
1 2
3
…
41 42