402 questions
0
votes
0
answers
44
views
How to Implement Row-Level Security (RLS) in Power BI with DirectQuery Dataset Embedded via .NET Core
I’m working on embedding a Power BI report that uses a DirectQuery dataset, and I want to implement Row-Level Security (RLS) through my .NET Core backend.
Setup Details:
Report Type: Power BI PBIX ...
0
votes
0
answers
32
views
Power BI Report Builder (SSRS), Filter the contents of a table using the contents of another table, filtered by parameters?
I am trying to define a parametric report using program data. In my Power BI model, this is easily resolved using relationships between the tables, and I am trying to recreate that same amount of ...
0
votes
0
answers
99
views
Paginated report (power bi report builder) take along time to fetch data
I created a power bi report builder
I used a sample query to get data from one table
EVALUATE SUMMARIZECOLUMNS (
'InventRepriceJourTransEntity'[ItemId],
'InventRepriceJourTransEntity'[...
2
votes
1
answer
103
views
Power BI multi language report, adding language to url is not working
I have a PBI report in Premium license type. I have created column in Translations Builder and have saved the report and published.
I added '?language=nl-NL' at the end of the report URL, but it is ...
0
votes
1
answer
174
views
Power BI Report from Power BI report Builder - Trust server certificate not getting supported in VNET data gateway configuration
When I publish the power bi report from power bi report builder to the Power BI workspace with the following connection details, in public setting it works fine. The report loads in 3 secs.
Data ...
0
votes
0
answers
68
views
Power BI report server slow
I have a report in Power BI Report Server on-premise in Import mode. When users open this report, all the server memory is used and it takes a long time to open.
I would like to know if I put the ...
0
votes
1
answer
252
views
Power Bi is taking long time to refresh a report
I have a Power Bi dashboard that has more than 20 tables and the amount of data in the table is quite large. I want to refresh only a specific table at a time. If im clicking the refresh button from ...
0
votes
0
answers
317
views
"PersonalGateway_ShortMessage_PublishingError" in Power BI - 400 response
I'm encountering an error when trying to publish a report to Power BI. The error code I receive is PersonalGateway_ShortMessage_PublishingError. Below are the details of the error message:
Request ID: ...
-1
votes
2
answers
121
views
Create PowerBI report with visualization through API
I have a requirement to generate a PowerBI report including a visualization.
Currently, I am able to generate the semantic layer using the API.
But I have a requirement to also create a visual ...
0
votes
0
answers
176
views
Power BI True/False text column converts to -1/0 when published
I have a report built in Power BI RS version, January 2025 updates applied. I have several columns returning True/False, which I have converted to data type Text in Power Query. I have a page filter ...
-1
votes
1
answer
657
views
Unable to connect to data source in power bi server report to sharepoint site
I have a SharePoint list as a data source, i created a report in PB desktop and connected to SharePoint list using windows creds. This site is FBA enabled. However, its connected and I successfully ...
0
votes
1
answer
156
views
How can I enable external users to access Power BI Report Server without an Active Directory account?
I host my Power BI reports on Power BI Report Server on-premises and would like to share them with users outside my company without requiring an Active Directory account. However, these users don't ...
0
votes
1
answer
51
views
PowerBI dataset refresh in the server not bringing new columns or delete columns
We have a process which build tables dynamically in the Oracle database. That mean, table may add new columns or delete old columns. We have created PowerBI dataset using "select * from table_a ...
0
votes
1
answer
47
views
How to set a date segmenter in Microsoft Power BI?
I need to find a method to put a Date Picker in the reports.
Currently, if I set a fixed start date and end date in the filter, when uploading this report from desktop to online it remains static, ...
-1
votes
1
answer
55
views
While Creating Semantic Layer in directQuery Mode Need to attach with database
As part of report migration project from other technologies to PowerBi.
i am using Fabric Rest APIs (https://learn.microsoft.com/en-us/rest/api/fabric/semanticmodel/items/create-semantic-model)
to ...
-1
votes
1
answer
127
views
Need to Create semantic layer connected with direct database through rest API of power bi
Recently, i have started on one requirement where i need to migrate reports from other technologies to PowerBi
so as part of report migration i am using power bi rest api (https://learn.microsoft.com/...
0
votes
0
answers
78
views
How can I hide a visual on Power BI server, but show on Power BI desktop, like the page-hide option
on Power BI desktop, I set a page to hidden.
I can still see this page on Power BI desktop.
I can not see this page when I view the report in Power BI Server.
How can I accomplish the same for a ...
1
vote
1
answer
49
views
Data Type changes while importing semantic model to new Dashboard
measure e.g. [ccm_TotalDeviceCount] Data Type changes while importing semantic model to new Dashboard, A text data type becomes another data type. I tried refreshing the dataset model, can not find ...
0
votes
1
answer
75
views
Power BI make Measure static Value and dynamic
I have the following data
IF OBJECT_ID('tempdb..#TBL') IS NOT NULL DROP TABLE #TBL
create table #TBL (category varchar(6), Year_Vs_Year VARCHAR(20), Cost INT)
INSERT INTO #TBL VALUES
(null,'24/25 vs ...
0
votes
0
answers
28
views
PBIRS Subscription gives network packet error on random reports
Some reports on PBIRS server regularly give this error.
Other reports which run at almost same time of the day run perfectly.
I've already tried to rename the subscription, change time of the ...
-1
votes
1
answer
492
views
PowerBI Report Server (On Premises)
Does anyone know how to embed PowerBI report (with parameter) into a website?
Currently use an iframe to embed, but the issue is, the parameter cannot be passed. And there are so many ways to embed ...
0
votes
1
answer
987
views
PBI Service is giving refresh error while refresh is working fine on PBI desktop. I have mentioned the image with the exact error, unable to figure
Data source error:
DataSource.Error: OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..
DataSourceKind = ...
0
votes
0
answers
105
views
Layout Report is not rendering in Safari -Powerbi embeded analytics Javascript
We are trying to Embed a Power BI report layout to our application using below JavaScript libraries
powerbi-client v2.19.1 and powerbi-report-authoring v1.1.1 from below reference
showcase-layout
Git ...
1
vote
1
answer
265
views
How to Display Detailed Information on Bar Chart Click in Power BI Report Server Using API Parameters?
I am using an API as a data source in Power BI Report Server. The API has two endpoints:
GET localhost/peoples : Returns a complete list of people.
GET localhost/peoples/{id} : Returns detailed ...
-1
votes
1
answer
291
views
getting error when scheduled refresh reports in power bi
There are some reports in power bi report server. Each of these reports has scheduled refresh times. However, some reports give a memory error error during scheduled refresh. Delays occur in the work ...
0
votes
1
answer
92
views
Display different columns in Power BI based on logged in user
I have a report on the power bi report server. There is a table visual inside this report. At work, my boss wants the salary and mobile number columns in this table visual inside the report to be ...
0
votes
1
answer
72
views
PowerBI Api Get Access Token
I want automatic login to view power bi reports with iframe in mvc application.
For this, I created an application in Azure AD and gave all read permissions in the delegated permissions.
For this i ...
0
votes
1
answer
119
views
How to Download a PDF from Power BI Report in Flutter?
I'm working on a Flutter project where I've integrated a Power BI report. The report is generated based on an API call that I make, and it displays correctly in my app using a WebView package. The UI ...
0
votes
0
answers
76
views
Running an SQL script on demand and showing the results as a table in a published Power BI report
I have a large dataset in a SQL database. I want the user to enter a search string which will then execute an SQL query to pull relevant data that will then show up as a table in the report. I cant ...
0
votes
1
answer
266
views
PBIRS 2023 data driven subscription is causing error in XML?
An error has occurred.
The input XML does not conform to the schema. XML grammar is described in the API documentation. For XML in reports, refer to Report Definition Language syntax.
This error ...
0
votes
2
answers
2k
views
How can I make a Power BI semantic model not demand the presence of a data gateway to get data from the web?
I created a Power BI report that collects data from:
a MySQL database (located on the external server)
a webpage (currency exchange rate table)
When everything worked fine on the Power BI Desktop, I ...
0
votes
0
answers
24
views
How to upload an SQL query to SSRS that returns 5 tables, ensuring that when the report is exported to Excel, these tables appears on separate sheets [duplicate]
Each table has different columns that's why I can not use UNION queries with an additional column to indicate which query produced each row.
Also I tried to use additional parameter and IF - ELSE ...
1
vote
1
answer
199
views
How to refresh the data in an embedded Power BI Report Server Report
We have an on-premise Power BI Report Server.
I have created and published a report that I want to embed in a web page,
then I set up a scheduled data refresh in the power bi portal to be once every ...
0
votes
1
answer
241
views
Is there a way to count the number of reports on a server in SSRS?
I have a lot of reports on SSRS Server, is there a way to query count of all these reports on a specific server.
I didn't try anything as I couldn't find any related answer to my specific question.
...
0
votes
1
answer
229
views
How can you retreive all the reports which use row-level security on a Power BI Report Server?
For example in the SQL view [PBIRS].[dbo].[ExecutionLog3] you can find the logging, but I haven't found any table or view with a boolean or something to indicate that Row-level security is in use. ...
0
votes
1
answer
615
views
Power Bi default date range
I have i date filter in my Power BI report (slicer type between). I need to configure it to default to show data for the last 8 months back from today's date.
I found an option to set up Filter type: ...
0
votes
1
answer
56
views
How to match the corresponding values of Category and Amount columns?
enter image description here
I'm new to power bi.I tried split delimiter by | and it was creating multiple rows with each category matching with each amount value of the same order id. But, I want ...
-1
votes
1
answer
351
views
In a bar visual when i click on specific bar other bars should disappear it should show the same functionality like slicer without any slicer
When we click on "Finance", as a common behavior its just highlights the Finance data, but I want the output as below.
enter image description here
enter image description here
As we all ...
0
votes
1
answer
154
views
Deploying Embedded Power BI Reports for Client-Specific Access: Free Publishing and User Login Setup
How do I share a Power BI report with certain clients using embedded code for free? And could you explain, in simple steps, how to set up secure login credentials for those clients to access the ...
1
vote
0
answers
36
views
Non-editable fields in word table after export from Power Bi paginated report
I need to create a power bi paginated report whose source is mysql. This paginated report should give an export option in word file but Some columns of exported word file should be non-editable. later ...
1
vote
0
answers
64
views
Display current date and time real-time (client side) on published report
I have a report with a column called EventTimestamp. I want to display semi-real time how long ago that was. I get the math portion for date span, but this report is published only once a day. When ...
0
votes
3
answers
1k
views
Publish to web(public) not visible and can't download created report in power BI server
I have created a report in my power bi using create report, but I am not able to download the created report, it is saying "You can't download this report. Refer to power BI documentation for the ...
0
votes
0
answers
14
views
Adding Total in child grouping for SSRS power bi reporting
I am expecting to get the total as below.
I have parent group of batchid and child group of employeename.
I'm having difficulties to get the total after grouping .
how can i get total =7 and =3677.19
...
1
vote
0
answers
111
views
Power BI Report Server: You are not allowed to view this folder
Hello I have installed Power BI Report Server and set it up on my local sql server db.
I am successfully able to launch my web portal page but I get this error below:
How can I resolve this?? It ...
0
votes
0
answers
106
views
I'm having issues with my Power Bi desktop stop refreshing
merchants_and_wallets
Load was cancelled by an error in loading a previous table.
vpay merchant_transaction
Column 'createdon' in table 'vpay merchant_transaction' cannot be found or may not be used ...
1
vote
1
answer
65
views
Power BI report adding thousands separator in two of the columns
I am a complete newbie in PowerBI, so excuse me in advance if this is a stupid question. I have two columns which I would like to add thousands separator to their values.
I would like after the ...
0
votes
1
answer
330
views
PowerBI Embedded Link Filter
is there any way we can filter the POWERBI dashboard by passing the column values inside the link (Publish To Web)?
if not a staright forward way then any workaround?
tried to filter the dashboard by ...
1
vote
1
answer
124
views
Manage Permissions in powerbi report
I would like to remove the access of a list of but it seems to me removing them from RLS.xlsx file is not working.
how to remove workspace (admin) member from the reports and workspaces ?
many thanks ...
1
vote
0
answers
85
views
Slicer in PowerBI Desktop has different format in PowerBI Server, display bug
I've got an issue with the slicer format.
Other users see the slicer correctly (as it is set in PBI Desktop), while I see a totally different format on the PBI Server. I'm not sure if I'm the only one ...
1
vote
1
answer
230
views
How to deal with a connection made to a local datasouce file for a Published PowerBI report
I have a published report with a file lying locally on my computer.
With Path shown by the PowerBI service as "C:\Users\Data\Data.csv"
Now, my Published report is not able to be access and ...