Questions tagged [powerbi-datasource]

622 questions
1
vote
1 answer

PowerBI API - How to update the credentials for a datasource PER dataset

I am trying to update the credentials used by a PowerBI dataset when connecting to its data source using the Power BI API. However, what is achievable via the PowerBI service UI doesnt seem possible via the API. I have a number of PowerBI reports…
1
vote
1 answer

Power Bi - No CSS selector was found for image URL using Examples

My goal in Power BI (August 2022) is to get the images from this webside: https://www.eima.it/en/elenco_espositori.php?APP=&RAGSOC=&RAGSOC__1=agro&NAZIONE=&POSIZIONE=&SETTORE=&PRODOTTI=&Ricerca=Search So I tried to get data from Web and create a…
Johnny Spindler
  • 358
  • 4
  • 14
1
vote
1 answer

Dynamically create a report

we are trying to implement the following: We will have PowerBI reports for different scenarios. Each scenario has different data but it will use the same visual for the user. Therefore, we need to have a "template" report and when a new scenario is…
1
vote
1 answer

SqlException encountered while accessing the target data source

Unable to create data source.The analysis request operation is timed out before it was completed. Details: Gd Server 80: Received error payload from gateway service with ID 67805: SqlException encountered while accessing the target data…
1
vote
2 answers

Data for most recent date in Power BI for each year

I have to group on agreement number and get the most recent data for each year. My end goal is to view most recent agreement number for each year so that i don't have repeating agreement number for the year. I am getting error while using SQL for…
1
vote
0 answers

How to add horizontal scrollbar for Expanded rows in Power BI Matrix?

I have turned off the stepped layout for the matrix & added more fields to the row section. But I can't Horizontally scroll through the expanded rows section. It's like frozen. Is there any way to scroll that?
1
vote
0 answers

PowerBi Gateway Issues

I am trying to set up a PowerBi Gateway which was there already but was pointed to a different VDI. Now since that VDI is corrupt, I deleted the older gateway connection, and installed the gateway in the new VDI machine. I am able to see a gateway…
1
vote
1 answer

How to update PowerBI Datasource credentials for an Azure AD application (service principal)

I have an Azure AD Service Principal which is the admin of a Azure SQL Database. There is a PowerBI dashboard with a DataSource that connects to the Database. After publishing the dashboard programmatically (CI/CD), I need to update the parameters…
Emer
  • 3,734
  • 2
  • 33
  • 47
1
vote
0 answers

Power BI : implementing column chart with grouped status label?

I want to implement the graph with status label on various transaction status. I have added the reference graph below. transaction status graph In the above graph, x-transaction status , y-transaction count, transaction status are completed,…
1
vote
0 answers

PowerBI Workspace cannot access Azure Synapse SQL Serverless Views

I am connecting to a SQL Serverless endpoint located in my Azure Synapse Account for my PowerBI Datasets. I am reading a SQL view that is composed of some parquet files in my data lake. I am able to connect to the data fine when using PowerBI…
INNVTV
  • 3,155
  • 7
  • 37
  • 71
1
vote
4 answers

Power Bi Desktop- Couldn't load the schema for the database model

Power BI desktop image Downloaded the Power BI desktop version. Installed it. And Opened it. This message popped up. "Couldn't load the schema for the database model" "We couldn't retrieve the data model for this report. Please try again." And also…
1
vote
1 answer

Embedding Dashboard in a Web based tool

Can you embed a power bi dashboard in a webpage which will change its source connection based on some value in the webpage? I have a web based tool where I need to build my visuals. I will get data from an Oracle Database staging table. The visual…
1
vote
0 answers

Data Mart in Power BI service

I am using Premium per user of Power BI service. When I connect to data source list, there are no Microsoft certified custom connector in the list. Please find the image attached here. How to add our certified custom connector in the list?
1
vote
2 answers

Power BI :: Some credentials aren't validated as they are set to skip test connection

My problem is very easy: I'm retrieving all stocks about lithium on the ASX market from this web page. I created a Power BI dashboard that you can visualize here. As the source is Web I would like to refresh it every day using the Gateway…
1
vote
1 answer

How to fix the message The OAuth authentication method isn't supported for this data source in Power BI?

I build a Power BI report using a Sharepoint Site with an Excel, and everything works fine but if I change the data source for a different Sharepoint Site with the same Excel it put me this error: "The OAuth authentication method isn't supported for…