Questions tagged [powerbi-datasource]

622 questions
0
votes
1 answer

How can I use a parameter in a MS Power Bi web data source string?

I have a URL that returns a json object with everything I need for my power bi embedded report. I get the data for the report by adding a new web data source and pasting the URL in. a few transformations later and tada! sexy report. the report …
DasAmigo
  • 333
  • 3
  • 12
-1
votes
1 answer

PBI paginated SUM initial opening balance only

I'm trying to recreate a ERP system report within power BI/paginated. However I'm really struggling with calculating the opening balance group totals for this report, as there is a opening balance for each month within the date range, and when I…
-1
votes
2 answers

How to create slicer from column name

I have a sample table as shown below: Quarter Month Status Debit Digital Internal IVT Risk Q1 Jan'22 Plan 57 92 33 9 60 Actuals 46 92 33 9 60 Feb'22 Plan 58 72 36 8 65 Actuals 50 72 37 8 65 …
-1
votes
1 answer

How to convert 24 Hours format to 12 Hours format using DAX Function / Advance editor data type conversion Using Power BI?

I'm receiving time in 24 hours format from Database but we need to convert that into 12 hours for some calculation purpose. how to convert the same in power bi ex. 10 --> 10:00:00 AM 22 --> 10:00:00 PM
-1
votes
1 answer

How to add a custom column in Power BI

I have a table like this. topic pageviews modelA/a.html 10 modelA/b.html 10 modelB/a.html 10 modelB/b.html 20 And I want to add a directory column like this. It has a mapping from topic to…
-1
votes
1 answer

Power BI reusign datasets

I have one dashboards one with all data from all countries, and I would like one single dashboard for each country reusing the previous dataset. I would like to do that to minimize the space needed in cloud for those dashboards. Also there is users…
-1
votes
2 answers

Apply filter before query editor steps

I have the following scenario. My datasource looks like this: Order Item Type Value 1 1 A 14 1 1 B 10 1 1 C 12 1 2 A 12 2 1 C 19 2 1 D 15 2 2 B 11 Now I apply a few steps…
-1
votes
1 answer

Where can I get the Power BI Dashboard in a Day data

There is a in depth tutorial that leads you through building a dashboard. I can't get started because the first thing is to connect to a cloud resource that doesn't(?) exist. Any help would be great.
Chris The DBA
  • 105
  • 1
  • 9
-1
votes
1 answer

JIRA content pack bringing only few rows on Power BI

I was running the JIRA content pack (https://powerbi.microsoft.com/en-us/blog/explore-your-jira-data-with-power-bi/) on Power BI without any problems until today. But now I'm facing a issue that I cannot fix. The problem is, suddenly the template…
Polly
  • 29
  • 3
-1
votes
1 answer

Integrate jenkins to Power BI

How can I integrate Jenkins to POWERBI, i.e, getting jenkins jobs build and failed And JOb NUMBERS to POWERBI.
-1
votes
1 answer

I only wish to schedule a refresh of some of my data. Is this possible?

Some of my data tables are huge and the data never changes (50 million rows+). And some is quite small and needs regular refreshing. How do I handle this in PowerBI? Any ideas?
FeeFiFoFum
  • 1,719
  • 1
  • 11
  • 18
-2
votes
1 answer

How to count the number of articles(i.e. in progress article and completed ) based on month in Power BI?

I have created a data table like below. Now I want to filter the data based on the month, such as in-progress articles per month and completed articles per month. I have created a measure to show the completed articles till now. Total Published…
-2
votes
3 answers

Power BI service, disable download of Power BI Report

I have published reports from Power BI desktop to Power BI service. I want the users to be able to do their own analysis with the datasets/data model BUT I don't want them to have the ability to download the .pbix file. Note: I am not using premium…
-2
votes
1 answer

Power Bi calender

please I need to make a calendar table to enjoy the privileges of some functions but my date field is formatted with hour minute and seconds and is not related to the automatic calendar that creates power bi. Who can help me gratefully. regards
-2
votes
1 answer

Power BI - Best practice importing big data?

I'm new in the BI field and I have to develop the BI of over 25 million records. I'm using DirectQuery to import the data to PowerBi and to web. But the dashboard loading is too slow. And sometimes the dashboard won't load. I'd like to know what's…
1 2 3
41
42