Stack Overflow
Stack Overflow

Questions tagged [powerbi-datasource]

622 questions
0
votes
1 answer

Power BI Quiz - need clarification on a question

I have this question before me. You plan to use Power BI Desktop to create a report. The report will consume data from an on-premises tabular named SalesDB in Microsoft SQL Server Analysis Services (SSAS). The report will be published to the Power…
user3812887
  • 439
  • 12
  • 33
0
votes
1 answer

Power Query: Replace Value based on other column

I have a dataset of Degree Programs and Colleges that I am working with, but several colleges have had name changes in recent years. +------+------------------------------+------------------+ | Year | College | Program …
Riley Mashburn
  • 5
  • 5
0
votes
1 answer

Power BI subscription for report using SSAS Tabular Model

How do we create subscription for report in Power BI that is using underlying tabular model? Power BI is giving error while creating subscription saying "You cannot subscribe others because this artifact has row-level security or the dataset is…
Akira
  • 47
  • 6
0
votes
2 answers

number of skyscrapers for each country

I am a beginner in Power BI. I am trying to create a column with number of skyscrapers for each country but dont know how to do it. Position Building Name Meters Floors Completed City Country 1 Burj Khalifa …
Bibek Sharma
  • 73
  • 1
  • 2
  • 8
0
votes
1 answer

Power BI - Incremental Refresh

My data source is Blob storage which is around 270MB of data and is taking around 4.5 hours to refresh. So encountered 120 minute timeout issue on power bi service. Therefore gave a try at setting incremental refresh. I don't think I have premium…
Dee
  • 483
  • 2
  • 11
  • 24
0
votes
1 answer

Power BI can't access Godaddy's Database

I have hosted SQL Server database in Godaddy servers, and I am using Power BI desktop at the moment. I can connect to my godaddy's database through SSMS but when I try through MS Power BI I get this error I was sure that credentials are correct and…
asmgx
  • 7,328
  • 15
  • 82
  • 143
0
votes
2 answers

Power BI DirectQuery mode - "Couldn't load the model schema". But able to do transformations in Query editor

I have been trying to connect to a SQL server DB via Power BI Desktop. The connection mode selected is DirectQuery . I am able to establish the connection to the SQL db. But in the report viewer i don't see the table loaded. And i keep getting this…
Rima
  • 545
  • 6
  • 12
0
votes
1 answer

Power BI connector to JIRA

I am trying to access the api of JIRA to retrieve data from my database. 1- I click on web, put the url, click connect, but I get an 400 error (Bad request). 2- I tried then to set the authentication header to basic + user:pasword encoded in base64…
Nelson Gomes Matias
  • 1,787
  • 5
  • 22
  • 35
0
votes
1 answer

How to use the same published PowerBI report with different data sources link?

I am a newbie with PowerBI and I have a need to use the same report created with different link sources, the sources have the same table structure. I use Other - Web as da data source and use a link like…
Eduardo Elias
  • 1,742
  • 1
  • 22
  • 49
0
votes
1 answer

Split custom fields in Power BI

I am getting data from Azure Log Analytics to Power BI using the M Language Query generated directly from the OMS Portal. The issue that, the custom columns are getting loaded into the Power BI in a single column in the below format with the column…
Harry
  • 55
  • 2
  • 10
0
votes
1 answer

Get columns values count using r-script

I want to get the count of column values for Prod1 S# Types Product Name -- ----- ------------ 1 ["A","B","C"] Prod1 2 ["B","C"] Prod1 3 ["A","C"] Prod1 4 ["Z"] Prod2 I want the output for Prod1 in this…
little_big_thoughts
  • 147
  • 5
0
votes
1 answer

Power bi - User retention rate calculation

I'm fairly new to Power bi and have tried and searched for this almost all the forums but couldn't find anything similar to mine. So.. I have a table like the following (Something similar) I would like to calculate the retention rate of the…
Dee
  • 483
  • 2
  • 11
  • 24
0
votes
1 answer

Mashup Data Source Error when using Date field columns in DirectQuery mode

I've nearly 10 visuals in canvas, and the report is running under Snowflake Datawarehouse in DirectQuery mode. Few visuals have date parameter as their coordinates or in filter everything is working as anticipated in PowerBI Desktop version, but…
ashok19r91d
  • 474
  • 6
  • 17
0
votes
1 answer

Updating PowerBI embedded report Connection String does not work

So the issue is as follows : we have multiple tenants, multiple databases hosted on different Azure sql hosts with different Workspaces for every tenant. Since the number of tenants is pretty big, it's not very feasible to generate a report for…
Ndy
  • 326
  • 3
  • 15
0
votes
1 answer

Power BI - Getting data from sources with no direct API

I am working on designing a Power BI dashboard and would require some insights on the source of data. My source of financial data comprises of Kyriba, Bloomberg and ClearWater Analytics. However, no API exists for either of these in Power BI. What’s…
Raj Mehta
  • 1
1 2 3
…
41 42