Questions tagged [powerbi-datasource]

622 questions
0
votes
1 answer

Power BI visuals tools for custom views

I am trying to use PowerBI-visuals-tools. I am following the steps as per they mentioned. I am able to start the server from command line as below But, in the browser, I am getting blank page. I saw the error in console coming as Visual…
user6250770
  • 680
  • 2
  • 10
  • 25
0
votes
1 answer

When a new data is published in power bi the previous data is erasing

I have prepared chart using a data set in power bi and published, now I want to add another data set from another source, when I publish this data set, the previous data set is erasing off. I need both of them. Could anyone help me please?
Sandeep Reddy
  • 33
  • 1
  • 6
0
votes
1 answer

Is it possible to Refresh data in less than 15 minutes in power bi with on premise database

I'm trying to get real time data in power bi via the on premise gateway, but the minimum time is 15 minutes to refresh the data, is there any way to refresh the data in real time with an on premise dataset?
user673081
  • 9
  • 1
  • 5
0
votes
0 answers

Trying to connect PowerBI to Database sitting on a server

First time I am using PowerBI and trying to get the data source working. What I am doing to connect at the moment: Click on 'Get Data' Select 'SQL Server database' Where it says Server I enter server(ip address name) and the SQL instance name on…
Faiz
  • 273
  • 2
  • 7
  • 21
0
votes
2 answers

Filled Maps in Power BI not working (despite normal maps working!!)

would like to thank you advance. New to Power BI but have found that filled Maps does not working despite working on same data with normal Maps. I am trying to produce a filled map using US States (full state name used). Could this be a bug with…
0
votes
1 answer

Power BI - When changing a column type with Google Analytics, all the column type change

I have some thing like : #"Added Items" = Cube.Transform(#"12345678", { [... some custom dimensions ...], {Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}}, {Cube.AddAndExpandDimensionColumn, "ga:source", {"ga:source"},…
Alxx
  • 65
  • 1
  • 8
0
votes
2 answers

Getting data from website requiring authentication

In PowerBI, I'd like to get data from a website requiring authentication (http://kdp.amazon.com/). Going to New Source, Web, Advanced, doesn't show me anything that looks promising. Hopefully I'm missing something. My ideal would be to go to a…
Sylvia
  • 2,578
  • 9
  • 30
  • 37
0
votes
1 answer

PowerBI - Pivot table drill down functionality

I'm new to POWERBI, and am using it to combine multiple large files and summarize data for me. I'm trying to move away from EXCEL since the files can become large when sharing with others. I want to use ROW LEVEL SECURITY and grant access to…
Dataletx
  • 25
  • 2
  • 9
0
votes
1 answer

Count the number of filtered values

I have a table has 2 columns: I want to summarize these data in new table as follow: what is the expression will help to do this? I dont need to use the MATRIX Regards,
Aboud
  • 3
  • 3
0
votes
1 answer

Column 'No.' of the table wasn't found. Nav2016 data import to PowerBi

I am new to PowerBI and I am trying to get data from Dynamics Nav 2016 in PowerBI Online and I get this error: We couldn't import data from Microsoft Dynamics NAV Make sure you're entering the information correctly. Please try again later or contact…
0
votes
1 answer

Power BI Gateway on-prem server

I have a MSSQL server on-prem and followed the steps from Microsofts Docs in order to install the gateway. Than i managed the gateway via manage gateways within power bi (cloud) and the test there worked and i got the green check. Now the question…
onefox
  • 167
  • 1
  • 13
0
votes
1 answer

Dynamic parameter insertion to filter data in iframed dashboard from with in webapp

We have a web applicaiton used by over 1000 customers. We would like the abilitu to assist over customers to analyse their account level information i.e. Spend analysis, account overview, product overview. What we are looking to find a way of…
Jibran
  • 99
  • 1
  • 1
  • 8
0
votes
0 answers

Visual Missing in Power BI Desktop

I have recently started to learn about Power-BI and have installed Power BI Desktop on Windows 7 x64 vmware-machine. I have installed .NET Framework 4.5.2 and IE 9 on the machine I am able to load data and manipulate the data but the report…
xorpower
  • 17,975
  • 51
  • 129
  • 180
0
votes
1 answer

Power BI Desktop Automatic Refresh

I have developed several reports in power bi desktop and published them to PowerBi.com. These reports are refreshed on daily basis manually. Is there any way that I can refresh the power bi desktop file i.e. .pibx file programmatically or can…
Janjua
  • 29
  • 3
  • 6
0
votes
1 answer

PowerBI - Excel datasource contains JSON in column

I have an excel sheet that has three columns A, B and C. A and B contain regular text. A firstname and lastname, if you will. The third column C contains JSON data. Is there a way I can read this file into PowerBI and have it automatically parse out…
Ray Hogan
  • 319
  • 3
  • 12