Forum Discussion
Power BI web data source won't refresh
Ok. I see something. The problem here is that a Data Refresh means that the data grows in rows. When you need a refresh it's because you have more rows. The source data naturaly won't grow in columns like that csv. That's a wrong way to save data. Adding a column by date isn't a good way to save data. Power Bi with csv will ask you to define the number of columns like the following pictures:
If the data adds a new column the engine won't take it unless you change it in desktop and publish again. The data is not supose to add columns, Power Bi Service refresh won't load it.
The ideal solution would include not to save the data like that. I know you may not have the possibility to change that, so you can try setting more columns than the real amount of columns. That way when a new column is added it might be considered.
Hope that helps,
Ok. I see something. The problem here is that a Data Refresh means that the data grows in rows. When you need a refresh it's because you have more rows. The source data naturaly won't grow in columns like that csv. That's a wrong way to save data. Adding a column by date isn't a good way to save data. Power Bi with csv will ask you to define the number of columns like the following pictures:
If the data adds a new column the engine won't take it unless you change it in desktop and publish again. The data is not supose to add columns, Power Bi Service refresh won't load it.
The ideal solution would include not to save the data like that. I know you may not have the possibility to change that, so you can try setting more columns than the real amount of columns. That way when a new column is added it might be considered.
Hope that helps,
Thank you!!! It works perfectly!