Questions tagged [powerbi-datasource]
622 questions
1
vote
1 answer
How to use the result of a measure in the filter of a DAX query?
I have a measure in my power bi dataset called Nett Wipp.
I need to write a query that gets some data from my dataset and filters where Nett Wip is not 0.
In plain English my query should be: get me Invoice Recov % where Nett Wip is not 0
(Invoice…
Hedgybeats
- 297
- 1
- 4
- 16
1
vote
1 answer
Power BI :: Do I need a Gateway Connection when importing data from a web page?
I have a dilemma.
I'm picking up data from this page where I can have a clear view of all lithium companies listed on the Australian market. So this means that the data source is... web!
I save and publish the dashboard on my Power BI account and…
Francesco Mantovani
- 10,216
- 13
- 73
- 113
1
vote
0 answers
Error with Custom Connector on PowerBI Enterprise Gateway: ExtensionDataSourceKind
I built a customer connector to access the Vimeo API through OAuth2. The connector works locally on PowerBI Desktop, and is also works on a Personal Gateway. Unfortunately, when I try and deploy it on my company's Enterprise Gateway, I get the…
Overfloweth
- 31
- 1
1
vote
1 answer
How to match the most approximate values of one column with the string column in another table in Power Query of Power BI?
Table 1:
Table 2:
Result:
I have tried using Fuzzy matching but it's not giving me the results.
Please help!
Pri D
- 55
- 4
1
vote
1 answer
PowerBI Cloud - Access dataset from the SQL Server
In the company we have Power BI Cloud, which is already integrated into other system. I was wondering if we could take advantage of this integration and download data from Power BI Cloud dataset directly to our SQL Server (not the other way around,…
Muflix
- 6,192
- 17
- 77
- 153
1
vote
1 answer
One decimal field taking up 75% file size of power bi file
I have a Power bi file which is over a 2gb in size and found one field is taking up 1.5gb of the file size. When I change it to a whole number or decimal it is reduced to 350mb.
I wanted to change to a decimal but I feel it being changed to a…
user3165854
- 1,505
- 8
- 48
- 100
1
vote
0 answers
PowerBI Dataflow: One or more tables references a dynamic data source
I'm unable to save the dataflow if this dataflow includes a simple function
let
Source = (folder as text) => let
Source1 = Folder.Files(folder)
in
Source1
in
Source
it refuses it to be saved with the following…
belzebu
- 810
- 7
- 25
1
vote
0 answers
Simba Athena ODBC Driver with AWS SSO
My company is currently set up to use AWS SSO for access to querying AWS Athena. I have Simba Athena ODBC Driver configured to use IAM credentials I get from the console, but it is annoying process to copy and paste them every time the session…
Edison
- 129
- 8
1
vote
1 answer
Import .BAK in Power BI
Is there any way to import .BAK file in Power BI?
I have backup of SQL Server data and want to import it in to Power BI.
If, in case, it is not possible, than how can I import the SQL Server data to Power BI without any connection.
Thanks in advance
kmax01
- 67
- 9
1
vote
3 answers
How to turn 4.1M 1.22B 3K to numbers in power bi
my data number came in text form, for example: 4.1M 1.22B 3K
Is there a way to turn them back into numbers like 4100000 for 4.1M
Thanks in advance
K.Kao
- 35
- 5
1
vote
0 answers
PowerBI REST API - Failed to create a new datasource on the specified gateway
I'm following this page in order to create a new PowerBI datasource.
And used this kind of body for the POST request:
{
"connectionDetails": "{\"server\":\"aaa\",\"database\":\"bbb\"}",
"credentialDetails": {
"credentialType": "Basic",
…
RaN
- 11
- 3
1
vote
1 answer
Power BI - The column 'Column1' of the table wasn't found error
I am getting below error when I am trying to apply the code and load the query.
The column 'Column1' of the table wasn't found
Here is the sample code of query:
let
BaseUrl = "https://jira.tools.com/rest/api/2/search?jql=project in ('ABC')…
techmaster
- 49
- 2
- 9
1
vote
0 answers
Not able to schedule the dataset refresh in Power BI for Jira Reports
While trying to schedule the dataset refresh for my Power BI Jira report (I am using Power BI Desktop for building the report and getting published to my Power BI account).
I am getting below error:
You can't schedule refresh for this dataset…
techmaster
- 49
- 2
- 9
1
vote
1 answer
Power BI- Need to show data from latest week day
I have a column that displays data from the function today-1 where it shows yesterdays data. I placed it in a filter to only show the "true" values. The issue I am having is I need to show yesterdays data but I need to exclude the weekend.…
k. hens
- 19
- 1
- 4
1
vote
1 answer
Power BI - How to use native query AND query folding for long queries?
I have a Power BI report pulling from SQL Server that needs to be set up for incremental refresh due to the large data pull. As the load is fairly complex (and PQuery editor is tedious and often breaks folding), I need to use a SQL query (aka a…
Josh
- 167
- 1
- 13