Stack Overflow
Stack Overflow

Questions tagged [powerbi-datasource]

622 questions
1
vote
1 answer

Best way to store text values to access with PowerBI?

I need to store two text values (user's e-mail and job title) in Azure Blob Storage to feed a dashboard in powerBI. Is this possible in Azure Blob Storage? Am I better off using another datasource? I also want to be able to write values to the…
huyhuyhuy
  • 63
  • 5
1
vote
0 answers

Power BI: How to save slicer selected id in database against that login user

Power BI: How to save Slicer selected value in database against login user.i am using one table on sql server eg. as below if user 1 select 5 option from slicer 1,2,3,4,5 and after click on save button that value should be save in…
varun kulkarni
  • 11
  • 1
1
vote
2 answers

Azure Percept to Stream Analytics to PowerBI DirectQuery connection with PowerQuery calendar

Problem Definition : I have Azure Percept data with a timestamp being fed through Azure Stream Analytics to a PowerBI report. I want to add a custom calendar table and tie it together with a relationship but the datetime data type is not allowing…
Charles Elwood
  • 11
  • 1
1
vote
1 answer

How to clear the data in a Power BI Report when publishing it to multiple clients via DevOps

We are building a generic Power BI Reporting suite for a product. Every time we commit the PBIX file to Source Control our DevOps project publishes the report to multiple workspaces, clears the SQL Connection, and reattaches it to the SQL database…
Rodney
  • 5,417
  • 7
  • 54
  • 98
1
vote
1 answer

How do I configure the Service Principal credentials expiration on refresh to connect Power BI Sql Azure Data Source?

I am using Powershell to update credentials on a Power BI datasource based on Sql Azure. The credentials are that of a Service Principal's, I obtain a Sql access token and submit changes. The payload lokos like this: $UpdateUserCredential = @{ …
puri
  • 1,829
  • 5
  • 23
  • 42
1
vote
2 answers

Is there any Power Bi api available for providing access to Dataset?

I have found api for adding user to workspace(group) as well as Add Datasource user. I would like to know, if there is any api available for adding user to dataset? From the Power Bi Web portal, this is accessed by: Workspace -> Datasets + Dataflows…
Sreejith Sreekumar
  • 13
  • 3
1
vote
1 answer

How to update Azure SQL datasource credentials of PowerBI dataset programmatically?

I have an Azure Devops Process which uses a Service Principle to deploy a Power BI report from a .pbix file and updates the data source to point at the production Azure SQL server. The outcome is that the report and dataset are deployed and the…
Rohith Korupalli
  • 63
  • 5
1
vote
2 answers

Data Source Credentials and Scheduled Refresh greyed out in Power BI Service

I have a problem: I have a PBI file containing three data sources: 2 SQL Server sources + 1 API call. I have separate queries for each respective data source and an additional query that combines all three queries into a single table. Both SQL…
Toots
  • 11
  • 1
  • 2
1
vote
1 answer

How to download Power BI dataset without publishing to web

I'm using a calculated column that is an average. The problem is, the average is above the range of possible values, which should be impossible. I made a calculated column that calculates the average star rating (out of a range of 1-5) and the value…
G H
  • 106
  • 1
  • 1
  • 9
1
vote
2 answers

Connecting Azure Blob Container to Power BI Service

I am was tasked with importing some data to power BI service from an azure container... i was given the Query to import the data. However the query only imports a single file at a time and you have have to import and append each file to your data…
Puno
  • 61
  • 9
1
vote
0 answers

Can PowerBI direct query work with SQL row-level security?

I am trying to implement Direct query report on SQL database with row-level security. PowerBI is not letting me fire a Stored Procedure(sp_set_session_context) in direct query mode. Any help is appreciated.
niteesh.ravi
  • 33
  • 7
1
vote
1 answer

Azure Data Warehouse limitation and suggestion for storagr

I am facing some issue with Azure data warehouse. Currently I am storing all the data include master data and some large core table for the organization. These data set are feeding large amount of power bi dashboard and report. These dashboard…
burberry398
  • 31
  • 2
1
vote
0 answers

Update PowerBI datasource parameters programatically using PBI API

I would like to update my datasource credentials to AzureTable Storage. To know how is the format of the credentials I maked a Get datasources infos on an existing already linked dataset ( via power bi desktop ) { "@odata.context":…
infodev
  • 4,673
  • 17
  • 65
  • 138
1
vote
1 answer

Cannot connect on-premise gateway with postgres on PowerBI

With powerbi desktop I can easily connect with postgres database on server(192.168.1.5:32100) running on a port and a database_name. But doing the same with PowerBI on premise gateway I could not connect when adding a data source on gateway…
Ramin Maharjan
  • 25
  • 1
  • 7
1
vote
1 answer

How to export data from Zoho Expense site to Power BI desktop using the Zoho Creator (Beta) app

I need to export data from Zoho Expense site to Power BI desktop using the Zoho Creator (Beta) app Is that possible? Please let know Also, how can I find the domain, the workspace name, the Application link name and the Report name link as you can…
Newbie SQL
  • 122
  • 13
1 2 3
…
41 42