Power Bi Questions

0 votes
Please help on below Questions? in power bi service. steps.

1) Access/authorization requests

2) Monitoring of Power BI Datasets/Loads/Performance of Power BI
 3) Evt. Deployment tasks of Datasets to QUA/PRD for Power BI incl. monitoring
 4) Load optimization of Power BI Datasets.
Sep 24 in Power BI by vnk
• 370 points
87 views

2 answers to this question.

0 votes

Hi, @Vnk

1) Access/authorization requests

You need to get an Azure Active Directory (Azure AD) authentication access token. Your app uses a token to get access to Power BI dashboards, tiles, and reports.

  • The first step to get an access token is to get an authorization code from Azure AD. Construct a query string with the following properties, and redirect to Azure AD.
  • After you construct a query string, you redirect to Azure AD to get an authorization code.
  • Once Azure AD redirects back to your web app with an authorization code, you can use it to get an access token.

2) Monitoring of Power BI Datasets/Loads/Performance of Power BI

Monitoring performance is relevant in the following situations:

  • Your Import data model refresh is slow.
  • Your DirectQuery or Live Connection reports are slow.
  • Your model calculations are slow.

Slow queries or report visuals should be a focal point of continued optimization.

answered Sep 24 by Gitika
• 48,800 points
0 votes

Hi, @Vnk,

Despite the efficiencies achieved by the VertiPaq storage engine, it is important that you strive to minimize the data that is to be loaded into your models.

  1. Larger model sizes may not be supported by your capacity. Shared capacity can host models up to 1 GB in size, while Premium capacities can host models up to 13 GB in size. 
  2. Smaller model sizes reduce contention for capacity resources, in particular memory. It allows more models to be concurrently loaded for long periods of time, resulting in lower eviction rates.
  3. Smaller models achieve faster data refresh, resulting in lower latency reporting, higher dataset refresh throughput, and less pressure on the source system and capacity resources.
  4. Smaller table row counts can result in faster calculation evaluations, which can deliver better overall query performance.
answered Sep 24 by Gitika
• 48,800 points

Related Questions In Power BI

0 votes
1 answer

Programmatically sign in - power bi

Basically: POST request to: https://login.microsoftonline.com/common/oauth2/token Body, form-url-encoded: grant_type: "password" scope: "openid" resource: "https://analysis.windows.net/powerbi/api" client_id: ...READ MORE

answered Sep 19, 2018 in Power BI by Kalgi
• 51,970 points
305 views
+1 vote
2 answers

Passing parameters to Power BI filter programmatically

In addition to @Kalgi's answer, there's another ...READ MORE

answered Sep 19, 2018 in Power BI by Nilesh
• 6,980 points
4,943 views
+1 vote
1 answer

Power BI Pivot Colums to Rows

Hey @Nilesh, reshape the data in the ...READ MORE

answered Sep 19, 2018 in Power BI by Kalgi
• 51,970 points
85 views
0 votes
1 answer

create interactive R plots in Power BI

 Right now Power BI only supports render ...READ MORE

answered Sep 20, 2018 in Power BI by Kalgi
• 51,970 points
421 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,120 points
262 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,120 points
1,302 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,410 points
351 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 51,970 points
364 views
0 votes
1 answer

How to replace Blank with "0" in Power BI Visual?

Hi, Sujit You can do this in two ...READ MORE

answered Feb 7 in Power BI by Gitika
• 48,800 points
13,771 views
0 votes
1 answer

How to trim space from Power BI?

Hey, Make sure your column type is set ...READ MORE

answered Feb 6 in Power BI by Gitika
• 48,800 points
1,684 views