402 questions
0
votes
0
answers
38
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 ...
- 1
0
votes
0
answers
88
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'[...
0
votes
1
answer
167
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 ...
- 93
0
votes
1
answer
248
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 ...
-1
votes
2
answers
118
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 ...
- 1
-1
votes
1
answer
638
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 ...
- 48
0
votes
1
answer
50
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 ...
-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
0
votes
0
answers
72
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 ...
- 23
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 ...
- 1,747
-1
votes
1
answer
486
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
0
answers
101
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 ...
- 640
-1
votes
1
answer
280
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 ...
- 19
0
votes
1
answer
67
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 ...
- 1
0
votes
0
answers
72
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 ...
- 1,264
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 ...
- 408
1
vote
1
answer
196
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 ...
- 31
0
votes
1
answer
225
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. ...
- 556
0
votes
1
answer
47
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 ...
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
1
vote
0
answers
56
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 ...
- 680
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
0
votes
0
answers
102
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 ...
0
votes
1
answer
324
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
0
answers
81
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 ...
- 11